Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- PHP not displaying MYSQL result
- $dbhost = 'localhost';
- $dbuser = 'root';
- $dbpass = 'root';
- $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
- $dbname = 'test';
- mysql_select_db($dbname);
- mysql_select_db("test", $conn);
- $result = mysql_query("SELECT * FROM new_table");
- while($row = mysql_fetch_array($result))
- {
- echo $row['test1'] . " " . $row['test2'] . " " . $row['test3'];
- echo "<br />";
- }
- mysql_close($con);
- $result = mysql_query("SELECT * FROM new_table");
- $result = mysql_query("SELECT * FROM new_table") or die(mysql_error());
- mysql_close($con);
- mysql_close($conn);
- ini_set('display_errors','On');
- ini_set('error_reporting',E_ALL);
- mysql_select_db("test", $conn) or die(mysql_error());
- mysql_select_db($dbname) or die(mysql_error());
- $result = mysql_query("SELECT * FROM new_table") or die(mysql_error());
- <?php
- $result = mysql_query("SELECT * FROM new_table");
- if(!$result)
- die('SQL query failed: ' . mysql_error());
- $result = mysql_query("SELECT * FROM new_table") or die("error:".mysql_error());
- try
- {
- $db = new mysqli("localhost","root","root","test");
- if ($db->connect_errno) {
- throw new Exception($db->connect_error);
- }
- if ($result = $db->query("SELECT * FROM new_table")) {
- printf("Select returned %d rows.n", $result->num_rows);
- while($row = $result->fetchAssoc())
- {
- echo $row['test1'] . " " . $row['test2'] . " " . $row['test3'];
- echo "<br />";
- }
- /* free result set */
- $result->close();
- }
- $db->close();
- }
- catch(Exception $e)
- {
- printf("Database Error: %sn", $e->getMessage());
- exit();
- }
Add Comment
Please, Sign In to add comment