Page 1 of 1

Insert into id field question

Posted: Mon Apr 25, 2011 5:50 pm
by cjkeane
hi everyone

i'm wondering if there is a technique i could use to insert data into a table if data is entered in a field, otherwise insert the regular variable.

Code: Select all

<?php

$FirstName = $_POST['FirstName'];
$LastName = $_POST['LastName'];
$DateOfBirth = $_POST['DateOfBirth'];
$OverrideIDNumber = $_POST['OverrideIDNumber'];

// find max of non standard id number
$ID = mysql_query(SELECT MAX(IDNumber) as MaxNumber from records;
$MaxRecordNumberResult = mysql_fetch_array($ID);
$NextID = $MaxRecordNumberResult +1;

$query = "INSERT INTO records (IDNumber, FirstName, LastName, DateOfBirth) 
   		VALUES ('$NextID', '$FirstName', '$LastName', '$DateOfBirth')";
		 mysql_query($query) or die('Error, insert query failed');
?>
i need a way to insert $OverrideIDNumber in replace of $NextID, if data exists in the form in that field, if not, then insert $NextID.

any ideas on how to accomplish this? thanks.

Re: Insert into id field question

Posted: Mon Apr 25, 2011 5:59 pm
by superdezign
Just set the value of the ID you want based on whether or not $_POST['OverrideIDNumber'] is empty.

Code: Select all

$id = empty($OverrideIDNumber) ? $NextID : $OverrideIDNumber;
$query = "INSERT INTO records (IDNumber, FirstName, LastName, DateOfBirth) VALUES ('$id', '$FirstName', '$LastName', '$DateOfBirth')";
Also, I highly recommend checking that POST data exists before attempting to use it and cleaning POST data before using it in a MySQL query.

Re: Insert into id field question

Posted: Mon Apr 25, 2011 6:14 pm
by cjkeane
thanks. i'll give it a try.
Yes i do check if post exists prior to inserting data. i just posted partial data to keep things simple.