I'm getting errors relate to mysqli

Question

I created forms to show list of product along with two links of edit and delete for each product.

please see list_recorder.php page of php code...

<?php
$host="localhost"; // Host name 
$username="root"; // Mysql username 
$password="xxx"; // Mysql password 
$db_name="shopone"; // Database name 
$tbl_name="product"; // Table name 

// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("shopone")or die("cannot select DB");

$sql="SELECT * FROM product";
$result=mysql_query($sql);
?>

<table width="400" border="0" cellspacing="1" cellpadding="0">
<tr>
<td>
<table width="400" border="1" cellspacing="0" cellpadding="3">
<tr>
<td colspan="4"><strong>List data from mysql </strong> </td>
</tr>

<tr>
<td align="center"><strong>product name</strong></td>
<td align="center"><strong>category</strong></td>
<td align="center"><strong>retial price</strong></td>
<td align="center"><strong>price</strong></td>
<td align="center"><strong>detail</strong></td>
</tr>

<?php
while($rows=mysql_fetch_array($result)){
?>

<tr>
<td><?php echo $rows['product_name']; ?></td>
<td><?php echo $rows['product_category']; ?></td>
<td><?php echo $rows['product_retail_price']; ?></td>
<td><?php echo $rows['product_price']; ?></td>
<td><?php echo $rows['product_detail']; ?></td>


<td align="center"><a href="update.php?product_id=<? echo $rows['product_id']; ?>">update</a></td>
</tr>

<?php
}
?>

</table>
</td>
</tr>
</table>

<?php
mysql_close();
?>

This list are works great and now my next step is to work on edit to allow me to change product information..

please see edit code page which is called update.php page

<?php
$host="localhost"; // Host name 
$username="root"; // Mysql username 
$password="xxx"; // Mysql password 
$db_name="shopone"; // Database name 
$tbl_name="product"; // Table name 

// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("shopone")or die("cannot select DB");

$sql="SELECT * FROM product";
$result=mysql_query($sql);
?>

<table width="400" border="0" cellspacing="1" cellpadding="0">
<tr>
<td>
<table width="400" border="1" cellspacing="0" cellpadding="3">
<tr>
<td colspan="4"><strong>List data from mysql </strong> </td>
</tr>

<tr>
<td align="center"><strong>product name</strong></td>
<td align="center"><strong>category</strong></td>
<td align="center"><strong>retial price</strong></td>
<td align="center"><strong>price</strong></td>
<td align="center"><strong>detail</strong></td>
</tr>

<?php
while($rows=mysql_fetch_array($result)){
?>

<tr>
<td><?php echo $rows['product_name']; ?></td>
<td><?php echo $rows['product_category']; ?></td>
<td><?php echo $rows['product_retail_price']; ?></td>
<td><?php echo $rows['product_price']; ?></td>
<td><?php echo $rows['product_detail']; ?></td>


<td align="center"><a href="update.php?product_id=<? echo $rows['product_id']; ?>">update</a></td>
</tr>

<?php
}
?>

</table>
</td>
</tr>
</table>

<?php
mysql_close();
?>

And when I run list_recorder.php page and I pressed one of edit link from the list, I'm getting errors it said

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\VertrigoServ\www\shopone\admin\cd\update.php on line 19

Which is for relate to $rows=mysql_fetch_array($result); i'm not sure what this error mean and how can i solve that!

please help thanks.

AM

Conrad Lotz · Answer 1 · 2013-10-15T05:21:28.873

0

Try the following where every you pass a $result:

$result=mysql_query($sql) or die($sql."<br/><br/>".mysql_error());

This will provide an error which will lead you to a possible solution.

Then have a look at this line:

<td align="center"><a href="update.php?product_id=<? echo $rows['product_id']; ?>">update</a></td>

Change the opening tag to <?php and ensure that product_id is a valid column field in the database.

edited Oct 15 '13 at 05:21

answered Oct 15 '13 at 05:07

Conrad Lotz

7,702
3
22
27

thanks so much, and i changed that $result line to provide me more error information, and I got more error information but not sure what this mean it said " SELECT * FROM product WHERE product_id='' You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'product_id']; ?>'' " at line 1 ....... any idea! – andy Oct 15 '13 at 05:14
I added onto the answer. – Conrad Lotz Oct 15 '13 at 05:25
i have solved and not showing that errors anymore but i'm showing each text field with echo $rows['product_price']; ?> inside of text field, i even add php like but it got more errors. does this mean is not getting data! any idea what this mean and how to solve that! and to Conrad lotz thanks so much for help that solved first errors. – andy Oct 15 '13 at 05:40

score 0 · Answer 2 · answered Oct 15 '13 at 05:21

try to debug your query, check manually...becouse may be your query failing and I suggest you a little change in your script

$con=mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("shopone", $con)or die("cannot select DB");

Try it if everything is fine then it will sure work

I'm getting errors relate to mysqli

2 Answers2