question from a newbie

locky

Hello
I have a form including some fields, one of which (the field rol) data needs to be fetched from the db. These roles have all different id's an names. I have an issue finding out how to write this in php? Although I have everything in html. Please advice. This is my html code.

<html>
<head>
	<title>Een mental coach toevoegen aan de database</title>
</head>

<body>
<h2 align="center">Een mental coach toevoegen</h2>
<table align="center">
<form method="post" action="coacher_toevoegen_sql.php">
<tr> <td align="right"> rol :</td> <td> <select name="role">
<option value="superuser">superuser</option>
<option selected="user">user</option>
<option value="Administrator">administrator
</option></select> </td></tr>
<tr> <td align="right">voornaam :</td> <td> <input type="Text" name="voornaam" size="30"></td></tr>
<tr> <td align="right">familienaam : </td> <td><input type="Text" name="fam_naam" size="50"></td></tr>
<tr><td align="right">vaste telefoon : </td> <td> <input type="Text" name="vst_tel" size="12"></td></tr>
<tr> <td align="right">gsm :</td> <td> <input type="Text" name="gsm" size="12"></td></tr>
<tr> <td align="right">email : </td> <td><input type="Text" name="mail" size="50"></td></tr>
<tr><td colspan="2"><hr></td></tr>
<tr> <td colspan="2"><input type="submit" value="Invoegen"><input type="Reset" value="Leegmaken"></td></tr>
<br>
</form>
</table>
</body>
</html>

Wales

Are you trying to just insert the form fields into the database?
If that is the case...

You need to do an INSERT INTO table name (field name1, field name2) VALUES ('{$POST['form name']}', '{$POST['form name 2']}')

Make sure the table name you are inserting into matches how the values.. the above will insert post form name into field name1 and post form name 2 into field name 2.

To fetch something you can do a while()

locky

Hello Wales. thx for your quick reply
Indeed I am trying to insert the form fields in to the data base. But I am afraid you are going a bit to fast for me. Sorry... I am newbie but ancious to learn...

OK, let cut this into two pieces. First the role field. how to fetch this from the db. this is what a started to right but got stuck ...

here's what I came up with:

<?php
// verbinding met database invoegen
include("inc_connect_mysql.php");
$sql="select * from roles
order by role_id asc";
$result = mysql_query($sql,$db);
?>
<html>
<head>
<title>Een mental coach toevoegen aan de database</title>
</head>

<body>
<h2 align="center">Een mental coach toevoegen</h2>
<table align="center">
<form method="post" action="coacher_toevoegen_sql.php">
<tr><td align="right">rol :</td>

<?php while ($rij = mysql_fetch_array($result)){

Wales

locky wrote:
Hello Wales. thx for your quick reply
Indeed I am trying to insert the form fields in to the data base. But I am afraid you are going a bit to fast for me. Sorry... I am newbie but ancious to learn...

OK, let cut this into two pieces. First the role field. how to fetch this from the db. this is what a started to right but got stuck ...

here's what I came up with:

<?php
// verbinding met database invoegen
include("inc_connect_mysql.php");
$sql="select * from roles
order by role_id asc";
$result = mysql_query($sql,$db);
?>
<html>
<head>
<title>Een mental coach toevoegen aan de database</title>
</head>

<body>
<h2 align="center">Een mental coach toevoegen</h2>
<table align="center">
<form method="post" action="coacher_toevoegen_sql.php">
<tr><td align="right">rol :</td>

<?php while ($rij = mysql_fetch_array($result)){

Here is an example form..just change the name and fields.
Remember ..this isn't secure, but just an example. Haven't test it, but it looks like it should work.

<?php
//Assuming that connection to database is already made...

if (isset ($_POST['submit'])) { //Checks to see if form is submit
//Very important that the table name () matches the value (). Whatever you are putting in tablename fields should match the same spot
//in the values (). So...id starts with 0, testinput gets information from the post testinput, etc..
$insertquery = "INSERT INTO tablename (id, testinput, testtextarea) VALUES (0, '$_POST['testinput']', '$_POST['testtextarea']')";

if (mysql_query ($insertquery)) { //Runs the insertquery
	echo 'If the data was inserted in the database this will show.';
}
else {
	echo 'If the data could not be inserted, this will show.';
}

}//Ends if isset $_post submit

//Start the query for retrieving
$query = "SELECT * FROM tablename ORDER BY id ASC"; //Query selects everything from tablename ordered by id ascending
if ($result = mysql_query($query)) { //Runs the query
	//Retrieves and print record
	while ($row = mysql_fetch_array ($result)) {
	$testinput = $row['testinput']; //Variable for testom[it in the tablename
	$testtextarea = $row['testtextarea']; //Variable for testtextarea in the tablename...I just set the rows to variables..same steps for other rows
	echo "$testinput"."$testtextarea";//Combined testinput and testtextarea and prints it
	}

}//Ends query retrieve if


?>

<form action="test.php" method="post">
Test input
<br />
<input type="text" name="testinput" size="40" maxlength="20" />
<br />
<br />
Test Textarea
<br />
<textarea name="testtextarea" cols="35" rows="7"></textarea>
<br />
<input type="submit" name="submit" value="submit" />
</form>