PHP RSS PHP RSS

generating random id and save it into db

Reply

•
•
Join Date: Dec 2008
Posts: 6
Reputation: mm2409 is an unknown quantity at this point 
Solved Threads: 0
mm2409 mm2409 is offline Offline
Newbie Poster

generating random id and save it into db

 
0
  #1
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:

php Syntax (Toggle Plain Text) 
  1. $que_id = uniqid(que);
  2. echo $que_id;
  3. echo "<br>";
  4.  
  5. $db->query("INSERT INTO tbl_CT_Responses (Response_ID,Questionnaire_ID,Response_Date) 
  6. VALUES (".GetSQLValueString("",`int`).","
  7. .GetSQLValueString($que_id,`int`).","
  8. .GetSQLValueString(date('Y-m-d'),`date`)
  9. .")");
  10.  
  11. echo "The questionnaire ID is inserted successfully";
  12. ?>
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.
Reply With Quote Quick reply to this message  
•
•
Join Date: Jul 2005
Posts: 78
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

 
0
  #2
Dec 3rd, 2008
Why don't you generate some MD5 hash for random numbers yourself ?
Chris, Director, Chrisranjana.com
Web developers and software programmers.
Reply With Quote Quick reply to this message  
•
•
Join Date: Dec 2008
Posts: 6
Reputation: mm2409 is an unknown quantity at this point 
Solved Threads: 0
mm2409 mm2409 is offline Offline
Newbie Poster

Re: generating random id and save it into db

 
0
  #3
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 View Post
Why don't you generate some MD5 hash for random numbers yourself ?
Reply With Quote Quick reply to this message  
•
•
Join Date: Nov 2008
Posts: 24
Reputation: xarz is an unknown quantity at this point 
Solved Threads: 1
xarz's Avatar
xarz xarz is offline Offline
Newbie Poster

Re: generating random id and save it into db

 
0
  #4
Dec 3rd, 2008
you should try echoing the query first just to check that it really works out

php Syntax (Toggle Plain Text) 
  1. echo "INSERT INTO tbl_CT_Responses (Response_ID,Questionnaire_ID,Response_Date)
  2. VALUES (".GetSQLValueString("",`int`).","
  3. .GetSQLValueString($que_id,`int`).","
  4. .GetSQLValueString(date('Y-m-d'),`date`)
  5. .")"
:: xarz ::
Reply With Quote Quick reply to this message  
•
•
Join Date: Dec 2008
Posts: 6
Reputation: mm2409 is an unknown quantity at this point 
Solved Threads: 0
mm2409 mm2409 is offline Offline
Newbie Poster

Re: generating random id and save it into db

 
0
  #5
Dec 4th, 2008
i did ..it gives result object id #2
Reply With Quote Quick reply to this message  
•
•
Join Date: Nov 2008
Posts: 24
Reputation: xarz is an unknown quantity at this point 
Solved Threads: 1
xarz's Avatar
xarz xarz is offline Offline
Newbie Poster

Re: generating random id and save it into db

 
0
  #6
Dec 4th, 2008
have you to tried to check the mysql errors?

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

or an alternative to the insert statement

php Syntax (Toggle Plain Text) 
  1. $db->query("INSERT INTO tbl_CT_Responses 
  2. SET 
  3. Response_ID=".GetSQLValueString("",`int`).",
  4. Questionnaire_ID=".GetSQLValueString($que_id,`int`).",
  5. Response_Date=".GetSQLValueString(date('Y-m-d'),`date`)."
  6. ");

hope it will work out for you.
:: xarz ::
Reply With Quote Quick reply to this message  
•
•
Join Date: Nov 2008
Posts: 24
Reputation: xarz is an unknown quantity at this point 
Solved Threads: 1
xarz's Avatar
xarz xarz is offline Offline
Newbie Poster

Re: generating random id and save it into db

 
0
  #7
Dec 4th, 2008
i spotted something also which perhaps can solve your problem
php Syntax (Toggle Plain Text) 
  1. $que_id = uniqid(que);

should be

php Syntax (Toggle Plain Text) 
  1. $que_id = uniqid($que);
:: xarz ::
Reply With Quote Quick reply to this message  
Reply

Quick Reply to Thread
This thread is more than three months old.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Similar Threads
Other Threads in the PHP Forum
Thread Tools Search this Thread



301 access apache api array autocomplete beginner binary broken button cakephp checkbox class cms code compression cron curl data database dataentry date display dropdown dropdownlist duplicates dynamic echo email error execution file files firstoptioninphpdroplist folder form forms function functions google href htaccess html htmlspecialchars httppost image include insert integration ip javascript joomla jquery limit link links login mail md5 menu methods mlm multiple mysql oop paypal pdf pdfdownload php phpvotingscript query radio random remote script search secure server session sessions source space sql subscription syntax system table tutorial tutorials update upload url validator variable video virus volume votedown web youtube
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC