note 90952 deleted from function.mysql-insert-id by cmb
| From: | cmb@php.net | Date: | Sun, 16 Feb 2020 13:31:58 +0000 |
| Subject: | note 90952 deleted from function.mysql-insert-id by cmb | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-214119@lists.php.net to get a copy of this message | ||
Note Submitter: Ultimater at gmail dot com
----
Here's an elegant way to INSERT using UPDATE syntax.
<?php
function insert_update($table,$fields,$id=NULL)
{
if($id===NULL)
{
$sql="INSERT INTO $table (id) VALUES(NULL);UPDATE $table SET $fields WHERE id =
LAST_INSERT_ID()";
}else{
$sql="UPDATE $table SET $fields WHERE id = $id";
}
return $sql;
}
?>
Usage:
<?php
$table="
members";
$fields="username = 'Ultimater',userlevel =
'member'";
if(!$profile_exists)
{
//insert a record
$sql=insert_update($table,$fields);
mysql_query($sql);
}else{
//update a record
$sql=insert_update($table,$fields,5);
mysql_query($sql);
}
?>