Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- //Step1
- $db = mysqli_connect('localhost','webcrawler','secret','webcrawler')
- or die('Error connecting to MySQL server.');
- ?>
- <html>
- <head>
- </head>
- <body>
- <h1>PHP connect to MySQL</h1>
- <?php
- //Step2
- $query = "SELECT * FROM document";
- mysqli_query($db, $query) or die('Error querying database.');
- $result = mysqli_query($db, $query);
- $row = mysqli_fetch_array($result);
- while ($row = mysqli_fetch_array($result)) {
- echo $row['url'] . ' ' . $row['title'] . ': ' . $row['text'] . ' ' . $row['links'] .'<br />';
- }
- //Step 4
- mysqli_close($db);
- ?>
- </body>
- </html>
Add Comment
Please, Sign In to add comment