Drop down from database
Moderator: General Moderators
Drop down from database
Hello everyone,
Firstly I would like to say I know I am new to this community and shouldn't be asking help straight away but it is an emergency.
Basically I have a page with a contact form on, simple contact form with name, email, phone, subject, message e.t.c.
What I want to do is add another field which is a drop down menu from a MySQL database.
If you look at: http://www.av8jet.com/charter.php
You can see in the departures box, when you start typing, a list of airports come up, I want to do the same thing from my database but have next to no experience in php and mysql.
I have looked at their code but can't figure it all out.
Anyone who is willing to help we can pay a small fee but this needs to be done urgently,
Thank you for your time,
Flyer101
Firstly I would like to say I know I am new to this community and shouldn't be asking help straight away but it is an emergency.
Basically I have a page with a contact form on, simple contact form with name, email, phone, subject, message e.t.c.
What I want to do is add another field which is a drop down menu from a MySQL database.
If you look at: http://www.av8jet.com/charter.php
You can see in the departures box, when you start typing, a list of airports come up, I want to do the same thing from my database but have next to no experience in php and mysql.
I have looked at their code but can't figure it all out.
Anyone who is willing to help we can pay a small fee but this needs to be done urgently,
Thank you for your time,
Flyer101
Re: Drop down from database
Try to use any jquery autosuggestion plugin.
That will ease your problem
That will ease your problem
Re: Drop down from database
I'm sorry, do you think you could elaborate?
I appreciate the help so much!
Thanks,
Flyer101
I appreciate the help so much!
Thanks,
Flyer101
Re: Drop down from database
do you need google like auto suggestion?
Re: Drop down from database
just google autosuggestion jquery plugin for new ones or just look here
http://www.9lessons.info/2009/06/autosu ... d-php.html
further help assured!
http://www.9lessons.info/2009/06/autosu ... d-php.html
further help assured!
Re: Drop down from database
Thank you, how do I link that to a mySQL database though
Re: Drop down from database
edit the config.php or just connect to your database in search.php using mysql_connect()
Re: Drop down from database
I am completely new to PhP and mySQL so I have no idea what you mean, sorry.
Re: Drop down from database
Pls post your codes so that we can help ....
Also try to learn php basics from w3schools.net or some ebooks
Also try to learn php basics from w3schools.net or some ebooks
Re: Drop down from database
Okay I have done some research and sorted out the auto suggestion thing but the thing i am stuck on is putting my .sql file on to my webserver and creating a table then a search column, how do you create a table in cpanel?
Re: Drop down from database
do you have a php testing environment in your computer?
If not,it would be better if you setup one so that you can play with php.
To setup a php environment ,setup xampp in your computer.
here is the link
www.apachefriends.org/en/xampp.html
If not,it would be better if you setup one so that you can play with php.
To setup a php environment ,setup xampp in your computer.
here is the link
www.apachefriends.org/en/xampp.html
Re: Drop down from database
Virtual Box + LAMP > XAMPP.
That aside, you should have a link to phpMyAdmin available from cPanel. From there, you can copy the contents of your .sql file into the SQL tab, which should create the table for you.
That aside, you should have a link to phpMyAdmin available from cPanel. From there, you can copy the contents of your .sql file into the SQL tab, which should create the table for you.
-
williamsmith518
- Forum Newbie
- Posts: 1
- Joined: Mon Apr 09, 2012 7:18 am
Re: Drop down from database
edit the config.php or just connect to your database in search.php using mysql_connect()
-----------------------------------------------
Patent tescili
-----------------------------------------------
Patent tescili