Getting data from database with php

Question

I want to get the data from my database. The page does not change when I upload the file. Where am I wrong?

verifycheck.php

<?php
$con=mysql_connect ("###", "###", "###");
mysql_select_db ("db_name", $con);


$result = mysql_query($con,"SELECT * FROM db_tablename");


echo "<table border='1'>
<tr>
<th>username</th>
<th>email</th>
<th>password</th>
<th>confirm_password</th>
</tr>";

while($row = mysql_fetch_assoc($result)) {
  echo "<tr>";
  echo "<td>" . $row['username'] . "</td>";
  echo "<td>" . $row['email'] . "</td>";
  echo "<td>" . $row['password'] . "</td>";
  echo "<td>" . $row['confirm_password'] . "</td>";
  echo "</tr>";
}

echo "</table>";

mysql_close($con);
?>

What file do you upload? If your mysql parameters correct and has true column names in table and that table has some values, your code should work. — HddnTHA
– HddnTHA, Commented May 30, 2014 at 11:13
I believe that the problem is not in this code, since the OP mentions: The page does not change when I upload the file. — Ofir Baruch
– Ofir Baruch, Commented May 30, 2014 at 11:15
It's simple, the connection variable comes at the end and not at the beginning; unlike mysqli_ — Funk Forty Niner
– Funk Forty Niner, Commented May 30, 2014 at 11:15
@Fred-ii- I think that instead of changing the position of the parameter so it will fit mysql_ , he should leave the position of that parameter and start using mysqli_ :) — Ofir Baruch
– Ofir Baruch, Commented May 30, 2014 at 11:16

Manwal · Accepted Answer · 2014-05-30 11:14:31Z

1

Connection object should be second parameter and query string should be first parameter.

Try this

$result = mysql_query("SELECT * FROM db_tablename",$con);

Instead of

$result = mysql_query($con,"SELECT * FROM db_tablename");

Mysql function is deprecated and will remove in future go for Mysqli or PDO for preventing sql injection

answered May 30, 2014 at 11:14

Manwal

23.9k15 gold badges65 silver badges95 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user3688398 Over a year ago

I tried it but the webpage is still not showing the data from the database.

Pupil · Accepted Answer · 2014-05-30 11:34:35Z

0

Remove $con, from the mysql_query

As mysql_query() expects first parameter to be the SQL Query, not the SQL connection.

$result = mysql_query("SELECT * FROM db_tablename");

answered May 30, 2014 at 11:34

Pupil

24k6 gold badges49 silver badges71 bronze badges

Comments

Elangovan · Accepted Answer · 2014-06-08 23:37:03Z

0

Please Check with your connection parameters as localhost,username password, database and also changing the

  $result = mysql_query($con,"SELECT * FROM db_tablename"); 
   as 
   $result = mysql_query("SELECT * FROM db_tablename",$con);

answered Jun 8, 2014 at 23:37

Elangovan

3,6184 gold badges34 silver badges39 bronze badges

Collectives™ on Stack Overflow

Getting data from database with php

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related