Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- insert data into a database with prepared statements pdo
- $hostname = 'XXX';
- $database = 'XXX';
- $username = 'XXX';
- $password = 'XXX';
- $database = new PDO("mysql:host=$hostname;dbname=$database", $username, $password);
- function get_data($url)
- {
- $ch = curl_init();
- $timeout = 5;
- curl_setopt($ch,CURLOPT_URL,$url);
- curl_setopt($ch,CURLOPT_RETURNTRANSFER,1);
- curl_setopt($ch,CURLOPT_CONNECTTIMEOUT,$timeout);
- $data = curl_exec($ch);
- curl_close($ch);
- return $data;
- }
- $html = get_data($_GET['url']);
- preg_match_all('/<font face="Arial"><strong>(.*)<br><font color/', $html, $name);
- preg_match('/<strong>([A-Zs0-9]+) BIRTHDAYS</strong>/', $html, $date);
- for ($i=0, $n=count($name[1]); $i<$n; ++$i) {
- try {
- $insert = $database->prepare("INSERT INTO bday (name, birthdate) VALUES (:name, :date)");
- $database->bindParam(':name', $name[0][$i]);
- $database->bindParam(':date', $date[1]);
- $insert->execute();
- }
- catch (PDOException $e) {
- echo $e->getMessage();
- }
- }
- $content = file_get_contents('filename');
- $line = explode('n', $contents);
- $ct = count($arr);
- while($i < $ct)
- {
- $arr = explode(',', $line[$i]);
- /* Insert into database value $i, $arr[1], $arr[2], just ignore $arr[0] which contains your original string */
- $i++;
- }
- $array = explode("n",file_get_contents("file.txt"));
- foreach($array as $count => $line) {
- $array[$count] = str_replace('xxx',$count+1,$line);
- }
Add Comment
Please, Sign In to add comment