I have used combo boxes for years in Access and the 'select' element on an html form is similar. All of the tutorials on w3 show how to fill the 'options' with literal values, but I would like to have the options be filled from a table in a database so the user can select one. I know this is probably a cross-topic item and I have an idea of how to go about it using javascript, php and sql, but I thought I'd ask if anyone knew of a procedure which is already created for this. In Access you just enter the row source for the combo box and the options are there - is there any kind of construct to do that for a 'select' element in html? Thanks

Hello. Is this the right place to Discuss W3CSS ? Or is that a separate forum ?
I am not sure if this is a question, or suggestion - or both.
https://www.w3schools.com/w3css/w3css_input.asp
I have reviewed the INPUT and the TABLE information in the W3CSS pages, and can not locate the information I am after.
I am wondering about the correct technique of using tables and forms in ONE.
Ive two scenarios in mind.
ONE: You display a table and EACH row contains its own FORM.
it contains, text, an input field, and in the 3rd column, its own submit button. each form sends minimal data to get processed.
TWO: you have an HTML form, and a table.
There is ONE Form, with ONE submit button, but it has multiple table rows, containing text, input fields etc..
Is there an existing tutorial on this ? If not, can one be added to the W3CSS website (and a hyper link to/from the INPUT and TABLE pages).

BACKGROUND: Good ideas are sometimes like luck, they come in streaks. Thanks to the experiential wisdom of this forum and those around me in the Galvanize collective workspace, I have decided to tarry a little longer with the reconstruction of my data base. Indeed, I have learned a new term -- normalization. What before I intended to achieve with row duplication I hope now to achieve with simple updates. In order to achieve this important structural change and still retain the benefits of the old structure, I must disengage one of my form's <fieldset>s and create from it a new form that is submitted manually and only occasionally. It would appear that the small changes to the separate table that this fieldset previously replenished with each new form submission can now be achieved with MySQL TRIGGER and UPDATE statements. This strategy has led to the following two questions:
QUESTION ONE: Under the assumption that one can have only one $_POST variable per page how does one typically go about using the same $_POST variable for multiple forms on the same page? If I were to implement this task on my own, without the advice of others, I would create a bivariate if-. else if-, else- statement that tests for the present of one of two variables and then handles only that data associated with the form submitted. Is there another, perhaps more thorough, separation that does not include the creation of a separate form page?
QUESTION TWO: When executing a MySQL TRIGGER that updates a single row value of a single column of a table different from the one that executes the trigger, will the DEFAULT setting for the UPDATE statement trigger a timestamp with the ON UPDATE CURRENT_TIMESTAMP?
As always your wisdom would be well-appreciated.
Roddy

We're a small manufacturer. We need to create a form that allows a visitor to pick a few machine options and the form would generate the specs based on those choices. The customer wouldn't be ordering online -- it's just for reference purposes. I know it's embarrassingly simple but I've spent two hours digging around and I don't even know what you would call that type of form let alone find any examples. We, of course, need it to look good on a mobile device.
Does anyone know of a site that I might find an example or what you would call a form like that so I can find one myself?
Any help would be greatly appreciated.
For example:
1. Choose series: Medium Duty
Heavy Duty
2. Choose Equipment: Modular Complete
T-14 R-10
T-24 R-15
T-34 R-25
Output based on the above choices:
Capacity =
Stroke =
Thrust=

I need two submit buttons in my form, first is going to show result in the same tab and another one is in another one.
<submit target="_blank">
is not correct. <target="_blank"> is for <form> tag, right?

QUESTION ONE: Please suggest what might be entered where the three ? marks appear in order to achieve the following goal.
THE GOAL: See appear the value of mil in the input control text field and have this value become the value of $_POST['item_encllength'] when the form is submitted.
var min = $('#min').val();
var sec = $('#sec').val();
var mil = function(min, sec) {
var millisec = ((min * 60) + sec) * 1000;
return millisec;
}
$('#item_encllength').mousedown(mil, function() {
$(this).???;
});
<input id='min' type='number' value='Minutes'>
<input id='sec' type='number' value='Seconds'>
<input id='item_encllength' form='rss2_feed' type='text' name='item_encllength'>
I have experimented in a variety of ways, but have not been able to find the code necessary to achieve my goal. Perhaps my approach to the problem is inappropriate.
Roddy

Hi W3S
I am trying to make a login PHP code with MySQLI and it won't work for some reason, not sure what i have done wrong, can someone see what i did wrong?
This is the code:
////////////////////////////////////////////////////////////////////////////////////////////////////////
// Login
////////////////////////////////////////////////////////////////////////////////////////////////////////
$SUBMIT_FORM_ACTION___TakeLoginForm = (isset($_GET["SUBMIT_FORM_ACTION"]) ? $_GET["SUBMIT_FORM_ACTION"] : "");
if( $SUBMIT_FORM_ACTION___TakeLoginForm == "TakeLogin" ) {
$query_1 = "SELECT u_id, u_username, u_password, u_email FROM users WHERE u_email=? AND u_password=?";
if ( $stmt = $mysqli->prepare($query_1) ) {
$FORM_email = $_POST['email'];
$FORM_password = $_POST['password'];
$stmt->bind_param('ss', $FORM_email, $FORM_password);
$stmt->execute();
$stmt->bind_result($id, $username, $password, $email);
$stmt->fetch();
// SECURITY! CHECK & COMPARE!
if($FORM_password !== $password) {
die("
<center><b>(Form) Login ErrMSG #1</b></center>
<br />
<center>Password incorrect/wrong! Try again!</center>
");
}
// Make Sessions Needed!
$_SESSION['user'] = array();
$_SESSION['user']['id'] = $id;
$_SESSION['user']['username'] = $username;
$_SESSION['user']['password'] = $password;
$_SESSION['user']['email'] = $email;
$stmt->close();
//header("location: index.php");
}
}
okay so lets see if i get this straight. In the bind_result part, this does not matter what kind of variable it is right? In the naming part... or does the names actual HAS to be like the ones in the Database Columns? I somehow think its the part there but correct me if i am wrong...
Hoping someone can help me a little bit.
Thanks in advance

I followed the lessons about php and php forms. Everything is clear and very useful, but I would like to ask how could I send eg this form if valid with SMTP? So, I would like to first validate the form and then send it with SMTP.
Thank you!

Hello everyone! This is my very first PHP document, and i must admit, i have no experience or knowledge about PHP, i looked at an example and tryd to connect the dots to create this one. It works better than expected, but I do encounter a few issues, where I would very much like to have some advise with. Problem 1: The data from the form gets mailed to me, but even though everything in the form is filled in, I would only receive the "E-mail: INPUT@HOTMAIL.COM" The rest of the data like: "Meetnaam: " Were blank, as if the data did not exist. The form did check correctly wether this information was provided, but seems not to provide so in the e-mail send to me. Problem 2: $meetnaam should be the subject of the e-mail. Problem 3: $email should also be the e-mail adress asigned to the sender, as such, I can easily reply.
Problem 4: The checkbox, $akkoord, should be checked, if not, an error should be displayed, I do not know how to do this.
Your help with this problem is very much apreciated! Once again: I am new to this, so try to be very specific (if you would even be so kind, type it out and put the update in bold text) =D
This is the PHP and HTML code I used respectively: PHP
HTML

How i submit form to other website and Get Result on my website
Here Is An example site I want Make like this website http://singhfm.com/psebresult/
and here tagret website where i want pick data
http://results2.indiaresults.com/pb/pseb/result-of-12-class-march-2016/query.htm
How I Done Any one can help about this

I am making a contact form in a new template liquid for a shopify website. Everything works and looks great in desktop mode but I've noticed as you drag the screen to a skinnier size some inline-block elements jump down perfectly as they are supposed to, the problem is other smaller text boxes are jumping up over other text fields to try and fill that gap. Also I've had issues with the legend and labels abandoning the text box they belong to jump up the form and fill space. Obviously I do not want this, how can I fix it?

Let's pretend, there's a <div> on a page. There's a usual HTML form inside it that sends information to another php-file. By default, the visibility of the div is hidden, and the click on the button makes it visible. The question is how to close the form (i.e. hide the div) using a button or <a> element on the div, WITHOUT the sending data to php-file. In other words, how to close this <div> as if it is usual popup-window, without changes?

I am attempting to create a drop down menu and I liked the style of the top home menu seen here
http://www.lego.com/en-us/products (right near the lego symbol) but I am not sure how to create a similar one would some one gI've me guidance on how I can do this I just started html coding so I am a noon with little knowledge of html right now.