|
PHP - Changing Form Values
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';}\"> "; ?> Similar TutorialsHi, I'm using the following code: <td>$row[color]</td> and the possible values for this field are 1, 2 and 3. But I want the return to be red for 1, blue for 2, and green for 3. How do I write it so that instead of getting a row of 1's, 2's and 3's, I change those numbers to their corresponding colors? Thanks! Can be those <input ...> types with values changed from a script ?. Imagine it like we have an admin and we want to change some input values with a generated form on that page instead of going source and changing 1 by 1 ? Hi Just learning PHP and I'm struggling with a very simple problem. I'm playing around with arrays as i figure they're one of the most important things to know inside out but I can't work out how to change the value of an array element via a loop. I can obviously do it if I just directly write $cars[2] = "test" but not having any luck with the loop. I've tried using "foreach" and passing a new value to the $value variable but when i do a print_r the values in the array are unchanged. Code: [Select] $cars[0]="Saab"; $cars[1]="Volvo"; $cars[2]="BMW"; $cars[3]="Toyota"; foreach ($cars as $key => $value) { $value = "TEST"; echo $key . " " . $value . "<br />"; } print_r($cars) I then tried using a for loop Code: [Select] for ($i=0; $i <= count($cars); $i++) { echo $cars[$i]; $cars[$i] = "2"; } But this code just threw up a fatal error as follows: "Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 16 bytes) in /home/zzzzzzzz/public_html/php_testing/arrays.php on line 27" So would someone be kind enough to explain where i'm going wrong and why i get the fatal error on the second for loop. Thanks Drongo I'm not completely sure how to implement this so I'd like to ask you to give me an idea if you can For a tennis booking system.. it will look something similar to (should be a table but this is for the sake of the idea) Date: Oct 25th, 2010 (go to oct 26) Court 1 Court 2 Court 3 Court 4 8:00 Open(bookit) Tally Open Hellio 9:00 Andy Roger Barney Training ...etc Now everyday, this table should be empty, so new bookings can be made how would I make it so a new table is empty /or has dif bookings every day (based on date) efficiently? Im guessing I will have dif values in the sql table for dif dates but what I'm not sure of is how to display it in page for ex, if someone presses the button oct 26, the new table is for that date, wif diff values Hi I have an array which looks like this when i do a print_r(): Array ( => Array ( [path] => 1 [order] => 2 ) [1] => Array ( [path] => 2 [order] => 1 ) [2] => Array ( [path] => 3 [order] => 2 ) ) In this instance, I want to change the values of the order key. So I do something like this so that the last array has a path of 3 and an order of 1, and the others have orders of 2 foreach ($old_images as $old_image){ if($old_image['path']==3){ $old_image['order']="1"; } else{ $old_image['order']="2"; } } When i step through, i see that the order is changed, but when i do a print_r(), i get the same result. So even though im resetting the order value of the inside arrays, the multidimensional array does not change.... any ideas? I am trying to make a Web Form for people to fill out that has two drop down menus where i want the first drop down menu's selection changes the values of the selections in the second drop down. ((IE. If the first drop down value is "product 01" then the second drop down shows values "Red, Green, Blue" while if the first drop down value is "product 02" then the second drop down shows values "Yellow, Green")) Anyone have any ideas? Thanks in Advance. Ok I am testing foreach in an array as my practice. I wonder how can I assign values in the key of the array.. Here's the code Code: [Select] <?php $username = me_mysql_prep(trim($_POST['username'])); $first_name = me_mysql_prep(trim($_POST['first_name'])); $last_name = me_mysql_prep($_POST['last_name']); $email = me_mysql_prep($_POST['email']); $position = me_mysql_prep($_POST['Position']); $password = me_mysql_prep($_POST['password']); $hashed_password = sha1($password); $required_fields = array($username,$first_name,$last_name, $email, $position, $password); foreach($required as $key => $value) { if($value == "") { echo $key . " Cannot be empty<br>"; } } ?> So the result would be like this... IF username, first name and last name are EMPTY it will echo: Quote username cannot be empty first name cannot be empty last name cannot be empty Anyone? I posted a topic earlier and there was confusion as to what I could not work out.
I am able to display the checkbox, either checked or unchecked depending of the value or 1 or 0 in the obcDisplay field.
<input type="checkbox" name="obcDisplay" value="<?=$r['obcDisplay'] ?>" <?=($r['obcDisplay']) ? 'checked="checked"' : ''; ?>/>I am trying to update the DB table by the checkbox. If the checkbox is checked (obcDisplay = 1) and I uncheck the box and submit, I want the table updated so that obcDisplay now equals 0. When the form is displayed, the checkbox is now uncheck (obcDisplay = 0). Now I check the box and submit and the update changes the field from 0 to 1. I can display the checkbox as checked or unchecked by the DB field obcDisplay being either 0 or 1. It is changing the value where I am having the problem. Hi, I have a weather app, coded which creates weather based on a set zip code. I want to create a form which when the user fills out their local code and clicks the send button that will change the zip code variable. Currently it is set up like this $zip = '90210'; //change to your zipcode need help with getting started with this. Thanks! Hi there, I was wondering if it was possible to change a forms action field with PHP. Basically, if there are several checkboxes for the user to select and a specific checkbox was selected, how would I redirect users to an alternative webpage on submit? I've been playing around with several methods, and one of them was: Code: [Select] <?php if(isset($_POST['Example']) && $_POST['Example'] == 'FormValueGoesHere') { echo ('./page1.php'); } else { echo ('./page2.php'); } ?> But the form action would only display page1.php even with nothing selected. Maybe I'm just being stupid because it's getting late, but I'd appreciate any assistance. Thanks Hello everyone, I'm having a difficult time figuring out what my problem is here. I'm trying to submit a couple of strings (to the user they are messages to be sent to other users) and I am having trouble with the string being cut off at quotation marks. Here is the code that I'm using: Code: [Select] <?php if (isset($_POST['submit'])) { $staffmessage = $_POST['staffmessage']; $studentmessage = $_POST['studentmessage']; echo "$staffmessage<br /> <br />$studentmessage"; } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> </head> <body> <?php $message1="This is a test message. It does not get cut off here when the \"quotation marks\" are added."; $message2="This is a test message. It DOES get cut off here when the \"quotation marks\" are added."; ?> <form name="form" method="post" action="test.php"> <textarea class="textarea" name="staffmessage" rows="12"> <?php echo $message1; ?> </textarea></p> <input name="studentmessage" type="hidden" value="<?php echo $message2; ?>" /> <input class="submit2" type="submit" name="submit" value="Send Message" /> </form> </body> </html> The result that I'm getting is that when $staffmessage is echoed, I get the full message. When $studentmessage is echoed, the message gets cut off at the first quotation mark. The only thing that is different when creating these two variables is that $staffmessage is submitted using a "textarea" field in the form, and $studentmessage is submitted using a "hidden" field in the form. Other than that, they are handled the exact same way. Can anyone please help me figure out how to remedy this so that $studentmessage is not cut off at the quotation mark? Thanks in advance for your help! I changed the imput type on a registration form from type="submit" to type="image" and the warning messages don't show here is the code Code: [Select] [<?php include "includes/config.php"; include "includes/functions.php"; session_start(); ob_start(); $name=trim($_REQUEST['name']); $company=trim($_REQUEST['company']); $phone=trim($_REQUEST['phone']); $email=trim($_REQUEST['email']); $address=trim($_REQUEST['address']); $city=trim($_REQUEST['city']); $state=trim($_REQUEST['state']); $zipcode=trim($_REQUEST['zipcode']); $loginid=trim($_REQUEST['loginid']); $password=trim($_REQUEST['pw1']); $confirmpassword=trim($_REQUEST['pw2']); if(isset($_REQUEST['Submit'])) { if($password==$confirmpassword) { if( $_SESSION['security_code'] == $_POST['security_code'] && !empty($_SESSION['security_code'] ) ) { if(mysql_num_rows(mysql_query("SELECT * FROM `tbl_registration` WHERE `loginid` = '".$loginid."'")) == 0) { $sqlregister = "INSERT INTO `tbl_registration`(`name`,`company`,`phone`,`email`,`address`,`city`,`state`,`zip`,`loginid`,`password`) VALUES ('".$name."','".$company."','".$phone."','".$email."','".$address."','".$city."','".$state."','".$zipcode."','".$loginid."','".$password."') "; $rsregister= mysql_query($sqlregister); //$num=mysql_num_rows($rssearch); /*$rowArr=array(); $rowResult=array(); */ $Msg=message("You Have Registered Successfully..",2); if(is_dir("upload/".$loginid)) $msg1 = message("Problem With Creating Account.!",2); else { mkdir("upload/".$loginid); mkdir("upload/".$loginid."/web"); mkdir("upload/".$loginid."/email"); mkdir("upload/".$loginid."/emaildata"); } } else $msg = message("Login Id already exists..try another.!",2); } else { $msg =message("Sorry, you have provided an invalid security code.!",2); } } else $msg = message("confirm password does not match.!",2); } ?>/code] the form [code]<form name="form1" action="your_info.php" method="post" onSubmit="return validate(form1);"> <table width='360' cellpadding='1' cellspacing='2' bordercolor='#CACEDA' class="borders" align="center"> <tr> <td></td> <td colspan="3" class="txt3"><span style="padding-left:35px;"> <?=$Msg;?><br><?=$msg;?><br><?=$msg1;?> </span></td> </tr> <tr> <td width="16"></td> <td width="100" class="txt3"><div align="right">Name:</div></td> <td width="200"><input name="name" type="text" size="40" class="ordertextin" value="<?=$name;?>"></td> <td width="20"></td> </tr> <tr> <td width="16"></td> <td width="100" class="txt3"><div align="right">Company:</div></td> <td width="200"><input name="company" type="text" size="40" class="ordertextin" value="<?=$company;?>"></td> <td width="20"></td> </tr> <tr> <td width="16"></td> <td width="100" class="txt3"><div align="right">Phone:</div></td> <td width="200"><input name="phone" type="text" size="40" class="ordertextin" value="<?=$phone;?>"></td> <td width="20"></td> </tr> <tr> <td width="16"></td> <td class="txt3" width="100"><div align="right">Email:</div></td> <td><input name="email" type="text" size="40" class="ordertextin" value="<?=$email;?>"></td> <td width="20"></td> </tr> <tr> <td width="16"></td> <td width="100" class="txt3"><div align="right">Address:</div></td> <td width="200"><input name="address" type="text" size="40" class="ordertextin" value="<?=$address;?>"></td> <td width="20"></td> </tr> <tr> <td width="16"></td> <td width="100" class="txt3"><div align="right">City:</div></td> <td width="200"><input name="city" type="text" size="30" class="ordertextin" value="<?=$city;?>"></td> <td width="20"></td> </tr> <tr> <td width="16"></td> <td width="100"> <div align="right"><span class="txt3">State:</span></div></td> <td width="200" align="left"> <select name="state" class="ordertextin"> <option selected>Choose one </option> <option value="AL">Alabama</option> <option value="AK">Alaska</option> <option value="AZ">Arizona</option> <option value="AR">Arkansas</option> <option value="CA">California</option> <option value="CO">Colorado</option> <option value="CT">Connecticut</option> <option value="DE">Delaware</option> <option value="FL">Florida</option> <option value="GA">Georgia</option> <option value="GU">Guam</option> <option value="HI">Hawaii</option> <option value="ID">Idaho</option> <option value="IL">Illinois</option> <option value="IN">Indiana</option> <option value="IA">Iowa</option> <option value="KS">Kansas</option> <option value="KY">Kentucky</option> <option value="LA">Lousiana</option> <option value="ME">Maine</option> <option value="MD">Maryland</option> <option value="MA">Massachusetts</option> <option value="MI">Michigan</option> <option value="MN">Minnesota</option> <option value="MS">Mississippi</option> <option value="MO">Missouri</option> <option value="MT">Montana</option> <option value="NE">Nebrasca</option> <option value="NV">Nevada</option> <option value="NB">New Brunswick</option> <option value="NH">New Hamshire</option> <option value="NJ">New Jersey</option> <option value="NM">New Mexico</option> <option value="NY">New York</option> <option value="NC">North Carolina</option> <option value="ND">North Dakota</option> <option value="OH">Ohio</option> <option value="OK">Oklahoma</option> <option value="OR">Oregon</option> <option value="OTHER">Other</option> <option value="PA">Pennsylvania</option> <option value="PR">Puerto Rico</option> <option value="RI">Rhode Island</option> <option value="SC">South Carolina</option> <option value="SD">South Dakota</option> <option value="TN">Tennessee</option> <option value="TX">Texas</option> <option value="UT">Utah</option> <option value="VT">Vermont</option> <option value="VI">Virgin Islands</option> <option value="VA">Virginia</option> <option value="WA">Washington</option> <option value="DC">Washington DC</option> <option value="WI">Wisconsin</option> <option value="WY">Wyoming</option> <option value="YK">Yukon</option> </select> </td> <td width="20"></td> </tr> <tr> <td width="16"></td> <td width="100" class="txt3"><div align="right">Zip:</div></td> <td width="200"><input name="zipcode" type="text" size="30" class="ordertextin" value="<?=$zipcode;?>"></td> <td width="20"></td> </tr> <tr> <td></td> <td class="txt3" width="100"><div align="right">Login Id: </div></td> <td><input name="loginid" type="text" size="30" class="ordertextin" value="<?=$loginid;?>"></td> <td></td> </tr> <tr> <td width="16"></td> <td class="txt3" width="100"><div align="right">Password:</div></td> <td><input name="pw1" type="password" size="40" class="ordertextin" value="<?=$password;?>"></td> <td width="20"></td> </tr> <tr> <td width="16"></td> <td class="txt3"><div align="right">Confirm Password: </div></td> <td><input name="pw2" type="password" size="40" class="ordertextin" value="<?=$confirmpassword;?>"></td> <td width="20"></td> </tr> <tr> <td height="10"></td> <td><div align="right">Security Code: </div></td> <td><img src="CaptchaSecurityImages.php?width=150&height=28&characters=7"/><br/><input id="security_code" name="security_code" type="text" class="inputType Inputsize150"/></td> </tr> <tr> <td width="16"></td> <td></td> <td> </td> <td width="20"></td> </tr> <tr><td height="20"></td> <td></td> <td><DIV class=satisfaction-quarantee-image-alignment ><INPUT type="image" name="Submit" height=54 alt="submit" width=208 src="images/submit_butom.gif"></DIV></td> </tr> </table> </form> Thanks. 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> 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>'; ?> 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. I've added the code in the file that gets used to send the form to the person's email.
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"> '.$currencySymbol.$item_Annual[1].' </TD>
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!!
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'] . '" /> ' . $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> </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'] . '" /> ' . $_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> </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. 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
Hey everyone. I have a project I'm working on and am having some issues. I'm trying to build a web-based FTP program for a client. I have all the ftp stuff down packed, but I'm having issues with connecting to a local computer. I can get the directories an a local disk viewing and changing just fine, my problem is I'm wondering how I might pass each value of the array generated by the scandir() function into a form element value such as a checkbox. The furthest I've been able to get with this is displaying the last object in the array. Here is some code: <?php foreach ($d as $key => $val) { echo "<table width=auto height=auto border=0> <tr> <td><img src=".$icon." width=16 height=16></td> <td>".$val."</td> <td><input name=selection type=checkbox value=".$val."></td> </tr> </table>"; ?> All I get is the last item in the array. any help is appreciated. Hi, I'm trying to pass values from an array into a form. As a newbie, I've came up with the code underneath, but I want to pinpoint all the first values toward 1 selection list in the form. Any suggestions how to accomplish this? Thanks in advance. Ruud <html> <head> <title>Test formulier</title> </head> <body> <h2>Test formulier</h2> <form action="test.php" method="post"> <p> <?php $prijzen = array( array("01", "125","150", "A" => true,"B" => true), array("02", "125","150", "A" => true,"B" => true), array("03", "125","150", "A" => true,"B" => false), array("04", "125","150", "A" => true,"B" => true) ); ?> </P> <select name="prijzen[]" id="prijzen" multiple="multiple" size="7" class="none"> <?php while(list($key, $val) = each($prijzen)){ while(list($key2, $val2) = each($val)){ echo '<option value="'.$key2.'">'.$val2.'</option>'.PHP_EOL; } } ?> </select> </body> </html> |
|||||||