note 89171 modified in mysqli-stmt.bind-param by thiago
| From: | thiago@php.net | Date: | Wed, 25 Feb 2009 13:58:04 +0000 |
| Subject: | note 89171 modified in mysqli-stmt.bind-param by thiago | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-151106@lists.php.net to get a copy of this message | ||
<?php
/* just explaining how to call mysqli_stmt_bind_param with a parameter array */
$sql_link = mysqli_connect('localhost', 'my_user', 'my_password',
'world');
$type = "isssi";
$param = array("5", "File Description", "File Title", "Original
Name", time());
$sql = "INSERT INTO file_detail (file_id, file_description, file_title, file_original_name,
file_upload_date) VALUES (?, ?, ?, ?, ?)";
$sql_stmt = mysqli_prepare ($sql_link, $sql);
call_user_func_array('mysqli_stmt_bind_param', array_merge (array($sql_stmt, $type),
$param);
mysqli_stmt_execute($sql_stmt);
?>
--was--
/* just explaining how to call mysqli_stmt_bind_param with a parameter array */
$sql_link = mysqli_connect('localhost', 'my_user', 'my_password',
'world');
$type = "isssi";
$param = array("5", "File Description", "File Title", "Original
Name", time());
$sql = "INSERT INTO file_detail (file_id, file_description, file_title, file_original_name,
file_upload_date) VALUES (?, ?, ?, ?, ?)";
$sql_stmt = mysqli_prepare ($sql_link, $sql);
call_user_func_array('mysqli_stmt_bind_param', array_merge (array($sql_stmt, $type),
$param);
mysqli_stmt_execute($sql_stmt);
http://php.net/manual/en/mysqli-stmt.bind-param.php