autogenerated number

Anon

hi everyone,

 i m trying 2 write this function for autogeneration of the code for the member as its membercode for eg. m000000001. the field is of char type in the table. this code includes first character as character n rest of the characters as number.

 for doing this, i have came till here :

(the code i wrote till now)

<?php
include ( "include/conectdb.inc" );

$sql = "SELECT max(substring(memberid,2,9)) FROM member";

$result = mysql_query($sql,$db);

echo $result;

$nxtnum = $result + 1;	

echo $nxtnum;

include ( "include/closedb.inc" );
?>

the result is it generates the next number as integer from the last record of the table.

now, the problem:

firstly how do i convert this integer type into string.
secondly how do i addup this strings to get single string ie 'm0000000012' or 'm000123456'.

please help urgently

piyush

Anon

My reply is in the code delimited by ">>"

piyush wrote:

hi everyone,

 i m trying 2 write this function for autogeneration of the code for the member as its membercode for eg. m000000001. the field is of char type in the table. this code includes first character as character n rest of the characters as number.

 for doing this, i have came till here :

(the code i wrote till now)

<?php
include ( "include/conectdb.inc" );

$sql = "SELECT max(substring(memberid,2,9)) FROM member";

$result = mysql_query($sql,$db);

echo $result;

$nxtnum = $result + 1;

If you are looking at generating a random lowercase character then you can do the following
// $nxtnum = chr(rand(97,122)).$nxtnum;
you will have "XYYYYYYYYY", X-lowercase character, Y - numbers

echo $nxtnum;

when storing back try and store it as below
/*
$StoreQuery = "INSERT INTO member(memberid) VALUES('".$nxtnum."')";
mysql_query($StoreQuery);

include ( "include/closedb.inc" );
?>

the result is it generates the next number as integer from the last record of the table.

now, the problem:

firstly how do i convert this integer type into string.
secondly how do i addup this strings to get single string ie 'm0000000012' or 'm000123456'.

please help urgently

piyush

Anon

hi kaushik,

 thnx for your suggestion, but i am not trying to generate any random lower case character or number. what i am looking for is simple to autogenerate sequential code for my members. the code contains first alphabate as a character and rest will be number.

for eg.
m0000000001
m0000000002
m0000000003

so my problem was how do addup or concat this 2 different datatypes n character and interger into one string, to make it a complete code.

did u get my problem.

please reply fast

thnx
piyush

Anon

Hi
I understood your problem, but I just wasnt sure if you were trying to generate a character. Now your problem is even more simple. You are just adding a 'm' to all the id's generated.
Let me assume that var $nxtnum has the next id in the sequence, then

$nxtnum = "m".$nxtnum; // this concatenates both m & id generated.

This will result in a data like m0000000003.

While saving this back to the database,

$Query = "INSERT INTO members(memberid) VALUES('$nxtnum')";
mysql_query($Query);

However i'm assuming that your memberid is a primary key, this technique of having varchar primary keys is bad to maintain and performance tune the database.

Anon

hi Kaushik,

 thanx, for your help, it really worked that way, thanx again.

 but now the porblem is the value is not getting updated. below given is the code which i have wrote, have look at it and tell me wats wrong with it :

<?php
//### Connecting to database ###
include ( "include/conectdb.inc" );

// ## Check for uniqueness of Username(USER) ##
$sql = "SELECT username FROM user WHERE username = '$uname'";
$sql_result = mysql_query($sql,$db);

print mysql_error();
$numrows = mysql_num_rows($sql_result);

if ($numrows==0)
{
// ## Process IP, Date, ID ##
$ipadd = getenv("REMOTE_ADDR");

timestamp function :-

$dtstamp = time();
$date_array = getdate($dtstamp);
$mnth = $date_array["mon"];
$day = $date_array["mday"];
$yr = $date__array["year"];

$dor = "$day/$mnth/$yr";
$visits = 1;

// # Get ID #
$sql1 = "SELECT max(substring(userid,2,9)) FROM user";
$result1 = mysql_query($sql1,$db);
print mysql_error();
$nxtnum = $result1;
echo $nxtnum;
if($nxtnum==0)
$id="u000000001";
$nxtnum = $nxtnum+1;
echo $nxtnum;
if(($nxtnum>=1) AND ($nxtnum<10))
$id="u00000000".$nxtnum;
else
if(($nxtnum>=10) AND ($nxtnum<100))
$id="u0000000".$nxtnum;
else
if(($nxtnum>=100) AND ($nxtnum<1000))
$id="u000000".$nxtnum;
else
if(($nxtnum>=1000) AND ($nxtnum<10000))
$id="u00000".$nxtnum;
else
if(($nxtnum>=10000) AND ($nxtnum<100000))
$id="u0000".$nxtnum;
else
if(($nxtnum>=100000) AND ($nxtnum<100000))
$id="u000".$nxtnum;
else
if(($nxtnum>=1000000) AND ($nxtnum<1000000))
$id="u00".$nxtnum;
else
if(($nxtnum>=10000000) AND ($nxtnum<10000000))
$id="u0".$nxtnum;
else
if(($nxtnum>=100000000) AND ($nxtnum<100000000))
$id="u".$nxtnum;

// ## Insert Data into Database(USER) ##
$sql = "INSERT INTO user(userid, username, password, income, dob, visits) VALUES ('$id', '$uname', '$pw1', '$income', '$dd/$mm/$yy', '$visits')";
$sql_result = mysql_query($sql, $db);// or die("Error executing Query");
print mysql_error();

// ## Insert Data into Database(ADDRESS) ##
$sql = "INSERT INTO address (adid, name, address, city, state, pin, phone1, phone2, country, email, dor, ipadd) VALUE('$id', '$name', '$address', '$city', '$state', '$pin', '$phone1', '$phone2', '$country', '$email', '$dor', '$ipadd')";

$sql_result = mysql_query($sql, $db);
print mysql_error();

// ### Close Connection ###
include ( "include/closedb.inc" );

Anon

From your code I understand that you are trying to generate an user id for an unregistered account name or user name. Your code should work, if the only problem seems not getting into the "IF" loop "if ($numrows==0) ", then try to change your query to

$sql = "SELECT count(*) FROM user WHERE username = '$uname'";

if(mysql_fetch_row(mysql_query($sql))) {
// do your job.
}

Is this the problem you are facing, if not let me know what exactly is the error message.

Anon

hi kaushik

 thnx for your help, till now !!

 but my problem does not exist with checking for the existing user. but problem exists with this part of the code

$sql1 = "SELECT max(substring(userid,2,9)) FROM user";
$result1 = mysql_query($sql1,$db);

 the problem is when once the above statement is executed the varibles dont get refreshed.

for ex. :
when i execute this statement for the first time it will hold the value properly.
but next time when i execute this part of the code again it still holds the same old value, it dont get refreshed.

so tell me what could be the problem.

thnx again
piyush