DaniWeb Home > Forums > Web Development > PHP

RSS

generating random id and save it into db

Please support our PHP advertiser: Free Online Load Test - How many visitors can your web site handle?

•

Posts: 6

Reputation: mm2409 is an unknown quantity at this point

Solved Threads: 0

mm2409

Offline

Newbie Poster

generating random id and save it into db

Dec 3rd, 2008

dear frnds,

i hace wrote this code to generate unique id for questionnaire and a query to save it into database with two more value (response id and date)

individually i have checked and unique id function is working.
even insert query is also executing correctly.

but when i put it whole into my php file it doesnt save values into DB.

please help to sort it out. i m in hurry.

code is here:

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
$que_id = uniqid(que);
echo $que_id;
echo "<br>";
 
$db->query("INSERT INTO tbl_CT_Responses (Response_ID,Questionnaire_ID,Response_Date) 
VALUES (".GetSQLValueString("",`int`).","
.GetSQLValueString($que_id,`int`).","
.GetSQLValueString(date('Y-m-d'),`date`)
.")");
 
echo "The questionnaire ID is inserted successfully";
?>
$que_id = uniqid(que);
echo $que_id;
echo "<br>";

$db->query("INSERT INTO tbl_CT_Responses (Response_ID,Questionnaire_ID,Response_Date) 
VALUES (".GetSQLValueString("",`int`).","
.GetSQLValueString($que_id,`int`).","
.GetSQLValueString(date('Y-m-d'),`date`)
.")");

echo "The questionnaire ID is inserted successfully";
?>

Last edited by peter_budo : Dec 3rd, 2008 at 5:53 pm. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

•

Posts: 72

Reputation: chrisranjana is an unknown quantity at this point

Solved Threads: 3

chrisranjana chrisranjana is offline

Offline

Junior Poster in Training

Re: generating random id and save it into db

Dec 3rd, 2008

Why don't you generate some MD5 hash for random numbers yourself ?

Chris, Director, Chrisranjana.com
Web developers and software programmers.

•

Posts: 6

Reputation: mm2409 is an unknown quantity at this point

Solved Threads: 0

mm2409

Offline

Newbie Poster

Re: generating random id and save it into db

Dec 3rd, 2008

i can use MD5 hash for random numbers (even i m using it ) but the problem is data is not inserting into db.also not showing any error.

till now cudnt find the reason.

•

Originally Posted by chrisranjana

Why don't you generate some MD5 hash for random numbers yourself ?

•

Posts: 24

Reputation: xarz is an unknown quantity at this point

Solved Threads: 1

xarz

Offline

Newbie Poster

Re: generating random id and save it into db

Dec 3rd, 2008

you should try echoing the query first just to check that it really works out

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
echo "INSERT INTO tbl_CT_Responses (Response_ID,Questionnaire_ID,Response_Date)
VALUES (".GetSQLValueString("",`int`).","
.GetSQLValueString($que_id,`int`).","
.GetSQLValueString(date('Y-m-d'),`date`)
.")"
echo "INSERT INTO tbl_CT_Responses (Response_ID,Questionnaire_ID,Response_Date)
VALUES (".GetSQLValueString("",`int`).","
.GetSQLValueString($que_id,`int`).","
.GetSQLValueString(date('Y-m-d'),`date`)
.")"

:: xarz ::

•

Posts: 6

Reputation: mm2409 is an unknown quantity at this point

Solved Threads: 0

mm2409

Offline

Newbie Poster

Re: generating random id and save it into db

Dec 4th, 2008

i did ..it gives result object id #2

•

Posts: 24

Reputation: xarz is an unknown quantity at this point

Solved Threads: 1

xarz

Offline

Newbie Poster

Re: generating random id and save it into db

Dec 4th, 2008

have you to tried to check the mysql errors?

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
echo mysql_error();
echo mysql_error();

or an alternative to the insert statement

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
$db->query("INSERT INTO tbl_CT_Responses 
SET 
Response_ID=".GetSQLValueString("",`int`).",
Questionnaire_ID=".GetSQLValueString($que_id,`int`).",
Response_Date=".GetSQLValueString(date('Y-m-d'),`date`)."
");
$db->query("INSERT INTO tbl_CT_Responses 
SET 
Response_ID=".GetSQLValueString("",`int`).",
Questionnaire_ID=".GetSQLValueString($que_id,`int`).",
Response_Date=".GetSQLValueString(date('Y-m-d'),`date`)."
");

hope it will work out for you.

:: xarz ::

•

Posts: 24

Reputation: xarz is an unknown quantity at this point

Solved Threads: 1

xarz

Offline

Newbie Poster

Re: generating random id and save it into db

Dec 4th, 2008

i spotted something also which perhaps can solve your problem

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
$que_id = uniqid(que);
$que_id = uniqid(que);

should be

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
$que_id = uniqid($que);
$que_id = uniqid($que);

:: xarz ::

Thread Tools Display Modes

Quick Reply to Thread

•

Only community members can participate in forum threads. You must register or log in to contribute.

Similar Threads

how to open a file after running the program (C++)
Generate User ID (PHP)
Create double blind system in php (PHP)
CPU Scheduling Algorithm (Java)
Sorting in Python (Python)
problem in generating non repeated random numbers (C)

Other Threads in the PHP Forum

Previous Thread: PHP Gaming basics
Next Thread: Dynamic Title Generation using PHP and MySql

•

Views: 499 | Replies: 6 | Currently Viewing: 1 (0 members and 1 guests)

•

Thread Tools	Display Modes
Show Printable Version Email this Page	Linear Mode Switch to Hybrid Mode Switch to Threaded Mode