We are going to see how can fetch the result from mysql table using php.
1. First you need to connect your Mysql database using php script like below:
mysql_connect('server_name','username','password');
mysql_select_db('db_name');
where,
- server_name means localhost,
- username is username of your database
- password is password of your database
- db_name is name of your database
2. Then select the values which is present is table using mysql query.
" SELECT * FROM table_name "
Use above query, if you select all values in table. Otherwise you need to use 'WHERE' clause to retrieve desired data from table.
3. Then you have to use MYSQL function to retrieve data from table such as mysql_fetch_array(), mysql_fetch_row(), and mysql_assoc.
where,
mysql_fetch_array() returns row as numeric array, associative array or both.
mysql_fetch_row() returns numeric array corresponds to fetched row.
mysql_fetch_assoc() returns row as an associative array.
Consider following example:
Now you'll get output like this:
Now you'll get output like this:
Suppose you'll use
echo'<tr><td>'.$res[0].'</td><td>'.$res[1].'</td><td>'.$res['game_Title'].'</td></tr>';
That means you use associative index instead numerical, then you will get undefined index error like as follows as:
Now you'll get output like this:
Suppose you'll use
echo'<tr><td>'.$res[0].'</td><td>'.$res['category_Name'].'</td><td>'.$res['game_Title'].'</td></tr>';
That means you use numeric index instead associative, then you will get undefined offset error like as follows as:
1. First you need to connect your Mysql database using php script like below:
mysql_connect('server_name','username','password');
mysql_select_db('db_name');
where,
- server_name means localhost,
- username is username of your database
- password is password of your database
- db_name is name of your database
2. Then select the values which is present is table using mysql query.
" SELECT * FROM table_name "
Use above query, if you select all values in table. Otherwise you need to use 'WHERE' clause to retrieve desired data from table.
3. Then you have to use MYSQL function to retrieve data from table such as mysql_fetch_array(), mysql_fetch_row(), and mysql_assoc.
where,
mysql_fetch_array() returns row as numeric array, associative array or both.
mysql_fetch_row() returns numeric array corresponds to fetched row.
mysql_fetch_assoc() returns row as an associative array.
Consider following example:
Fetch results from mysql table using mysql_fetch_array() in php:
<html>
<body>
<table>
<th>Game_ID</th><th>Category</th><th>Title</th>
<?php
mysql_connect('localhost','root','') or die(mysql_error());
mysql_select_db('new') or die(mysql_error());
$query=mysql_query('select * from table1') or die(mysql_error());
while($res=mysql_fetch_array($query))
{
echo'<tr><td>'.$res['game_ID'].'</td><td>'.$res[1].'</td><td>'.$res['game_Title'].'</td></tr>';
}
echo'<table>';
?>
</body>
</html>
<body>
<table>
<th>Game_ID</th><th>Category</th><th>Title</th>
<?php
mysql_connect('localhost','root','') or die(mysql_error());
mysql_select_db('new') or die(mysql_error());
$query=mysql_query('select * from table1') or die(mysql_error());
while($res=mysql_fetch_array($query))
{
echo'<tr><td>'.$res['game_ID'].'</td><td>'.$res[1].'</td><td>'.$res['game_Title'].'</td></tr>';
}
echo'<table>';
?>
</body>
</html>
Now you'll get output like this:
Fetch result from mysql table using mysql_fetch_row() in php:
<html>
<body>
<table>
<th>Game_ID</th><th>Category</th><th>Title</th>
<?php
mysql_connect('localhost','root','') or die(mysql_error());
mysql_select_db('new') or die(mysql_error());
$query=mysql_query('select * from table1') or die(mysql_error());
while($res=mysql_fetch_row($query))
{
echo'<tr><td>'.$res[0].'</td><td>'.$res[1].'</td><td>'.$res[2].'</td></tr>';
}
echo'<table>';
?>
</body>
</html>
<body>
<table>
<th>Game_ID</th><th>Category</th><th>Title</th>
<?php
mysql_connect('localhost','root','') or die(mysql_error());
mysql_select_db('new') or die(mysql_error());
$query=mysql_query('select * from table1') or die(mysql_error());
while($res=mysql_fetch_row($query))
{
echo'<tr><td>'.$res[0].'</td><td>'.$res[1].'</td><td>'.$res[2].'</td></tr>';
}
echo'<table>';
?>
</body>
</html>
Now you'll get output like this:
Suppose you'll use
echo'<tr><td>'.$res[0].'</td><td>'.$res[1].'</td><td>'.$res['game_Title'].'</td></tr>';
That means you use associative index instead numerical, then you will get undefined index error like as follows as:
Fetch results from mysql table using mysql_fetch_assoc() in php:
<html>
<body>
<table>
<th>Game_ID</th><th>Category</th><th>Title</th>
<?php
mysql_connect('localhost','root','') or die(mysql_error());
mysql_select_db('new') or die(mysql_error());
$query=mysql_query('select * from table1') or die(mysql_error());
while($res=mysql_fetch_assoc($query))
{
echo'<tr><td>'.$res['game_ID'].'</td><td>'.$res['category_Name'].'</td><td>'.$res['game_Title'].'</td></tr>';
}
echo'<table>';
?>
</body>
</html>
<body>
<table>
<th>Game_ID</th><th>Category</th><th>Title</th>
<?php
mysql_connect('localhost','root','') or die(mysql_error());
mysql_select_db('new') or die(mysql_error());
$query=mysql_query('select * from table1') or die(mysql_error());
while($res=mysql_fetch_assoc($query))
{
echo'<tr><td>'.$res['game_ID'].'</td><td>'.$res['category_Name'].'</td><td>'.$res['game_Title'].'</td></tr>';
}
echo'<table>';
?>
</body>
</html>
Now you'll get output like this:
Suppose you'll use
echo'<tr><td>'.$res[0].'</td><td>'.$res['category_Name'].'</td><td>'.$res['game_Title'].'</td></tr>';
That means you use numeric index instead associative, then you will get undefined offset error like as follows as:
Finally you can retrieve data from mysql table using php.
What is the difference between mysql_fetch_array(), mysql_fetch_row(), and mysql_assoc ?
ReplyDeleteMysql_fetch_array():
ReplyDeleteIt return values as both an associative and numeric array. So you can get values using both associative and numeric array index.
visit: http://www.phponwebsites.com/2014/03/php-mysql-fetch-array.html
Mysql_fetch_row():
It return values as numeric array only. Here you can't get values using associative array index.
Visit: http://www.phponwebsites.com/2014/03/php-mysql-fetch-row.html
Mysql_fetch_assoc():
It return values as an associative array. Here you can't get values using numeric array index.
visit: http://www.phponwebsites.com/2014/03/php-mysql-fetch-assoc.html
hi,
ReplyDeletei want to ask how do we display the table after we selected an option from ajax drop down list?
Hi Guru, please help me retrieve a specific row or column for each currently logged in user?
ReplyDeletethat is, i have three columns for table1, id /password/balance
now i want id333 to see just his/her balance500??
This is you wanted:
Delete$id = 333;
$q = mysql_query("select balance from table_name where id = $id");
$res = mysql_fetch_assoc($q);
echo 'balance is ' . $res['balance'];