|
(X)HTML, JavaScript, DHTML, XML, CSS Client scripting tehnologije, Dynamic HTML, Cascading Stylesheets, XML i standardi |
|
Alati teme | Način prikaza |
|
08. 02. 2014. | #1 | |
profesionalac
Professional
Datum učlanjenja: 25.10.2012
Poruke: 278
Hvala: 16
32 "Hvala" u 9 poruka
|
Evo, uradio sam "rewrite" koda sa MYSQL_* funcijama u PDO medjutim neznam sta je sada problem:
KOD: Kôd:
<?php /* Your Database Name */ $dbname = 'nesto'; // change this /* Your Database User Name and Passowrd */ $username = 'nesto'; // change this $password = 'pass'; // change this $pdo = new PDO("mysql:host=localhost;dbname=$dbname", $username, $password); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $sql = "INSERT INTO stat (Name, Gender, Age, Donuts_eaten ) VALUES ( :Name, :Gender, :Age, :Donuts_eaten)"; $stmt = $pdo->prepare($sql); $stmt->bindParam(':Name', $_POST['name'], PDO::PARAM_STR); $stmt->bindParam(':Gender', $_POST['gender'], PDO::PARAM_STR); $stmt->bindParam(':Age', $_POST['age'], PDO::PARAM_INT); // use PARAM_STR although a number $stmt->bindParam(':Donuts_eaten', $_POST['Donuts_eaten'], PDO::PARAM_INT); // old execute // $stmt->execute(); $stmt->execute(array(':Name' => $_POST['name'],':Gender' => $_POST['gender'],':Age' => $_POST['age'],':Donuts_eaten' => $_POST['Donuts_eaten'])); if($stmt != false) { echo "success!"; } else { echo "an error occured saving your data!"; } ?> Citat:
HTML je dobar sa svim ID poljima kao sto treba, kao i kolone u tabeli baze ... s tim da su polja age i donus eaten INTEGER, mozda mi problem pravi ID polje koje je autoincrement |
|
|
|