Tell me more ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite

Ok I have a dropdown list, and I'd like to store the chosen option to the database through a variable defined on the beginning of the code:

$campus_name = isset($_POST['campus']) ? asi($_POST['campus']) :"";

The code for the dropdown list is as follows:

<select name="campus" id="campus">
      <option>Choose</option>
      <option value="1">Belaruz</option>
      <option value="2">Normdale</option>

So how do I store that to the table campus using the variable $campus_name to store it?

share|improve this question
We don't know how the table campus is made, and however this question can be easily answered by reading one of the 100,000 tutorials around to do PHP & MySQL altogether. The first three or four results on Google will give you an answer. – gd1 May 3 '11 at 17:37
@Giacomo: RTFM or "Google it" is not a proper Stack Overflow answer. The question is well-formed and pertinent. It should be answered. – David Titarenco May 3 '11 at 17:40
@David - I wouldn't call it a well formed question. Where's he having trouble? Does the OP know how to connect to the DB? Is the DB created? Does the table exist? Is he having a problem writing SQL? This is very vague and bordering on unanswerable without churning out a chapter's worth of text. – Erik May 3 '11 at 17:42
@David: you may be right but I think one doesn't help Sinner writing the 4-5 lines of code he's looking for, that are widely available from thousands of sources. Copy&paste != learn. You have to learn things and then ask if something is not clear, not pray for and then paste code given by people around trying to carry on with it. More, what happens if Sinner modifies the code w/o understanding it causing SQL injection? This is the RTFM case, really – gd1 May 3 '11 at 17:42
1  
Thanks for the opinions. Answering some things: the table exists, database is created. I have a php website with a MySQL DB. "campus" is a varchar(255) table. I tried to Google, with no success. I'm on my way of learning PHP but for now I'd be satisfied to complete this task. I really am new to PHP and MySQL but not to programming so I can instinctively understand some things and will eventually understand the code. This website is an inherited project so I must make any changes myself, or hire a programmer (for witch I don't have the means right now). Thank you all for the patience and help. – Sinner シンネル May 3 '11 at 22:53
show 2 more comments
up vote -1 down vote accepted

So if I had a table called campus and it only had one column. I would use the mysql_query command. I used arbitrary names in my example but I hope you get the picture.

$campus_name = isset($_POST['campus']) ? asi($_POST['campus']) :""; 
$link=mysql_connect('localhost','ID','Password');
mysql_select_db('College', $link);
mysql_query("insert into campus(campusID)values('$campus_name')");
share|improve this answer
1  
-1 DANGER: SQL injection prone, unless asi() sanities $_POST["campus"] which is not granted. That's why RTFM is sometimes a good answer. – gd1 May 3 '11 at 17:52
He didnt ask for security – xkonnectDeveloper May 3 '11 at 17:53
1  
He doesn't know about security, because he didn't RTFM. He asked for ready-to-paste code, which means that he will take bad habits (like the one of not sanitizing strings), so you're not doing good for him. He'll paste your code and get its flawed script broken by some lamer. – gd1 May 3 '11 at 17:54

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.