Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $servername = "localhost";
- $username = "root";
- $password = "123456";
- $dbname = "myDB";
- // Connecting, selecting database
- $link = mysql_connect($servername, $username, $password)
- or die('Could not connect: ' . mysql_error());
- echo 'Connected successfully';
- mysql_select_db($dbname) or die('Could not select database');
- // Performing SQL query
- $query = 'SELECT * FROM WSWT';
- $result = mysql_query($query) or die('Query failed: ' . mysql_error());
- // Printing results in HTML
- echo "<table>\n";
- while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
- echo "\t<tr>\n";
- foreach ($line as $col_value) {
- echo "\t\t<td>$col_value</td>\n";
- }
- echo "\t</tr>\n";
- }
- echo "</table>\n";
- // Free resultset
- mysql_free_result($result);
- // Closing connection
- mysql_close($link);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement