arlvl4n.z3r0
شنبه 28 اردیبهشت 1392, 14:37 عصر
سلام من یه کدی نوشتم که می خوام به دیتابیس وصل شه و به کانتر اگه شماره Tel_num با $tel برابر بود یه واحد اضافه کنه ولی این کار رو نمی کنه و به mysql_fetch_row و mysql_num_rows گیر می ده لطفا راهنمایی کنید ممنون
<?php
$con=mysqli_connect("localhost","root","","member" );
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$result = mysqli_query($con,"SELECT * FROM member_site");
echo "<table border='1'>
<tr>
<th>Firstname</th>
<th>Lastname</th>
<th>index</th>
<th>tel</th>
</tr>";
while($row = mysqli_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['name'] . "</td>";
echo "<td>" . $row['family'] . "</td>";
echo "<td>" . $row['counter'] . "</td>";
echo "<td>" . $row['Tel_num'] . "</td>";
echo "</tr>";
}
echo "</table>";
$tel=9196----;
$sms_re='shahram';
$query="select counter from member_site where name='$sms_re' and Tel_num=$tel";
$result=mysql_query($query);
$rownum=mysql_num_rows($result);
if($rownum != 0){
$row=mysql_fetch_row($result);
$counter=$row[0];
++$counter;
$query="update member_site set counter=$counter where name='$sms_re' and Tel_num=$tel" ;
$result=mysql_query($query);
}
mysqli_close($con);
?>
<?php
$con=mysqli_connect("localhost","root","","member" );
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$result = mysqli_query($con,"SELECT * FROM member_site");
echo "<table border='1'>
<tr>
<th>Firstname</th>
<th>Lastname</th>
<th>index</th>
<th>tel</th>
</tr>";
while($row = mysqli_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['name'] . "</td>";
echo "<td>" . $row['family'] . "</td>";
echo "<td>" . $row['counter'] . "</td>";
echo "<td>" . $row['Tel_num'] . "</td>";
echo "</tr>";
}
echo "</table>";
$tel=9196----;
$sms_re='shahram';
$query="select counter from member_site where name='$sms_re' and Tel_num=$tel";
$result=mysql_query($query);
$rownum=mysql_num_rows($result);
if($rownum != 0){
$row=mysql_fetch_row($result);
$counter=$row[0];
++$counter;
$query="update member_site set counter=$counter where name='$sms_re' and Tel_num=$tel" ;
$result=mysql_query($query);
}
mysqli_close($con);
?>