Issues with Basic PHP echo

[barryflood22]

I am having issues with a basic PHP echo script. I am trying to echo all titles in a table, the table name is right and the database is connecting as I am getting a "connected" message appearing on screen, apart from that i'm getting absolutely nothing being output.

 

I have removed the passwords for obvious reasons.

<?php
	$host = 'localhost';
	$user = '';
	$db = '';
	$password = '';
	
	// Create connection
$con=mysqli_connect($host,$user,$password,$db);

// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }
  else echo "connected";
  ?>
  
  
  
  <?php
  
$result= mysql_query("SELECT * FROM jos_content");
 while($row = mysql_fetch_array($result)){
      echo $row['title'];
 }
?>

[Ch0cu3r]

You cannot use mysqlI_* (mysql improved) functions and mysql_* (original) functions together. You can only use one or the other, personally I'd use mysqli as the original library is deprecated and could be removed from future versions of PHP. 

[barryflood22]

Just changed it to this but still no luck

<?php
	$host = 'localhost';
	$user = '';
	$db = '';
	$password = '';
	
	// Create connection
mysql_connect($host, $user, $password, $db) or die(mysql_error());
echo "Connected to MySQL<br />";
  ?>
  
  <?php
  
$result= mysql_query("SELECT * FROM jos_content");
 while($row = mysql_fetch_array($result)){
      echo $row['title'];
 }
?>

[barryflood22]

Got it working with this script

<?php
	$host = 'localhost';
	$user = '';
	$db = '';
	$password = '';
	
	// Create connection
$link = mysql_connect($host, $user, $password);
mysql_select_db($db, $link);

$result = mysql_query("SELECT * FROM jos_content", $link);
while($row = mysql_fetch_array($result)){
      echo $row['title'];

}
  ?>
  
  
  

[Ch0cu3r]

I still recommend mysqli

<?php
	$host = 'localhost';
	$user = '';
	$db = '';
	$password = '';
	
	// Create connection
$con=mysqli_connect($host,$user,$password,$db);

// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }
  else echo "connected";
  ?>
  
  
  
  <?php
  
$result= mysqli_query($con, "SELECT * FROM jos_content");
while($row = mysqli_fetch_assoc($result)){
      echo $row['title'];
}
?>

[barryflood22]

thanks, fully working now :-)

[Barand]

 

I still recommend mysqli

 

 

+1

 

You are going to have to change from mysql_* functions at some point. The sooner you change the less you will have to rewrite when they stop working completely (which will be when you upgrade to PHPv5.5 or later)

[ginerjm]

I'm still wondering why it works when you don't select a database name.

[JIXO]

Hi,

 

I'm still wondering why it works when you don't select a database name.

 

The username, password and database name were removed when pasted here for sure :

 

 

I have removed the passwords for obvious reasons.

[ginerjm]

I saw the part about the passwords, but it didn't mention dbname. 

[Barand]

I saw the part about the passwords, but it didn't mention dbname. 

 

mysql_select_db($db) on line 9 of reply #4

[JIXO]

It didn't mention removing database username too   , but obviously there is no way the code is fully working without specifing a database name