Page 1 of 1
Getting Values From MySQL to display them on PHP
Posted: Sun May 23, 2010 1:22 am
by PascalNouma
Hello everyone,
I've 2 tables in mysql file and 2 php files. The first php page will display checkboxes and once I choose checkboxes and then press submit button, it will produce 2nd php page that displays the values of checkboxes.
Let's say i've a table called CAKE that has attributes called CAKETYPE & CAKEVALUE. I'll have a php page that shows checkboxes for caketypes and once I choose CAKETYPE(s) on this PHP pages, 2nd php page should display the value of the CAKETYPE(s) (CAKEVALUE) that I chose.
Hope you understood what I meant. If you can give me a weblink that explains similar case, it will be great.
Thanks a lot from now on
Re: Getting Values From MySQL to display them on PHP
Posted: Sun May 23, 2010 5:41 am
by social_experiment
Have you created any code that you can paste?
PascalNouma wrote:Let's say i've a table called CAKE that has attributes called CAKETYPE & CAKEVALUE. I'll have a php page that shows checkboxes for caketypes and once I choose CAKETYPE(s) on this PHP pages, 2nd php page should display the value of the CAKETYPE(s) (CAKEVALUE) that I chose.
The first script that displays the checkboxes for the caketypes might look something like this
Code: Select all
<?php //connect to your database server \ select the database
//see if there are any rows in the table
//'id' should preferably be a primary key (PK) or something unique to each record
$count = "SELECT COUNT(id) FROM table";
$count_sql = mysql_query($count);
$rows = mysql_fetch_array($count_sql);
$records = $rows[0];
//start populating the page
if ($records != 0) {
$query = "SELECT caketype FROM cake";
$sql = mysql_query($query);
//start creating the form
echo '<form method="post" action="page_to_process" >';
while ($caketype_array = mysql_fetch_array($sql)) {
echo "".$caketype_array['caketype']." <input type=\"checkbox\" value=\"".$caketype_array['caketype']."\" name=\"cake_type\" />";
echo '<br />';
}
echo '<input type="submit" name="submit" value="Get cake value" />';
echo '</form>';
} ?>
The process page
Code: Select all
<?php if (isset($_POST['submit'])) {
$cake_type = $_POST['cake_type'];
$count = "SELECT COUNT(id) FROM cake WHERE caketype = '".mysql_real_escape_string($cake_type)."'";
$count_sql = mysql_query($count);
$rows = mysql_fetch_array($count_sql);
$records = $rows[0];
// start populating the page
if ($records != 0) {
$query = "SELECT cakevalue FROM cake WHERE caketype = '".mysql_real_escape_string($cake_type)."'";
$sql = mysql_query($query);
//echo results
while ($cakevalue_array = mysql_fetch_array($sql)) {
echo 'Cake value is : '.$cakevalue_array['cakevalue'];
echo '<br />';
}
}
} ?>
Im assuming you will have only one entry for each 'caketype' and 'cakevalue' i.e
cake
----------
caketype | cakevalue
-------------------------
choc_cake | unique_value0
white_cake | unique_value1
------------------------------------