[Resolved] [Resolved] MySQLi Template Problem

pradeepmamgain

I am facing one more problem with MySQLi. I have a table stock under 'test' database. It has fields id (not null auto incremetal), name (varchar 30) and expirydate. Select query shows following result..

mysql> select * from stock;
+----+---------------------+----------+------------+
| id | name | stockqty | expirydate |
+----+---------------------+----------+------------+
| 1 | Ampoxin 2500 mg Tab | 100 | 2007-07-31 |
| 2 | Ampoxin 500 mg Tab | 250 | 2008-09-30 |
| 3 | Frez DS | 2500 | 2009-09-30 |
| 4 | Vizlac DP | 3500 | 2005-08-31 |
| 5 | Cough'Z Killer | 50 | 2008-01-31 |
+----+---------------------+----------+------------+
5 rows in set (0.06 sec)

Now When I run following script, I get proper results ..

<?php
$mysqli=new mysqli('localhost','root','MyPassWord','test');
if (mysqli_connect_errno()){
printf("Connection Failed: %s \n ",mysqli_connect_error());
exit();
}

$SqlStr="select * from stock where stockqty<=300 order by name";
$result=$mysqli -> query($SqlStr);
if ($result){
print("Meidicines having stock <=300 are : \n");
while($row=$result->fetch_assoc()){
echo "Product Desc : " . $row['name'] . " Stock in Hand : " . $row['stockqty'] . " \n ";
}
$result->close();
}
?>

But When I am using following script, system is getting hanged and mysqld-nt.exe is taking 99% of CPU process. What could be the problem?

<?php
$mysqli=new mysqli('localhost','root','mypassword','test');

if (mysqli_connect_errno()){
printf("Connection Failed: %s \n ",mysqli_connect_error());
exit();
}
if ($stmt=$mysqli -> prepare("insert into stock values ( ?, ?, ?)")){

$stmt->bind_param('sis',$p_name, $p_qty, $p_edate);

$p_name='Valcox 20 Mg Tab';
$p_qty=350;
$p_edate='2007/11/30';

$stmt->execute();

echo "Rows affected : " . $stmt -> affected_rows . "\n ";
$stmt->close();
}
$mysqli -> close();
?>

Please Help !!!!!!!!

tsinka

Hi,

does it work if you use the following prepare statement ?

...
if ($stmt=$mysqli -> prepare("insert into stock (name,stockqty,expirydate) values (?, ?, ?)")){ 
...

(the table has four fields ... so specify the three fields)

Thomas

pradeepmamgain

Hi Thomus,

I have created a new table sample under test, it has only one field itemid varchar. Now if I run the following script, problem remain same. The output I get is "This server is currrently overloaded, please try later" and CPU process goes to 99%, msqld-nt taking all the processor power. I am using following versions.

OS: Win 2000 SP 4
PHP: 5.0.2
MySQL:5.0.0 Alpha

<?php
//Connect to MySQL Server
$mysqli=new mysqli('localhost','root','mypassword','test');
//check connection
if (mysqli_connect_errno()){
printf("Connection Failed: %s \n ",mysqli_connect_error());
exit();
}
//Query
//Caution : Do not append ; charcter at the end of the query string.
//Prepare Template
if ($stmt=$mysqli -> prepare("insert into sample values (?)")){
//Now Bind Parameters
$stmt->bind_param('s',$i_itemid);

$i_itemid='80';

//Execute Prepared Statement
$stmt->execute();

//Print the affected row count using effected_rows property.

echo "Rows affected : " . $stmt -> affected_rows . "\n ";

$stmt->close();
}
$mysqli -> close();
?>

Please help.

pradeepmamgain

Guys,

Problem in now has been solved, version 5.0.1-alpha has no such problems.

Cheers