Menu
Community /Pin to ProfileBookmark
@NogDogDec 28.2007 — #I don't know enough about your code to tell you for sure what is needed, but there is some obvious confusion here. In the second-to-last line you assign a SQL string to the variable [b]$query[/b]. But in the next line you reference [b]$query[/b] as though it is an object, call its member method [b]execute()[/b] (the "->" operator means that [b]execute()[/b] is a member of object [b]$query[/b].)
Presumably, [b]$query[/b] would have been defined earlier as an instance of some class via the [b]new[/b] keyword. If so, then you need to use a different variable name for the query string. What I suspect you want is:
But [i]caveat emptor[/i], as this is just a best guess based on incomplete data.@NogDogDec 28.2007 — #I am assuming that [b]$db[/b] is a mysqli object, either the result of a [b]mysqli_connect()[/b] or a [b]new mysqli()[/b] call. If so, see the following manual pages for explanations and examples of using this interface to the database:
http://www.php.net/mysqli_prepare
http://www.php.net/mysqli_bind_param
http://www.php.net/mysqli_execute
execute() function
Please, someone explain what this function is!
I can’t figure out [U][B]the lines of code
[code=php]
$fields = array(‘first_name1′,’last_name1′,’tel_number1’);
$placeholders = array();
$values = array();
foreach($fields as $field) {
$placeholders[] = ‘?’; // One placeholder per field;
$values[] = $_POST[$field]; // Assume the data is coming from a form;
}
$query = “INSERT INTO table ( ‘implode(‘,’, $fields) ‘)
VALUES (‘ implode (‘,’, $placeholders) ‘ )”;
$query ->execute($values);
Thank you.
Sign in
to post a comment6 Comments(s) ↴
0
@NogDogDec 28.2007 — #I don't know enough about your code to tell you for sure what is needed, but there is some obvious confusion here. In the second-to-last line you assign a SQL string to the variable [b]$query[/b]. But in the next line you reference [b]$query[/b] as though it is an object, call its member method [b]execute()[/b] (the "->" operator means that [b]execute()[/b] is a member of object [b]$query[/b].)Presumably, [b]$query[/b] would have been defined earlier as an instance of some class via the [b]new[/b] keyword. If so, then you need to use a different variable name for the query string. What I suspect you want is:
[code=php]
$sql = "INSERT INTO table ( 'implode(',', $fields) ')
VALUES (' implode (',', $placeholders) ' )";
$query->execute($sql);
[/code]But [i]caveat emptor[/i], as this is just a best guess based on incomplete data.
0
@NogDogDec 28.2007 — #I am assuming that [b]$db[/b] is a mysqli object, either the result of a [b]mysqli_connect()[/b] or a [b]new mysqli()[/b] call. If so, see the following manual pages for explanations and examples of using this interface to the database: