<div dir="ltr" style="text-align: left;" trbidi="on">
<b>FIRST</b>
<body>
<form action="chk123.php" method="post">
Flights on: <br />
<input name="Days" type="checkbox" value="Daily" />Daily<br />
<input name="Days" type="checkbox" value="Sunday" />Sunday<br />
<input name="Days" type="checkbox" value="Monday" />Monday<br />
<input name="Days" type="checkbox" value="Tuesday" />Tuesday <br />
<input name="Days" type="checkbox" value="Wednesday" />Wednesday<br />
<input name="Days" type="checkbox" value="Thursday" />Thursday <br />
<input name="Days" type="checkbox" value="Friday" />Friday<br />
<input name="Days" type="checkbox" value="Saturday" />Saturday <br />
<input name="submit" type="submit" value="submit" />
</form>
</body>
My php file to read and insert the values into a table:
<?php
// Make a MySQL Connection
mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("test") or die(mysql_error());
$checkBox = $_POST['Days'];
if(isset($_POST['submit']))
{
for ($i=0; $i<sizeof($checkBox); $i++)
{
$query="INSERT INTO example (orange) VALUES ('" . $checkBox[$i] . "')";
mysql_query($query) or die (mysql_error() );
}
echo "Complete";
}
?>
You should specify
<input type="checkbox" name="Days[]" value="Daily">Daily<br>
Didn't tested it, but you can try like this. Don't forget to replace mysql with mysqli.
<html>
<body>
<form method="post" action="chk123.php">
Flights on: <br/>
<input type="checkbox" name="Days[]" value="Daily">Daily<br>
<input type="checkbox" name="Days[]" value="Sunday">Sunday<br>
<input type="checkbox" name="Days[]" value="Monday">Monday<br>
<input type="checkbox" name="Days[]" value="Tuesday">Tuesday <br>
<input type="checkbox" name="Days[]" value="Wednesday">Wednesday<br>
<input type="checkbox" name="Days[]" value="Thursday">Thursday <br>
<input type="checkbox" name="Days[]" value="Friday">Friday<br>
<input type="checkbox" name="Days[]" value="Saturday">Saturday <br>
<input type="submit" name="submit" value="submit">
</form>
</body>
</html>
<?php
// Make a MySQL Connection
mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("test") or die(mysql_error());
$checkBox = implode(',', $_POST['Days']);
if(isset($_POST['submit']))
{
$query="INSERT INTO example (orange) VALUES ('" . $checkBox . "')";
mysql_query($query) or die (mysql_error() );
echo "Complete";
}
?>
</div>
<b>FIRST</b>
<body>
<form action="chk123.php" method="post">
Flights on: <br />
<input name="Days" type="checkbox" value="Daily" />Daily<br />
<input name="Days" type="checkbox" value="Sunday" />Sunday<br />
<input name="Days" type="checkbox" value="Monday" />Monday<br />
<input name="Days" type="checkbox" value="Tuesday" />Tuesday <br />
<input name="Days" type="checkbox" value="Wednesday" />Wednesday<br />
<input name="Days" type="checkbox" value="Thursday" />Thursday <br />
<input name="Days" type="checkbox" value="Friday" />Friday<br />
<input name="Days" type="checkbox" value="Saturday" />Saturday <br />
<input name="submit" type="submit" value="submit" />
</form>
</body>
My php file to read and insert the values into a table:
<?php
// Make a MySQL Connection
mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("test") or die(mysql_error());
$checkBox = $_POST['Days'];
if(isset($_POST['submit']))
{
for ($i=0; $i<sizeof($checkBox); $i++)
{
$query="INSERT INTO example (orange) VALUES ('" . $checkBox[$i] . "')";
mysql_query($query) or die (mysql_error() );
}
echo "Complete";
}
?>
You should specify
<input type="checkbox" name="Days[]" value="Daily">Daily<br>
Didn't tested it, but you can try like this. Don't forget to replace mysql with mysqli.
<html>
<body>
<form method="post" action="chk123.php">
Flights on: <br/>
<input type="checkbox" name="Days[]" value="Daily">Daily<br>
<input type="checkbox" name="Days[]" value="Sunday">Sunday<br>
<input type="checkbox" name="Days[]" value="Monday">Monday<br>
<input type="checkbox" name="Days[]" value="Tuesday">Tuesday <br>
<input type="checkbox" name="Days[]" value="Wednesday">Wednesday<br>
<input type="checkbox" name="Days[]" value="Thursday">Thursday <br>
<input type="checkbox" name="Days[]" value="Friday">Friday<br>
<input type="checkbox" name="Days[]" value="Saturday">Saturday <br>
<input type="submit" name="submit" value="submit">
</form>
</body>
</html>
<?php
// Make a MySQL Connection
mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("test") or die(mysql_error());
$checkBox = implode(',', $_POST['Days']);
if(isset($_POST['submit']))
{
$query="INSERT INTO example (orange) VALUES ('" . $checkBox . "')";
mysql_query($query) or die (mysql_error() );
echo "Complete";
}
?>
</div>
No comments:
Post a Comment