 |  |  |  |  |  |  |  |
use listbox to insert data?
Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
i have a Listbox available in my page and that Listbox have these items.
and i have trip named table which have these fields.
id which will autocrement
from
to
coach_type
fare
journey_date
seat
now i want this to be happen if a user come and take any item from Listbox it will inserts that that info to these fields not in the seats cuz seat is on the other page.
for example
if a user selects 1st item which is Sukkur-Karachi-(NonAC) then it will insert this data in the field.
in from it insert sukkur
in to it insers karachi
in couchtype it insert nonac
in fare it insert 550
also for the second it insert according to the item in the list box.
after that i have a field which is journey date that is timestamp now i want a calender to be attach to this if user selects date that insers in the journey_date field. please help me out on this.
i have these fields in the listbox.
http://i41.tinypic.com/epf0ug.jpg
In default situation
http://i39.tinypic.com/2hn6x42.jpg
and i have trip named table which have these fields.
id which will autocrement
from
to
coach_type
fare
journey_date
seat
now i want this to be happen if a user come and take any item from Listbox it will inserts that that info to these fields not in the seats cuz seat is on the other page.
for example
if a user selects 1st item which is Sukkur-Karachi-(NonAC) then it will insert this data in the field.
in from it insert sukkur
in to it insers karachi
in couchtype it insert nonac
in fare it insert 550
also for the second it insert according to the item in the list box.
after that i have a field which is journey date that is timestamp now i want a calender to be attach to this if user selects date that insers in the journey_date field. please help me out on this.
i have these fields in the listbox.
http://i41.tinypic.com/epf0ug.jpg
In default situation
http://i39.tinypic.com/2hn6x42.jpg
PHP Syntax (Toggle Plain Text)
cmon guys i need help????
see line 147 to 148
and the upper php code every thing is ok just tell me how can i put the values for every selection in data base.
see line 147 to 148
and the upper php code every thing is ok just tell me how can i put the values for every selection in data base.
A couple of questions..
1. Where are you getting those GET names from? Can't see any reference to them in your code..
2. Why are you putting GET data directly into the database.. That's just asking for trouble. Any and all input from a user should be seen cleaned before database entry.
3. What is so important about line 147/148, I see no problems there.
1. Where are you getting those GET names from? Can't see any reference to them in your code..
2. Why are you putting GET data directly into the database.. That's just asking for trouble. Any and all input from a user should be seen cleaned before database entry.
3. What is so important about line 147/148, I see no problems there.
AJAX is not a programming language, scripting language or any other sort of language.
It is acheived by using JavaScript http functions.
So, AJAX = JavaScript.
It is acheived by using JavaScript http functions.
So, AJAX = JavaScript.
•
•
Join Date: Apr 2009
Posts: 257
Reputation: 
Solved Threads: 37
Posting Whiz in Training
see this line
You are using four fields but five parameters and some commas are missing.
You are using four fields but five parameters and some commas are missing.
$query="INSERT INTO trip (from,to,coach_type,fare) values ('".$a."','".$b."','".$c."'".$d."'".$e."')"; try this now it should be either c or d (AC or non AC. not both) $query="INSERT INTO trip (from,to,coach_type,fare) values ('$a','$b','$c','$e')";
Last edited by BzzBee; May 4th, 2009 at 1:16 am.
•
•
•
•
Originally Posted by BzzBee 
see this line
You are using four fields but five parameters and some commas are missing.
$query="INSERT INTO trip (from,to,coach_type,fare) values ('".$a."','".$b."','".$c."'".$d."'".$e."')"; try this now it should be either c or d (AC or non AC. not both) $query="INSERT INTO trip (from,to,coach_type,fare) values ('$a','$b','$c','$e')";
i have a text box and i want a calender to be attach to that i have found a calender dont know how to attach where to put that code can u plz help me out on that two
here is the page which have a calender coding + i want only attach to one text box:-
http://blog.davglass.com/files/yui/cal2/
•
•
•
•
Originally Posted by xan
A couple of questions..
1. Where are you getting those GET names from? Can't see any reference to them in your code..
2. Why are you putting GET data directly into the database.. That's just asking for trouble. Any and all input from a user should be seen cleaned before database entry.
3. What is so important about line 147/148, I see no problems there.
i have made 3 combobox one is from other is to and the 3rd is Couch now tell me how can i insert the 3 values of 3 comboboxes to database
my database name is online_bus_project
table name is trip
here is the code i have made some changes check it
PHP CODE
php Syntax (Toggle Plain Text)
HTML CODE:
html Syntax (Toggle Plain Text)
Last edited by Ezzaral; May 4th, 2009 at 3:41 pm. Reason: Added [code] [/code] tags. Please use them to format any code that you post.
Apart from the fact that your HTML is appalling.. as I said earlier, where are you getting the (in this case) POST from?
You appear to be using the values that the fields have, this is incorrect.
You should be using:
This is not recommended though, the user can modify the data sent to the server through a form, you should look into SQL injection and how to prevent it.
You appear to be using the values that the fields have, this is incorrect.
You should be using:
php Syntax (Toggle Plain Text)
AJAX is not a programming language, scripting language or any other sort of language.
It is acheived by using JavaScript http functions.
So, AJAX = JavaScript.
It is acheived by using JavaScript http functions.
So, AJAX = JavaScript.
still the same error which is from the navigation bar swf file
which is on the line 70 of HTML code
HTML CODE:
PHP CODE
which is on the line 70 of HTML code
HTML CODE:
PHP Syntax (Toggle Plain Text)
PHP CODE
PHP Syntax (Toggle Plain Text)
|
Similar Threads
- Saving and displaying data on datagrid! (VB.NET)
- how can i get the value of listbox?to store data in database? (PHP)
- Tkinter scoll text area with listbox (Python)
- fill listbox with data from another table (Visual Basic 4 / 5 / 6)
- how to validate text file, loading into listbox (Visual Basic 4 / 5 / 6)
- Saving information from .NET Listbox into SQL Server 2000 (ASP.NET)
Other Threads in the PHP Forum
- Previous Thread: .htacess file dosent work on main server
- Next Thread: convert .doc to html or txt on fly (during upload) with PHP
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Latest PHP Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
ajax apache api array beginner beneath binary broadband broken button cakephp checkbox class cms code countingeverycharactersfromastring crack cron curl database date decode display dynamic echo email error file files folder form forms function functions google href htaccess html image include insert integration ip java javascript joomla limit link links login mail match md5 menu mlm multiple mysql mysql_real_escape_string oop paypal pdf php problem protocol query radio random recursion regex remote script search server session sessions sms smtp soap source space sql strip_tags survey syntax system table tutorial undefined update upload url validator variable video virus votedown web window.onbeforeunload=closeme; xml youtube
