PHP - Getting Dynamically Created Form Values

hey i am using a MySql database and i need to create a dynamic HTML table with one of its columns as checkboxes.so i have to create multiple checkboxes.but these checkbox values are to be stored in a mysql table and then later retrieved when form reloads.and depending on previous state when form was submitted, the newly created checkboxes have to be checked in the same manner.so how do i store multiple checkbox values in my table and also how do i retrieve them?
please help.

Hi,

I have a very large form that has been created with a select statement.

When i am submitting the form and running the sql insert, i obviously cant list out all of the fields like you would for a small form.

How would one go about submitting a form with a large number of fields.

The code below is one of the lines of the table

<tr>
  <td style="width:70%;">
    <span value="1">Item</span>
  </td>
  <td class="text-center">
    <input class="eqQty text-center up" type="text">
  </td>
</tr>

I am sure that the answer is faily simple but googling has not been friendly to me on this one.

Kind Regards

I was thinking of adding queries using a basic HTML form. To be able to do that I was thinking of having a Query sql table which has all the main create, insert, remove, update, delete and select general syntax into it. The idea is to be able to choose a query based on a HTML select option and add the values to a field, any idea how can you do that dynamically?

I am creating a dynamic form in php. And i want to add fckeditor to this dynamic form.
so any idea about to add fckeditor to a dynamically creating form in php???

Any Help please???

Hello I'm using a small script (that I found online) to dynamically add fields to an order form. It works well with normal text fields but I would like to use it with a select box fields (as it draws data from MySQL).   My problem is, that when the field is 'cloned' it contains the product id and not the product name - which is what the user needs to see.

<?php
echo '<form method="post" name="orderform">';

// lots of form fields...

echo '<div id="itemRows">';
echo 'Item quantity: <input type="text" name="add_qty" size="4" />';


$prod = "SELECT prod_id, product FROM products ORDER BY product ASC";
$prodRes = $mysqli->query($prod);

echo 'Item name : <select name="add_name">';

	while ($p = $prodRes->fetch_assoc()) {
		echo'<option value="'.$p['prod_id'].'">'.$p['product'].'</option>';
	}

echo '</select>';

echo '<input onclick="addRow(this.form);" type="button" value="Add row" /> (Won't be saved until you click on "Add row")';



if(isset($product['qty']) && isset($product['name'])) {
?>

<p id="oldRow<?=$product['id']?>">
Item quantity: <input type="text" name="qty<?=$product['id']?>" size="4" value="<?=$product['qty']?>" />
Item name: <input type="text" name="name<?=$product['id']?>" value="<?=$product['add_name']?>" />
<input type="checkbox" name="delete_ids[]" value="<?=$product['id']?>"> Mark to delete
</p>
</div>
<?php 
}
?>
	
</div>

<input type="submit" value="Submit new order" name="addOrder">
</fieldset>
</div>
</form>




<script type="text/javascript">
var rowNum = 0;
function addRow(frm) {
	rowNum ++;
	var row = '<p id="rowNum'+rowNum+'">Item quantity: <input type="text" name="qty[]" size="4" value="'+frm.add_qty.value+'"> Item name: <input type="text" name="name[]" value="'+frm.add_name.value+'"> <input type="button" value="Remove" onclick="removeRow('+rowNum+');"></p>';
	jQuery('#itemRows').append(row);
	frm.add_qty.value = '';
	frm.add_name.value = '';
}

function removeRow(rnum) {
	jQuery('#rowNum'+rnum).remove();
}
</script>

I know I could use the $p['product'] value in the select box field, but when it is submiitted - it loses its  $p['prod_id'] value which I need to input back into the MySQL database.     I did try

       echo'<option value="'.$p['prod_id'].':'.$p['product'].'">'.$p['product'].'</option>';

and then explode...

    foreach($_POST['name'] as $key => $value) {

        $items[] = current(explode(":", $value));

    }

...but clearly, that is a dreradful solution and looks awful to the user.   Any thoughts, please?   Thank you.
Edited by tHud, 14 July 2014 - 09:31 AM.

I have 10 tables in my database.
I want load these 10 table names into a drop-down list.
If a user selects a value form the drop-down list, a form should be displayed with related to the table. (form fields should be appropriate table's column headers)
When user fill the form and submitted, data should be saved in the selected table.

Give me a code example to do this.

Hi, how would i display the date that is already in db and was submitted by user when he logs in to their profile?
That code below works for the values like 'approved' 'denied' so on, but how would i do same for a date? thank you.

Code: [Select]
<?php
include('config.php');
$uname=$_SESSION['username'];
if($_SESSION['username']){
$sql="SELECT ApplicationStatus FROM table1 WHERE uname='$uname'";
$result=mysql_query($sql);
$row = mysql_fetch_array($result);}
echo '<form name="test" method="post">
<select name="ApplicationStatus">
<option value="">------</option>
<option value="In process" '.(($row['column1']=='In process')?'selected="selected"':'').'>In process</option>
<option value="Withdrawn" '.(($row['column1']=='Withdrawn')?'selected="selected"':'').'>Withdrawn</option>
                </select>';
?>

hi i was wondering how i can display the values for a form that already in db. users submitted a form and then when they log in to their profile they can change the value in a form, but the original value would show the one that they first submitted. makes sense?

at the moment its set as blank, how would i display the option value to the one in the db on their profile? thanks

Code: [Select]
<form name="test" method="post">
<select name="ApplicationStatus">
<option value="'">------</option>
<option value="In process">In process</option>
<option value="Withdrawn">Withdrawn</option>
                </select>

I have a form for  a sign in page that I want the label for the form field to actually be displayed in the text box and clear when the box is selected to enter text.  I've accomplished this using the code below and it works fine.  The problem that I'm having is in IE the password field does not change to display dots or asterisk in place of each character.  It works fine in Fire Fox but not in IE.  Is there way to accomplish this using php or so that it is compatible with most browsers?

Here's the code that I'm using:
Code: [Select]
<?php

echo "<input type=\"text\" name=\"pword\" size=\"17\" value=\"Password...\" style=\"color: #999999\" onfocus=\"if (this.value == 'Password...') {this.value=''; this.style.color='#000000'; this.type='password';}\"> ";

?>

Hello Everyone..

Im a programer in php with little experience.
I have a form with 3 pages. 1st page display categories which come from category table. then user can select 1 or upto 3 category there. Then 2nd page display that selected categories and need to display relevant subject to that categories. In second page I use radio button for selected categories to keep a one category as a main category. each categories' subjects display with check boxes. In there too, user can select 1 or 3 more subject in to a particular category. In third form page, that my problem was encounter, there I need to print out  selected category and their subjects in a table.

first two pages are no problem for me and third form I have a problem in how to get categories and their subjects and they print as apiece in the page. like this

category1 | subject1, subject2, subject3
category2 | subject1, subject2, subject3, subject  and so forth.

This same to my first form page
Code: [Select]
$q = 'SELECT * FROM category ORDER BY category_id';
$r = mysqli_query( $dbc, $q);
$c = 0;
$i = 0;
echo '<form action="subjects.php" method="post">';
echo '<table class="form_table" ><tr>';

while($row = mysqli_fetch_array( $r, MYSQLI_ASSOC  )){

// if remainder is zero after 2 iterations (for 2 columns) and when $c > 0, end row and start a new row: 
if( ($c % 2) == 0 && $c != 0){
echo "</tr><tr>";
}
echo '<td width="50%"><input type="checkbox" name="category[]"  value="' . $row['category_id'] . '" />&nbsp;&nbsp;' . $row['category_name'] . '</td>';
$c++;
} // while..
// in case you need to fill a last empty cell:
if ( ( $i % 2 ) != 0 ){

// str_repeat() will be handy when you want more than 2 columns
  echo str_repeat( "<td>&nbsp;</td>", ( 2 - ( $i % 2 ) ) );
}
echo "</tr></table>";

?>

In second page 'subjects.php'  I use

Code: [Select]
if ( isset($_POST['submitted1']) && isset($_POST['category']) && sizeof( $_POST['category']) == 3 ) {

$_SESSION['category'] = $_POST['category'];

print_r ( $_SESSION['category']);

$q = 'SELECT * FROM category ORDER BY category_id';
$r = mysqli_query( $dbc, $q);

while($_SESSION = mysqli_fetch_array( $r, MYSQLI_ASSOC  )){

foreach( $_POST['category'] as $value ) {

if ( $value == $_SESSION['category_id']) {

$q = "SELECT category_subject.category_id, category_subject.subject_id, subjects
FROM category_subject
INNER JOIN category ON category_subject.category_id = category.category_id
INNER JOIN subject ON category_subject.subject_id = subject.subject_id
WHERE category_subject.category_id = {$_SESSION['category_id']}";

$r1 = mysqli_query( $dbc, $q);

$c = $i = 0;

echo '<table class="form_table" ><tr>';

while($_SESSION = mysqli_fetch_array( $r1, MYSQLI_ASSOC  )){

// if remainder is zero after 2 iterations (for 2 columns) and when $c > 0, end row and start a new row: 
if( ($c % 2) == 0 && $c != 0){
echo "</tr><tr>";
}
echo '<td width="50%"><input type="checkbox" name="subject[]"  value="' . $_SESSION['subject_id'] . '" />&nbsp;&nbsp;' . $_SESSION['subjects'] . '</td>';

$c++;

} // while..

// in case you need to fill a last empty cell:
if ( ( $i % 2 ) != 0 ){

// str_repeat() will be handy when you want more than 2 columns
  echo str_repeat( "<td>&nbsp;</td>", ( 2 - ( $i % 2 ) ) );
}

echo "</tr></table>";
}
}
}

}

Those two pages working properly.

In third page that my problem page I tried something like this , but its not working.
value come from subject.php page.

Code: [Select]
if ( ( isset($_POST['submitted2'])) && ( isset($_SESSION['category'])) && (isset( $_SESSION['subjects'])) && sizeof( $_SESSION['category']) == 1) {

//$_SESSION['category'] = $_POST['category'];

print_r ( $_SESSION['category']);

echo 'good';


} elseif ( ( isset($_POST['submitted2'])) && ( isset($_SESSION['category'])) &&
(isset( $_POST['main_category'] ))) {

print_r ( $_SESSION );


echo 'very good';

}
So can any body tell me where is my mistake and help me fix this problem.

any help greatly appreciated.

thank you.

I've got a form that submits values to itself and the user input values are saved into the database in a table with an auto incrementing ID. After SUBMIT is clicked, it reloads the page and all the values are gone, I'm wondering how I can get it to keep the values so that the user can make a single change and resubmit again.

I know I can save all the values into the session or in the URL or pass them through $_POST in an array but I'm wondering what is the proper way to do this. Thanks.

On one of my calculators : https://bizztools.net/2017/qccu/bizztools2015_budgetTest.php

When you press on the envelope in the middle you can send a form to yourself.
Currently it sends all the subtotals for each section .. Income, Personal, Debts etc and I wanted it to now  send  each individual value.

I've added the code in the file that gets used to send the form to the person's email.

Header section:

for ($i = 0; $i <= 79; $i++) {
$item_Annual[$i]  = number_format($_REQUEST['itemAnnualDisplay[$i]']); 
}

Body:     (each line of the form has a different value for $item_Annual)  from 1 to 79

		<TD bgcolor="#EEEEEE" align="left"  valign="middle" height="1"><Font style="font-family:Arial; font-size: 12px;"><font color="#000000">&nbsp;&nbsp;'.$currencySymbol.$item_Annual[1].' &nbsp;</TD>

I've also  added the return code in the  calculations php file.
This section of code is just for the Income sub section

for ($i = 0; $i <= 6; $i++) {
    $incomeSubtotal += $values[$i] * $periods[$i];
    $itemAnnual[$i] = $values[$i] * $periods[$i]; 
    $return['itemAnnualDisplay[$i]'] = $itemAnnual[$i]; 
}
                    
                    //New addtions are lines 3 and 4, the others were already there

 

Now, I've done some process of elimination and when testing to see if   $periods[$i] and values[$i] would show up on the form, the values were zero for each. So each $itemAnnual[$i]is calculated to be $0.

You can see from the form screenshot, the subtotals are calculating, but the individual items are not.

Could this have anything to do with the  form on the calculator page? It's in bootstrap.

 

Help please!! 

 

 

 

 

Hi,

I need a clue on how to do a form with a "List/Menu" that when I choose one value on the "List" the page will reload and show that "List/Menu" and other new one.

There are exemples on how to do this?

Best Regards,

Hi, I got this form which passes hidden values as well as a select menu.  The only thing is, it doesnt seem to post the form data to the script.   Here is the form

echo '<form action="regsale.php" method="POST">';
echo '<input type="hidden" name="username" value="<?php echo $username ?>"';
echo '<input type="hidden" name="listing_title" value="<?php echo $listing_title ?>"';
echo '<input type="hidden" name="speciesCommon" value="<?php echo $speciesCommon ?>"';
echo '<input type="hidden" name="cost" value="<?php echo $cost ?>"';
echo '<input type="hidden" name="business" value="<?php echo $business ?>"';
echo '<input type="hidden" name="postage_cost" value="<?php echo $postage_cost ?>"';
echo '<input type="hidden" name="multipostage" value="<?php echo $multipostage ?>"';

echo "<ul class='results'>";
echo '<li>Quantity:</li>';      
echo '<select name="quantity">';
echo "<option value='$quantity'>Maximum of $quantity available</option>";
for ($q=1; $q<=$quantity; $q++) 
{
    echo "<option value='$q'>$q</option>";
}
echo '</select>';
echo' </ul><br>';



echo '<div align="center">';
echo '<br>';
echo '<input type="submit" value="Confirm Purchase"><br>';
echo '</form><br>';

And here is the script that the form is posted to

<?php
include 'init.php';
include 'includes/overall/header.php';
include 'includes/logo.php';


if (!isset($_SESSION['loggedin'])) {
   die("You must be logged in to submit care guides"); //this causes to script to stop executing and lets the user know there is a problem

/*
Note:  instead of the die() function, you could use the echo() function and provide an HTML link back to the login page, or use the header() function to just redirect users to the login page without any message. It is up to you to decide what your application should behave.
*/
}

//else {  //logged in 
elseif (isset($_SESSION['loggedin']) ){  //logged in 
$username = $_SESSION['loggedinuser'];


if	(isset($_POST['listing_title'], $_POST['speciesCommon'], $_POST['cost'], $_POST['business'], $_POST['postage_cost'], $_POST['multipostage'], $_POST['quantity'] ) ) {

    if( $_POST['listing_title'] == "" )
    {
        echo "Error: Please go back and try again";
    }
     elseif( $_POST['speciesCommon'] == "" )
    {
        echo "Error: Please go back and try again";
    }
  elseif( $_POST['cost'] == "" )
    {
        echo "Error: Please go back and try again";
    }
    elseif( $_POST['business'] == "" )
    {
        echo "Error: Please go back and try again";
    }
    elseif( $_POST['postage_cost'] == "" )
    {
        echo "Error: Please go back and try again";
    }
    elseif( $_POST['multipostage'] == "" )
    {
        echo "Error: Please go back and try again";
    }
    elseif( $_POST['quantity'] == "" )
    {
        echo "Error: Please go back and try again";
    
   
} else {

  
  	
    		
	$listing_title = mysqli_real_escape_string($con, $_POST['listing_title']);
        $speciesCommon = mysqli_real_escape_string($con, $_POST['speciesCommon']);
        $cost = mysqli_real_escape_string($con, $_POST['cost']);        
        $business = mysqli_real_escape_string($con, $_POST['business']);
        $postage_cost = mysqli_real_escape_string($con, $_POST['postage_cost']);
        $multipostage = mysqli_real_escape_string($con, $_POST['multipostage'] );		
        $quantity = mysqli_real_escape_string($con, $_POST['quantity'] );		



if( $multipostage == "per item" )
    {
    $postage_cost = $quantity * $postage_cost;
    }
    elseif( $multipostage == "Combined Postage" )
    {
	$postage_cost;
    }     

$total = $cost + $postage_costage;

// Writes customer_sales information to the MySQL database                    

        	$sqlCustomerSales = "INSERT INTO customer_sales(username, listing_title, speciesCommon, total, business, postage_cost, multipostage ) VALUES (
                        '". $username ."',
                        '". $listing_title ."',                                                                                        
                        '". $speciesCommon ."',
                        '". $total ."',
                        '". $business ."',
                        '". $postage_cost ."',
                        '". $multipostage."'                       
                        )";
          
$result1 = mysqli_query($con, $sqlCustomerSales); 

// This writes the transaction to the MySQL database

$memo = $listing_title;
$datetime = date("Y-m-d H:i:s");

$regCustomerTransaction = "INSERT INTO customer_transactions(username, datetime, cost, postage_cost, memo) VALUES (
					'". $username ."', 
					'". $datetime ."', 
					'". $cost ."', 
					'". $postage_cost ."',
					'". $memo."'
					)";
		 
// Query the database 
$result2 = mysqli_query($con, $regCustomerTransaction); 
}

// This writes the user_stats to the MySQL database

$total_items_sold = $quantity;

$regUserStats = "INSERT INTO user_stats(username, datetime, total, items_listed, bonus_credits, last_credit_purchase, total_care_guides, total_items_sold,
total_currently_listed_items, total_items_purchased, total_diary_entries, feedback ) VALUES (
					'". $username ."', 
					'". $datetime ."',
					'". $total ."',  					
					'". $quantity ."',  					
					'". $subtotal ."',  					
					'". $last_credit_purchase ."',  					
					'". $total_care_guides ."',  					
					'". $total_items_sold ."',  					
					'". $total_currently_listed_items ."',  					
					'". $total_items_purchased ."',  					
					'". $total_diary_entries ."',  					
					'". $feedback."'
										)";
		 
// Query the database 

$result3 = mysqli_query($con, $regUserStats); 
}

?>


<h1>Payment to <?php echo $username ?></h1><br>

<?php
echo '<strong>Thank you for confirming you would like to purchase $speciesCommon; </strong>';
echo '<br>';
echo '<strong>Your payment comes to a total of $total; </strong></h2>';
echo '<br>';
echo '<br>';
echo 'Please complete payment using the PayPal button<br>';
echo '<br>';
echo '<br>';
?>

<form name="_xclick" action="https://www.paypal.com/cgi-bin/webscr" method="post">
<input type="hidden" name="cmd" value="_xclick">
<input type="hidden" name="shipping" value="<?php echo $postage_cost ?>">
<input type="hidden" name="business" value="<?php echo $business ?>">
<input type="hidden" name="currency_code" value="GBP">
<input type="hidden" name="item_name" value="<?php echo $speciesCommon ?>">
<input type="hidden" name="amount" value="<?php echo $cost ?>">
<input type="image" src="https://www.paypalobjects.com/en_US/GB/i/btn/btn_buynowCC_LG.gif" border="0" name="submit" onclick="OnButton1(); OnButton2();" alt="PayPal – The safer, easier way to pay online." >
<img alt="" align="center" border="0" src="https://www.paypalobjects.com/en_GB/i/scr/pixel.gif" width="1" height="1"></form>


<?php
} else { 
 
	echo 'Sorry we were unable to process your listing. Please contact <a href="mailto:helpdesk@aquapetcentre.com?Subject=Listing%20error">helpdesk@aquapetcentre.com';
   die(); 
 
include('includes/overall/footer.php');
}


// Close the connection 
mysqli_close($con); 
?>

<h1>Payment to <?php echo $username ?></h1><br> works, but I think that is because it is passed in the SESSION.   Any other $variable such as those below

echo '<strong>Thank you for confirming you would like to purchase $speciesCommon; </strong>';
echo '<br>';
echo '<strong>Your payment comes to a total of $total; </strong></h2>';

does not work.   Why is the form not posting the values to the database.   Just in case it helps, the form gets its values from the database, and the values are displayed in the sales page on which the form is contained. Here is the page containing the form.

<?php
include 'init.php';
include 'includes/overall/header.php';
include 'includes/logo.php';



if (!isset($_SESSION['loggedin'])) {
   die("You must be logged in to view this page!"); //this causes to script to stop executing and lets the user know there is a problem

/*
Note:  instead of the die() function, you could use the echo() function and provide an HTML link back to the login page, or use the header() function to just redirect users to the login page without any message. It is up to you to decide what your application should behave.
*/
}

//else {  //logged in 
elseif (isset($_SESSION['loggedin']) ){  //logged in 

$username = $_SESSION['loggedinuser'];

$results = $con->query("SELECT * FROM user WHERE username = '$username';");
while($row = $results->fetch_array()) {
$business = $row['paypal_email'];


$user_id = $_GET['user_id'];

$results1 = $con->query("SELECT * FROM live_sales WHERE user_id = '$user_id';");
while($row = $results1->fetch_array()) {

$username  			= $row['username'];
$fishtype    		= $row['fishtype'];
$speciesCommon 		= $row['speciesCommon'];
$speciesScientific  = $row['speciesScientific'];
$listing_title    	= $row['listing_title'];
$age 		        = $row['age'];
$quantity	        = $row['quantity'];
$origin       	    = $row['origin'];
$size               = $row['size'];
$environment 		= $row['environment'];
$waterChemistry	    = $row['waterChemistry'];
$temperature       	= $row['temperature'];
$feeding            = $row['feeding'];
$sexing 		    = $row['sexing'];
$compatability	    = $row['compatability'];
$temperament      	= $row['temperament'];
$breeding           = $row['breeding'];
$comments 		    = $row['comments'];
$postage_type	    = $row['postage_type'];
$postage_cost      	= $row['postage_cost'];
$multipostage		= $row['multipostage'];
$cost      			= $row['cost'];


echo "<div class='result'>";
echo "<h3>$speciesCommon</h3>";
echo "<h2>$listing_title</h2>";
echo "<ul class='results'>";
echo "<li>Species</li>" . str_replace("_"," "," $fishtype") . "<br>";
echo "<li>Common Name:</li> $speciesCommon<br>";
echo "<li>Scientific Name:</li> $speciesScientific<br>";
echo "<li>Age:</li> $age<br>";
echo "<li>Quantity:</li> $quantity<br>";
echo "<li>Price per item:</li> £$cost<br>";
echo "<li>Origin:</li> $origin<br>";
echo "<li>Size:</li>$size<br>";
echo "<li>Environment:</li> $environment<br>";
echo "<li>Water Chemistry</li> $waterChemistry<br>";
echo "<li>Temperatu </li> $temperature<br>";
echo "<li>Feeding:</li> $feeding<br>";
echo "<li>Sexing:</li> $sexing<br>";
echo "<li>Compatability:</li> $compatability<br>";
echo "<li>Temperament:</li> $temperament<br>";
echo "<li>Breeding:</li>$breeding<br>";
echo "<li>Comments:</li> $comments<br>";
echo "<li>Postage Type:</li>$postage_type<br>";
echo "<li>Postage Cost:</li> £$postage_cost $multipostage<br>";



echo '<form action="regsale.php" method="POST">';
echo '<input type="hidden" name="username" value="<?php echo $username ?>"';
echo '<input type="hidden" name="listing_title" value="<?php echo $listing_title ?>"';
echo '<input type="hidden" name="speciesCommon" value="<?php echo $speciesCommon ?>"';
echo '<input type="hidden" name="cost" value="<?php echo $cost ?>"';
echo '<input type="hidden" name="business" value="<?php echo $business ?>"';
echo '<input type="hidden" name="postage_cost" value="<?php echo $postage_cost ?>"';
echo '<input type="hidden" name="multipostage" value="<?php echo $multipostage ?>"';

echo "<ul class='results'>";
echo '<li>Quantity:</li>';      
echo '<select name="quantity">';
echo "<option value='$quantity'>Maximum of $quantity available</option>";
for ($q=1; $q<=$quantity; $q++) 
{
    echo "<option value='$q'>$q</option>";
}
echo '</select>';
echo' </ul><br>';



echo '<div align="center">';
echo '<br>';
echo '<input type="submit" value="Confirm Purchase"><br>';
echo '</form><br>';

 
echo '<br><br>
</div>';


exit();
}
} 
echo 'Sorry but we could not find any results.';
}
include 'includes/overall/footer.php';
?>

Any help is always appreciated.    aquaman

If I store a value in a hidden form control, and then use that as a means to pass the value to another PHP script, could that cause any security issues?