Can someone help me change to pseudo code?

[Newbie89]

Example such like as shown at the bottom: <?php$dbHandle = new PDO("sqlite:/var/databases/testsite/database.sqlite");$dbHandle->exec("CREATE TABLE mybooks (id INTEGER PRIMARY KEY, author NOT NULL, title NOT NULL)");$mybooks = array( "Mass Effect: Revelation" => "Drew Karpyshyn", "Mass Effect: Ascension" => "Drew Karpyshyn", "Dragon Age: The Stolen Throne" => "David Gaider");while (list($title,$author) = each($mybooks)) { $author = $dbHandle->quote($author); $title = $dbHandle->quote($title); $result = $dbHandle->exec("INSERT INTO mybooks (author,title) VALUES ($author,$title)");}?>

[Newbie89]

and also this: <?php$random = rand(1,3);$dbHandle = new PDO("sqlite:/var/databases/testsite/database.sqlite");$result = $dbHandle->query("SELECT * FROM mybooks WHERE id=$random");$book = $result->fetch(PDO::FETCH_ASSOC);echo "Random peek into my libary:<br><br>$book[title] by $book[author]";?>

[birbal]

and also this: <?php $random = rand(1,3); $dbHandle = new PDO("sqlite:/var/databases/testsite/database.sqlite"); $result = $dbHandle->query("SELECT * FROM mybooks WHERE id=$random"); $book = $result->fetch(PDO::FETCH_ASSOC); echo "Random peek into my libary:<br><br>$book[title] by $book[author]"; ?>

1) Generating a random number between 1 to 32) Initialize Database connection3) Execute query get all fields from mybook where id is the generated random number4) fetch the PDOStatement object as associative array

Example such like as shown at the bottom: <?php $dbHandle = new PDO("sqlite:/var/databases/testsite/database.sqlite"); $dbHandle->exec("CREATE TABLE mybooks (id INTEGER PRIMARY KEY, author NOT NULL, title NOT NULL)"); $mybooks = array( "Mass Effect: Revelation" => "Drew Karpyshyn", "Mass Effect: Ascension" => "Drew Karpyshyn", "Dragon Age: The Stolen Throne" => "David Gaider"); while (list($title,$author) = each($mybooks)) { $author = $dbHandle->quote($author); $title = $dbHandle->quote($title); $result = $dbHandle->exec("INSERT INTO mybooks (author,title) VALUES ($author,$title)");} ?>

Initialize Database connectionexecute the query which creates tablecreate an array of book name and author key value pairloop through and make variable out of the array to store title and author escape the inputs of author and title insert it in DB You could figure it out on your own if you look into the corresponding class and functions. check the php manual for corresponding refference.

[Newbie89]

Thanks for your help^^ birbal