Hi all,
I am a bit new to PHP and SQL so this may seem like a dumb question.
I have already created a drop down list as part of a form which is
automatically populated with values taken from a separate database. When a
user goes onto this page and either leaves the default value or selects a
value from the drop down list and presses the submit button, I would like
that selected value to be stored into a database which I have already
created in SQL.
Just to let you know that I can do the above using a text field but just
don't know how to do it with drop down list.
If your going to explain any coding then it may help if I give you the names
of certain items that are involved.
Database is called "Company"
Field within database is called "Name"
Drop down list is called "company"
Thanks
Ren 2 4560
Ren wrote: Hi all,
I am a bit new to PHP and SQL so this may seem like a dumb question.
I have already created a drop down list as part of a form which is automatically populated with values taken from a separate database. When a user goes onto this page and either leaves the default value or selects a value from the drop down list and presses the submit button, I would like that selected value to be stored into a database which I have already created in SQL.
Just to let you know that I can do the above using a text field but just don't know how to do it with drop down list.
If your going to explain any coding then it may help if I give you the names of certain items that are involved.
Database is called "Company" Field within database is called "Name"
Drop down list is called "company"
Thanks Ren
Ren,
Submit your form to a simple testpage which contains the following:
print_r($_POST) ;
or - depending on your php version -
print_r($HTTP_P OST_VARS);
You should now see exactly what is being submitted by your form (and
how) which should tell you how you can reference the value you want to
put into your database.
Grz,
Juliette
Thanks Juliette for the reply.
Just to let you know that I made a stupid typing error in the php code that
is why it was not working.
Sorry about that!
Ren
"Juliette" <jr*********@jo keaday.net> wrote in message
news:43******** *************** @news.wanadoo.n l... Ren wrote: Hi all,
I am a bit new to PHP and SQL so this may seem like a dumb question.
I have already created a drop down list as part of a form which is automatically populated with values taken from a separate database. When a user goes onto this page and either leaves the default value or selects a value from the drop down list and presses the submit button, I would like that selected value to be stored into a database which I have already created in SQL.
Just to let you know that I can do the above using a text field but just don't know how to do it with drop down list.
If your going to explain any coding then it may help if I give you the names of certain items that are involved.
Database is called "Company" Field within database is called "Name"
Drop down list is called "company"
Thanks Ren
Ren,
Submit your form to a simple testpage which contains the following:
print_r($_POST) ;
or - depending on your php version -
print_r($HTTP_P OST_VARS);
You should now see exactly what is being submitted by your form (and how) which should tell you how you can reference the value you want to put into your database.
Grz, Juliette This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: John Marble |
last post by:
I am quite new with Access, so please be indulgent if my question
sound a little bit newbish.
I have two table in the same database: DOSSIER and MAIN.
MAIN is having already formatted data that I need to import in
DOSSIER, so everything is ready.
I used help to determine the correct synthax to do this with SQL but
it keeps saying that my synthax is wrong, here are my lines:
|
by: Martyn Fewtrell |
last post by:
I want to update a database record with a number of fields - doesn't sound
to difficult at this stage!
I have a system to select the correct record from the database and load the
data into a form across a number of text boxes and a single drop down list
(the idea being that the text boxes can be edited and the drop down listed
altered to reflect a new value if necessary). The drop down list in the form
is loaded from the appropriate...
|
by: Chris Kratz |
last post by:
Hello all,
We have run into what appears to be a problem with rules and subselects in
postgres 7.4.1. We have boiled it down to the following test case. If
anyone has any thoughts as to why this would be happening, we would
appreciate feedback.
We have tested on 7.3.4, 7.3.6 and 7.4.1 and all exhibit the same behavior.
Test case one tries to populate table2 from table1 with records that are not
in table2 already. Table2 gets...
|
by: riteshjain82 |
last post by:
Hi,
I am maintaining a site which is written in ASP. Now i have to create
some new pages.
In one page we have a table with many rows. Now, I want to enable or
disable(showing and hiding also) 2 rows of this table depending upon
the value selected by the user from a drop down list.
Can somebody please help me??? This is really urgent.....
|
by: grummanf6f |
last post by:
Hello Gurus,
this probably is real simple for you but for me it's a bummer.
I have one table in which I have basic data collected of schools. I
have another data that is detailed info on the stuff they teach in the
school. I have two forms for entering the data. The first, basic info
table is already filled in.
I would like my second entry form to show the name of the school as
| |
by: Bob |
last post by:
Hi all,
I'm trying to import data, modify the data then insert it into a new
table. The code below works fine for it but it takes a really long
time for 15,000 odd records. Is there a way I can speed up the
processing substantially? as it currently takes about 10 minutes and
thats just way too long because there is many of these imports that I
need to do.... I currently insert each record one by one and I
imagine
thats where all the...
|
by: TycoonUK |
last post by:
Hi,
As I do not have IE7 on my computer, I was wondering if there is a
fault in my CSS Menu when using IE7.
Please can someone look at my site - http://www.worldofmonopoly.co.uk
and tell me if it works, and if it does not, tell me why it does not
work.
Thanks.
|
by: dongletran06 |
last post by:
Hi,
Please help me find out what wrong with my codes in inputting from my form to mysql database using drop down menu. Below is the codes I used. Only the drop down is not working but the "input text" are successfully adding data to mysql. I just try first using the month as drop down. The month data type I used in mysql database is varchar. Im new in PHP please help me. Thanks
<?php /* Created on: 10/12/2006 */ ?>
<html>
<body>
<?php...
|
by: SunnySnow29 |
last post by:
Hi,
I have a 2 drop down lists in C# populated with data from a SQL 2005 db.
When a new item of data is inserted the second list must update to reflect the change (the first drop down list will always be unchanged by inserts) and the new value must become the selected value in drop down list 2. I use databind() after the form has autoposted back after the insert but the 1st and 2nd drop down lists default back to the first item in the...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |