prepare("insert into contacts (fullname) values ('$fullname')");
$sql->execute();
}
//now for the read
$sql = $dbh->prepare("select fullname from contacts");
$sql->execute();
//this is how we display!!!!
while ($row = $sql->fetch()){
echo $row['fullname'].'
';
}
//this is update
$sql = $dbh->prepare("update contacts set fullname = 'Kristian Secor' where fullname = 'Kris Secor' ");
$sql->execute();
//print_r($sql->errorInfo());
//this is the delete
$sql = $dbh->prepare("delete from contacts where fullname = 'Kristian Secor' ");
//$sql->execute();
?>