mysql to PDO conversion

Asked May 15 '15 at 06:56

Active Dec 29 '16 at 15:06

Viewed 59 times

I am converting old mysql to PDO.

Old working code:

$sql='INSERT INTO `plat_wiadomosci`( `wiad_oddzial`, `temat`, `tresc`,`id_user`,`ip`,`data_wiadomosci`,`wiad_telefon`,`wiad_zrobiony`) VALUES ("'.$_POST['tt'].'","'.$tytul.'","'.$_POST['wiadomosc'].'","'.$_POST['did'].'","'.$_SERVER['REMOTE_ADDR'].'","'.time().'","'.$_POST['telefon'].'","0")';
mysql_query($sql);

New code in PDO:

$stmt=$db->prepare('INSERT INTO `plat_wiadomosci`( `wiad_oddzial`, `temat`, `tresc`,`id_user`,`ip`,`data_wiadomosci`,`wiad_telefon`,`wiad_zrobiony`) VALUES (?,?,?,?,?,"'.time().'",?,"0")');
$stmt->execute(array($_POST['tt'],$tytul,$_POST['wiadomosc'],$_POST['did'],$_SERVER['REMOTE_ADDR'],$_POST['telefon']));

First code is writing into database the other won't, any suggestion ?

Connection:

$db = new PDO('mysql:host=localhost;dbname='.$dbname12.';charset=utf8', $dbuser23, $dbpsw34);
$db->exec("set names utf8");

After error info: i pasted after exec, print_r($db->errorInfo()); i get

Array ( [0] => 00000 )

edited May 15 '15 at 07:59

asked May 15 '15 at 06:56

Paweł Suchodolski

In prepare statement in your values put all ? and in your array pass all the value that you want. – Alive to die - Anant May 15 '15 at 06:59
tested won't change anything – Paweł Suchodolski May 15 '15 at 07:02
2

Just curious - why use php's time() insted of MySQL's NOW()? – Strawberry May 15 '15 at 07:06
Look carefully at the `prepare` method signature... – PeeHaa May 15 '15 at 07:07
Can we see the connection? – Mihai May 15 '15 at 07:15
At first you need to get error message. – degr May 15 '15 at 07:23

mysql to PDO conversion

0 Answers0