Ad:

PHP Discussion Thread
Unsolved
Views: 814

Dec 3rd, 2008

generating random id and save it into db

Expand Post »

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:

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 6:53 pm. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

Similar Threads

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

mm2409

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

6 posts
since Dec 2008

Permalink

Dec 3rd, 2008

Re: generating random id and save it into db

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

chrisranjana

Reputation Points: 11

Solved Threads: 3

Junior Poster in Training

Offline

82 posts
since Jul 2005

Permalink

Dec 3rd, 2008

Re: generating random id and save it into db

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.

Click to Expand / Collapse Quote originally posted by chrisranjana ...

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

mm2409

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

6 posts
since Dec 2008

Permalink

Dec 3rd, 2008

Re: generating random id and save it into db

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

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

Reputation Points: 10

Solved Threads: 1

Newbie Poster

Offline

24 posts
since Nov 2008

Permalink

Dec 4th, 2008

Re: generating random id and save it into db

i did ..it gives result object id #2

mm2409

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

6 posts
since Dec 2008

Permalink

Dec 4th, 2008

Re: generating random id and save it into db

have you to tried to check the mysql errors?

php Syntax (Toggle Plain Text)
echo mysql_error();
echo mysql_error();

or an alternative to the insert statement

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

Reputation Points: 10

Solved Threads: 1

Newbie Poster

Offline

24 posts
since Nov 2008

Permalink

Dec 4th, 2008

Re: generating random id and save it into db

i spotted something also which perhaps can solve your problem

php Syntax (Toggle Plain Text)
$que_id = uniqid(que);
$que_id = uniqid(que);

should be

php Syntax (Toggle Plain Text)
$que_id = uniqid($que);
$que_id = uniqid($que);

xarz

Reputation Points: 10

Solved Threads: 1

Newbie Poster

Offline

24 posts
since Nov 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: PHP Gaming basics

Next Thread in PHP Forum Timeline: Dynamic Title Generation using PHP and MySql

DaniWeb Message

Cancel Changes

User Name
Password