Consider the following script:
<?php
try {
$dbh = new PDO("sqlite::memory:");
} catch(PDOException $e) {
print $e->getMessage();
}
$dbh->query("CREATE TABLE foo(id INT)");
$stmt = $dbh->prepare("INSERT INTO foo VALUES(:value)");
$value = null;
$data = array(1,2,3,4,5);
$stmt->bindParam(":value", $value);
/* ?????? */
try {
foreach($data as $value) {
/* ????? */
}
} catch(PDOException $e) {
/* ??????? */
}
/* ?????? */
?>
What lines of code need to go into the missing places above in order for this script to function properly and insert the data into the database safely?
Please answer through the comments I will make it publish on blog..............
[Thursday, February 21, 2008
|
0
comments
]
Popular Posts
- Mysql query for searching a value, add weightage on the number of occurances and sort based on the weight-age
- How to add or remove WWW on URLs using htaccess.
- php questions
- Pattern Matching in mysql
- Running a perl script from PHP
- How to create a plugin in elgg.
- function to check whether the year given is a leap year or not
- question regarding socket
- How to find out the Mysql storage engine type of a table.
- php Questions
0 comments
Post a Comment
Please put your comments here. your questions, your suggestions, also what went wrong with me.