php help prepared statement

[boyindie86]

Hi

I have been fighting with this bit of code for two days I just can't get it to work properly, i am reading a set of words that hav been taking from a web page and stored in an array, I am now trying to do an analysis on the words from a database. So i want to incrementally read in each word from the array into a select query

Which i can do easily enough using this piece of code


[PHP]public function checkwords()
{
$db = new dbWork();

$array = split(';',file_get_contents("text.txt"));
foreach($array as $word)
{
$db->dbRead($word);

}
unset($word);


}
[/PHP]

but i don't think the php is getting the result from mysql properly as it never seems to find any matches in the database, which for testing purposes does exist. The faulty code is below


[PHP]//Calls database manager class and will pass values to database
public function dbRead($word)
{ $dbm = new dbm();
$dbm->openConn();



$stmt = $dbm->prep("SELECT count(*) FROM test tab where tab.words=?");
$stmt->bind_param('s',$word);
$stmt->execute();
$stmt->bind_result($bool);
$stmt->fetch();
$stmt->close();
$dbm->closeConn();

if($bool !=0)
{

//Reject Word
echo $solWord= 0;
}
else
{

//Accept word
echo $solWord=1;
}
} [/PHP]

[dlite922]

Hi

I have been fighting with this bit of code for two days I just can't get it to work properly, i am reading a set of words that hav been taking from a web page and stored in an array, I am now trying to do an analysis on the words from a database. So i want to incrementally read in each word from the array into a select query

Which i can do easily enough using this piece of code


[PHP]public function checkwords()
{
$db = new dbWork();

$array = split(';',file_get_contents("text.txt"));
foreach($array as $word)
{
$db->dbRead($word);

}
unset($word);


}
[/PHP]

but i don't think the php is getting the result from mysql properly as it never seems to find any matches in the database, which for testing purposes does exist. The faulty code is below


[PHP]//Calls database manager class and will pass values to database
public function dbRead($word)
{ $dbm = new dbm();
$dbm->openConn();



$stmt = $dbm->prep("SELECT count(*) FROM test tab where tab.words=?");
$stmt->bind_param('s',$word);
$stmt->execute();
$stmt->bind_result($bool);
$stmt->fetch();
$stmt->close();
$dbm->closeConn();

if($bool !=0)
{

//Reject Word
echo $solWord= 0;
}
else
{

//Accept word
echo $solWord=1;
}
} [/PHP]

you may have a SQL error:

print your SQL statement to the screen with die($sql_statement); and pasted into the database terminal/command line to see if its successful.

shouldn't the table name have a comma between them like this:

/*    
      INSERT COMMA HERE \|/                 /*
SELECT count(*) FROM test, tab WHERE...