php - Learning SELECT FROM WHERE prepared statements -

can re-write below code prepared statement?

result = mysqli_query($con,"select * note_system note = '$cnote'")  or die("error: ".mysqli_error($con));  while($row = mysqli_fetch_array($result)) { $nid = $row['id'];   } 

i trying learn prepared statements , having trouble understanding how works many examples have found while searching. hoping if see code familiar re-written prepared statement might click me. please no pdo, confusing me @ current level of knowledge. thanks.

hello butterdog let me walk through pdo step step.

step 1)

create file called connect.php (or ever want). file required in each php file requires database interactions.

lets start please note comments :

?php  //we set our database configuration $username="xxxxx"; // mysql username $password="xxxxx"; // mysql password   // connect server via php data object $dbh = new pdo("mysql:host=xxxxx;dbname=xxxxx", $username, $password); // construct pdo variable using $dbh $dbh->setattribute(pdo::attr_errmode, pdo::errmode_exception); // set attributes error reporting important! $dbh->setattribute(pdo::attr_emulate_prepares, false); // set false can allow actual pdo driver work, further adding abstraction data interactions. ?> 

step 2) require connect.php please take :

require ('....../........./...../connect.php'); // require connect script made pdo variable $dbh 

step 3)

to start database interactions following please read code comments. moment not worry arrays! full gyst of pdo worry making easier work with! repetition "long way" comes more understanding of code. not cut corners begin with, cut them once understand doing!

$query = $dbh->prepare("select * note_system note = :cnote"); // call variable $dbh in required file setting database connection , preparing query!  $query->bindparam(':cnote', $cnote); // bread , butter of pdo named binding, 1 of biggest selling points of pdo! please remember step take ever variable ($cnote) , relate (:cnote)  $query->execute(); // take ever $query execute aka run query against database  $row = $query->fetch(pdo::fetch_assoc); // use simple fetch , store variables in array  echo $row['yourvalue']; // take variable above (which array) , call on 'yourvalue' , echo it. 

thats there pdo. hope helped!

also take @ this. helped me so much!

i use this reference (sometimes) - web site looks crap there quality information on pdo on there. use this , swear last link! after questions ask, can turn little reference guide on pdo. (hopefully lol)