[Resolved] Incrementing ID in Db

tazdog

Hello,
I'm trying to have an ID field in my Db that has like xyz0123.

I try to put in a default value and then have it increment when someone enters something into the database as a new record. But when displaying the Database it only shows 1 then next 2 then next record 3, etc..

What is the best way to do this..
Do I have to implement some code into the form processor for this to happen..?

thanks for your help
Scott

PHPMagician

I can't think of a database that will actually do that type of auto-increment. Though, it shouldn't be very hard to write one up yourself.

Edit: Write up a function to increment the id, not to write a DBMS that will support this type of auto increment. 😛

tazdog

any idea where I can read about doing something like this online..?

I'm really new to php, etc. so I have no idea where to start on this

thanks
Scott

kender

do you always want the letters to be XYZ? or at least the same?

tazdog

the letters will always be the same and will not change.

Like record #1
xyz1000
next record
xyz1001
..
etc

kender

so then why not hard code it, ie: select id from database

$id = selected id

echo 'xyz'.$id.' ?

tazdog

So I can add that into my existing form.

I dont want the user to see it (from the form) but when It sends an email to them it will include it..? Is that possible..?

I know a site that can do this in asp. But converting it to php and trying to learn at the same time.

Could you use like a hidden form field to process the ID..? So the user would not see it but the email would grab it from the DB or something like that..?

thanks
Scott

kender

so in the mail and db entry function, when your user submits their information, you want it to return an id (unique) that is a letter then number string, with the letters always being the same, the number auto incrementing based off of last user?

tazdog

yep thats it..
if it can be done in php..

just for another example.

say im xyz1001
you sign up and you will not see this info on the form but when you submit the form to the db, you will be assigned xyz1002 and then in the email that goes out will have this ID on the email..!

Hope that makes sense and can be done.

thanks
Scott

kender

in your database, add a field to the very first position (before all entries)

have it called, ID or id or somehting you will know what it is..
have it auto increment

move the database insert between

function sendmail(){

MOVE DB INSERT HERE

$priority = 0; // Should the email be sent with priority? (0 = No, 1 = Yes)

directly after the insert, find the id that it just inserted, call it $ID or some such

then between here

Here are the contents of the form:<br><br>";

echo ' Your ID# is XYZ'.$ID.''; // ADD THIS LINE

foreach ($_POST as $key => $value){

tazdog

Since its almost quiting time, I will try this later tonight when I get home.. Again thanks for your help.

Scott

kender

just leave me hanging and not knowing if it worked out for you

tazdog

This is confusing..

Ok I'm going to attach the code so you can see if I put the things in the right order...

thanks
Scott

kender

ok, in your database, did you add an auto_incerement field for pilot id ? and what is the actual 'name' for that field? case sensitive

tazdog

Yeah I had it set up from the start..

PilotID
with Auto increment..

Scott

kender

try this
remember to change connect info

tazdog

When I try it now I get a parse error on line 120

    $mail .= "<b>$key</b>: ".nl2br($value)." <br>";

kender

on the end of line 118

change the " to '' (double quote to 2 single quotes)

tazdog

here is what I have:

echo 'Your Pilot ID# is XYZ'.$PilotID.";
foreach ($_POST as $key => $value){
    $mail .= "<b>$key</b>: ".nl2br($value)." <br>";
}
$mail .= "

I didnt know if that was for the <br> or for a different line

kender

echo 'Your Pilot ID# is XYZ'.$PilotID.''; //CHANGE 
foreach ($_POST as $key => $value){ 
    $mail .= "<b>$key</b>: ".nl2br($value)." <br>"; 
} 
$mail .= "

only change was making the double quote after $PilotID." into two single quotes $PilotID.''