SHOW:
|
|
- or go back to the newest paste.
| 1 | <?php | |
| 2 | // Get the html returned from the following url and scrape from it | |
| 3 | $html = file_get_contents('http://www.phoenixpark.ie/newsevents/2013/title,24194,en.html');
| |
| 4 | ||
| 5 | $park_doc = new DOMDocument(); // Declare a new DOM object | |
| 6 | ||
| 7 | libxml_use_internal_errors(TRUE); // Disable libxml errors | |
| 8 | ||
| 9 | if(!empty($html)) // If any html is actually returned | |
| 10 | {
| |
| 11 | $park_doc->loadHTML($html); | |
| 12 | libxml_clear_errors(); //remove html errors | |
| 13 | ||
| 14 | $xpath = new DOMXPath($park_doc); //DOMXPath allows queries with the DOM document. | |
| 15 | ||
| 16 | // Perform xpath query to find information | |
| 17 | $event_title = $xpath->query('//h1[not(@class)]'); //gets the event title, ignores any other h1 headings on the page
| |
| 18 | } | |
| 19 | ||
| 20 | //-------------------------CONNECTION AND INSERTION INTO DATABASE--------------------------- | |
| 21 | $username = 'root'; | |
| 22 | $password = ''; | |
| 23 | $database = 'park'; | |
| 24 | $host = 'localhost'; | |
| 25 | ||
| 26 | $con = mysqli_connect($host, $username, $password, $database); | |
| 27 | ||
| 28 | // Check connection | |
| 29 | if (mysqli_connect_errno()) | |
| 30 | echo "Failed to connect to MySQL: " . mysqli_connect_error(); | |
| 31 | else | |
| 32 | echo "</br></br>Connected...</br>"; | |
| 33 | ||
| 34 | //Check if database is found | |
| 35 | $db_found = mysqli_select_db($con, $database)or die("cannot select DB");
| |
| 36 | if ($db_found) | |
| 37 | {
| |
| 38 | - | print "Database Found </br>"; |
| 38 | + | |
| 39 | mysqli_select_db($con, $database)or die("cannot select DB");
| |
| 40 | ||
| 41 | $sql = "INSERT INTO events (title) | |
| 42 | VALUES | |
| 43 | ('$event_title')";
| |
| 44 | ||
| 45 | mysqli_query($con, $sql); | |
| 46 | ||
| 47 | print "Inserted"; | |
| 48 | } | |
| 49 | else | |
| 50 | print "Database NOT Found "; | |
| 51 | ?> |