jsk1gcc

Ignore last post, silly me, spelt them wrong Thanks dragon_sa, i'll try inserting them and let you know how it goes =)

Notice: Undefined variable: endprice1 on line 120 Notice: Undefined variable: endprice2 in p on line 121 It does not like them, I'm unsure what to to?

Where should I declare them, after $endPrice1= ($total1+$seatPrice1); $endPrice2= ($total2+$seatPrice2); ?? A look at the syntax and structure of the query would bea great help too =)

Hi, I could really do with some help putting the prices from two drop down boxes into sessions To start with the user can choose two seats one from each drop down box //DROP DOWN BOX ONE $extract =mysql_query("SELECT * FROM ride WHERE rideID ='1'"); $numrows = mysql_num_rows($extract); //start of form echo '<form method="post" name="f1" action="card.php">'; echo 'Please choose a seat: '; echo"<select name='seat' >"; while( $row = mysql_fetch_assoc($extract)) { $rideID = $row ['rideID']; $name = $row ['name']; $seatNumber = $row ['seatNumber']; $time = $row ['time']; $price = $row ['price']; echo "<option name='seat'> $seatNumber </option>"; $_SESSION['extract']=$_POST['seat']; } echo '</select><br>'; //DROP DOWN BOX TWO $extract2 =mysql_query("SELECT * FROM ride WHERE rideID ='1'"); $numrows = mysql_num_rows($extract2); //start of form echo '<form method="post" name="f2" action="card.php">'; echo 'Please choose a seat: '; echo"<select name='seat2' >"; while( $row = mysql_fetch_assoc($extract2)) { $rideID = $row ['rideID']; $rideName = $row ['rideName']; $seatNumber = $row ['seatNumber']; $time = $row ['time']; $price = $row ['price']; echo "<option name='seat2'> $seatNumber </option>"; $_SESSION['extract2']=$_POST['seat2']; } echo '</select><br>'; at the moment I have this : $query =mysql_query("SELECT price FROM ride WHERE rideID ='1' LIMIT 1"); while ($row=mysql_fetch_array($query)) { echo $row['price']; echo "<br>"; $seatPrice1=($row['price']); $seatPrice2=($row['price']*2); $vat1=17.5; function vat($vat, $row['price']) { return sprintf("%01.2f", ($vat*$row['price]/ 100)); } $vatprice = vat(17.5, 2.50); $total1=($vatprice); $total2=($vatprice*2); $endPrice1= ($total1+$seatPrice1); $endPrice2= ($total2+$seatPrice2); What I need is $endPrice1 and $endPrice2 in $_SESSIONS so i an INSERT them in to the database 3 pages away from this query/VAT fucntion. Can anyone help?

sure check this one out: part1 http://www.youtube.com/watch?v=yuLpSospbBk part2 http://www.youtube.com/watch?v=LF5zTWthpn0&feature=channel hope they help =)

I fixed it by myself, no problems. code is here for anyone else who might have the same problem somewhere down the line update.php <?php require("connect.php"); $extractR = mysql_query("SELECT DISTINCT rideID, rideName FROM ride ORDER BY rideID " ); $numrows = mysql_num_rows($extractR); echo " Change the ride name: <form action='mysql_update.php' method='POST'> <select name='ride_name' >"; while ($row=mysql_fetch_assoc($extractR)) { $rideID = $row ['rideID']; $rideName = $row ['rideName']; #$seatNumber = $row ['seatNumber']; #$time = $row ['time']; #$price = $row ['price'];value='$rideID' echo $row; echo "<option value='$rideID'> $rideName </option>"; } echo "</select> <input type='text' name='tochangeRide'> <input type='submit' name='submit' value='change'> </form>"; ?> mysql_update.php <?php require ('connect.php'); $ride_name=$_POST['ride_name']; $tochangeRide=$_POST['tochangeRide']; if ($ride_name&&$tochangeRide) { $changeR = mysql_query("UPDATE ride SET rideName='$tochangeRide' WHERE rideID='$ride_name'"); } echo "You have updated the ride name to $tochangeRide"; ?>

hey can someone advice me on how to make my update script update multiple rows. here's what i've got so far: update.php <?php require('connect.php'); $update = mysql_query("SELECT DISTINCT rideName FROM ride ORDER BY rideName DESC" ); $numrows = mysql_num_rows($update); echo "<form action='mysql_update.php' method='POST'> <select name='updateRide' >"; while ($row=mysql_fetch_assoc($update)) { #$rideID = $row ['rideID']; $rideName = $row ['rideName']; #$seatNumber = $row ['seatNumber']; #$time = $row ['time']; #$price = $row ['price']; echo "<option value='$id'> $rideName </option>"; } echo "</select> <input type='text' name='tochange'> <input type='submit' name='submit' value='change'> </form>"; ?> and now the handler script: mysql_update.php <?php require ('connect.php'); $updateRide=$_POST['updateRide']; $tochange=$_POST['tochange']; if ($updateRide&&$tochange) { $change = mysql_query("UPDATE ride SET rideName='$tochange' WHERE $id='updateRide'"); } ?> When I try this I get nothing, no changes. In the table there is 3 distinct rideNames each have more than 20 rows. Is there a way using the drop down box and ext field like i Have to update all of the distinct rideNames in the table? Thanks.

Okay to start with, I apologise for the messy code. I have a table called ride with a column called price(it is 2.50). I need to query the table and then add VAT to it. the query I have at the moment is $query =mysql_query("SELECT price FROM ride WHERE rideID ='1' LIMIT 1"); while ($row=mysql_fetch_array($query)) { echo $row['price']; echo "<br>"; } The result of the echo is 2.50 The VAT function is $seatPrice2=($price*2); $seatPrice1=($price*1); $vat1=17.5; function vat($vat, $price) { return sprintf("%01.2f", ($vat*$price/ 100)); } $vatprice1 = vat(17.5, 2.50); $vatprice2 = vat(17.5, 2.50); $total2=($vatprice2*2); $endPrice2= ($total2+$seatPrice2); $total1=($vatprice1*1); $endPrice1= ($total1+$seatPrice1); echo"$endPrice1"; echo "<br>"; echo "$endPrice2"; endPrice1 is the value of one seat including VAT and endPrice2 is the value of 2 seats inc VAT. I have used echo during development, the endPrice1 and 2 could really do with being in a session, as they won't be posted back to the user on the same page and I would like to use them in an email script. [also to note, the user can choose one seat or two seats] I would really appreciate some help in turning what I have into a result that I can place into a session. Thanks =)

I had this problem when I first started out, I would suggest you look at these video tutorials I found. They really helped me, hope they do you too. =) http://www.youtube.com/user/phpacademy?blend=1&ob=4#g/p

Just a quick question I have a form, couple of drop down boxes, input fields etc.. at the end is the submit button. now my question is should my insert into database sqls go before the submit button inside the form? out side the form? after the button inside the form? If by any chance you could give me some advice on the best way to layout my sql that would be great. They are big and go into three tables, at the moment I have them as three seperate queries but I think they must be able to go into one. can someone please help me with the layout and syntax. here is what the queries look like at the moment: if ($IBselect=$_POST ['IBselect']); { //CUSTOMER $enterCust="INSERT INTO customer(username, password, title, firstName, lastName, address, town, country, postCode, phone, email, dateCust) VALUES ('$_POST[username]', '$_POST[password]', '$_POST[title]', '$_POST[firstName]', '$_POST[lastName]', '$_POST[address]', '$_POST[town]', '$_POST[country]', '$_POST[postCode]', '$_POST[phone]', '$_POST[email]', 'DATE: Auto CURDATE()', CURDATE()"; $enterCust_query=mysql_query($enterCust)or die(mysql_error()); //CARD $enterCard="INSERT INTO card(cardNumber, name, expDate, cardID) VALUES ('$_POST[cardNumber]','$_POST[name]', ' $_POST[expDate]', '$_POST[cardID]')"; $enterCard_query=mysql_query($enterCard); //BOOKING $RCenterBook=mysql_query("INSERT INTO booking (custNumber, cardID, rideName, seatNo1, seatNo2, price, price2, dateBook, ID_time_tbl) VALUES ('$custNumber', '$_POST[cardID]', '$rideName', '$_SESSION[iBextract]', '$_SESSION[iBextract2]', '$IBendPrice1', '$IBendPrice2', 'DATE: Auto CURDATE()', CURDATE()', '$_SESSION[iB_slot_Time]'"); $IBenterBooking_query=mysql_query($IBenterBook); if (!mysql_query($enterCard, $enterCust, $IBenterBook)) { die("Error:" .mysql_error()); } echo "1 record added IB"; } Thanks =)

I have two drop down boxes that give me the result $extract and $extract2. The user can not pick the same seat in each drop down box. I am having a problem getting my IF statement to work, well it is working but not as I would like. When the page loads both boxes are null and are therefore the the same and the 'else' statement is shown. Is there a way to say...IF button is NULL on the page load then ignore? //SUBMIT BUTTON echo "<br>"; echo "<br>"; echo "<input type='submit' name='select' value='Select Seats'>"; echo "</form>"; //IF TO SEE IF TWO SEATS ARE SAME if ($_POST['select']="") { echo "please choose seats"; } if ($_SESSION['extract']==$_SESSION['extract2']) { echo "You have choosen the same seat twice, please choose two different seats. <a href='confirm.php'> Go Back</a>"; } Thanks. =)

of course, so sorry. of course they are used. *dunce moment* I had them at values at one point when they where single drop down boxes but they got changed along the way when I need multiple selections. I used forms because I was using a tutorial as so how to create the drop down boxes. I didn't know I could live without them =) I will try that. the aim of the system is to be able to book two or more seats next to each other. I've tried many ways and I understand that using two boxes is messy but I don't have the knowledge to be able to try another way. anyway after you've chosen the two seats [seat] and [seat2] they get posted to the next page for confirmation, all is well there. what I wanted help on was how to get the price of both seats plus VAT in a session to be posted too. I've tried different variations and I can't seem to get anywhere. I hope this helps a little more, sorry if I'm being slow. I've been surviving on more coffee than sleep and I am shattered and finding it hard to see blatant errors. 0.o

That's weird, they work, I can call the seat variable and it comes, no problem. I didn't know about the form values, I will change them, But will it make any difference? I am not calling them in any other page. =)

This is the entire code =) <?php //connect include require("connect.php"); session_start(); #error_reporting(E_ERROR); //turn off error for session variables echo "your choosen ride is: " .$_SESSION ['result']; //extract data $extract =mysql_query("SELECT * FROM ride WHERE rideID ='3'"); $numrows = mysql_num_rows($extract); //start of form echo '<form method="post" name="f1" action="confirm.php">'; echo 'Please choose a seat: '; echo"<select multiple name='seat' size='2'>"; while( $row = mysql_fetch_assoc($extract)) { $rideID = $row ['rideID']; $name = $row ['name']; $seatNumber = $row ['seatNumber']; $time = $row ['time']; $price = $row ['price']; echo "<option name='seat'> $seatNumber </option>"; $_SESSION['extract']=$_POST['seat']; # $_SESSION['result']=$_POST['ABC']; //wasc alling blank variable } echo '</select><br>'; ?> <?php require('connect.php'); $extract2 =mysql_query("SELECT * FROM ride WHERE rideID ='3'"); $numrows = mysql_num_rows($extract2); //start of form echo '<form method="post" name="f2" action="confirm.php">'; echo 'Please choose a seat: ';echo"<select multiple name='seat2' size='2'>"; while( $row = mysql_fetch_assoc($extract2)) { $rideID = $row ['rideID']; $name = $row ['name']; $seatNumber = $row ['seatNumber']; $time = $row ['time']; $price = $row ['price']; echo "<option name='seat2'> $seatNumber </option>"; $_SESSION['extract2']=$_POST['seat2']; # $_SESSION['result']=$_POST['ABC']; //was calling blank variable } echo '</select><br>'; ?> <?php #$end =$_POST['endPrice']; $_SESSION['priceWvat']=$_POST['endPrice']; echo "<input type='submit' value='Submit'>"; echo "</form>"; //show time and price echo "The price of the ride is: £$price<br>The duration if of the ride is: $time minutes<br>" ; #$totalPrice=($_SESSION['extract']+$_SESSION['extract2']); #echo $totalPrice; //VAT function $seatPrice=($price*2); $vat=17.5; $priceXvat=0.300; function vat($vat, $priceXvat) { return sprintf("%01.2f", ($vat*$priceXvat/ 100)); } $vatprice = vat(17.5, 3.00); $total=($vatprice*2); $endPrice= ($total+$seatPrice); //Ftotal echo "<br>"; echo "The price including VAT is: £ ";echo $endPrice ; ?> Again messy code, what I am trying to do is add the VAT of two seats costing 3.00, The price is $price from the `ride` table. hope this is a little clearer =)

endPrice but when I use this, it comes up with Notice: Undefined index:

Hey, I have a VAT function that I need to carry across to the next confirmation page. I am using sessions, but for the life of me I can't get the variable right. I've been working all day and am pretty tired, there must be something I am missing. would love another pair of eyes on it =) //VAT function $seatPrice=($price*2); $vat=17.5; $priceXvat=0.300; function vat($vat, $priceXvat) { return sprintf("%01.2f", ($vat*$priceXvat/ 100)); } $vatprice = vat(17.5, 3.00); $total=($vatprice*2); $endPrice= ($total+$seatPrice); //Ftotal echo "<br>"; echo "The price including VAT is: £ ";echo $endPrice ; $_SESSION['priceWvat']=$_POST['what do i put here?']; ps: I understand that the code is a little scruffy and not the best it could be, any help here would be great too but if not that's cool =) Thanks.

woot it works. Thankyou, something simple, I've been staring at the problem for so long i couldn't see it. Thanks Denno

yeah it renders without moving tag but i did it anyway after it was pointed out... moving the html tag did nothing. it is called sessions because that is the problem. i can't seem to carry the seatNumber from the swing.php to the formOne.php, yet the sessions for the ride name from the index.php works fine. here's the index.php <?php session_start(); ?> <html> <h2>Choose a Ride</h2> <?php //connect include require("connect.php"); echo '<form method="post" name="f1" action="redirect.php">'; $query = "SELECT DISTINCT name FROM `ride` ORDER BY name DESC"; $result = mysql_query($query); echo"<select name='name'<option value=''>Select Ride</option>"; while( $row = mysql_fetch_array($result) ) { echo '<option>'.$row['name'].'</option>'; $_SESSION['result']=$_POST['name']; } echo '</select>'; mysql_free_result( $result ); echo "<input type='submit' value='Submit'>"; echo "</form>"; ?> </html> it has to be a session and not a simple post because it will be used on other forms too hope that is a little more clear =)

I have got the ride to go from index.php to formOne.php but now the seat won't go, not sure what i'm doing wrong. it's probably something simple but i can't see it, would appreciate another set of eyes. =) Swing.php <?php session_start(); ?> <html> <h2>Swinging Ship</h2> </html> <?php //connect include require("connect.php"); //extract data //extract data $extract =mysql_query("SELECT * FROM ride WHERE rideID ='1'"); $numrows = mysql_num_rows($extract); //start of form echo '<form method="post" name="f1" action="formOne.php">'; echo 'Please choose a seat: '; echo"<select name='seat'>"; while( $row = mysql_fetch_assoc($extract)) { $rideID = $row ['rideID']; $name = $row ['name']; $seatNumber = $row ['seatNumber']; $time = $row ['time']; $price = $row ['price']; echo "<option name='seat'> $seatNumber </option>"; $_SESSION['extract']=$_POST['seat']; } echo '</select><br>'; mysql_free_result( $extract ); //show time and price echo "The price of the ride is: £$price<br>The duration if of the ride is: $time minutes<br>" ; //submit button echo "<input type='submit' value='Submit'>"; echo "</form>"; ?> fromOne.php <?php session_start(); ?> <?php require ('connect.php'); echo 'the ride chosen is: ' .$_SESSION['result']; echo '<br>'; echo 'the seat chosen is: ' .$_SESSION['extract']; ?> am i calling my variable wrong? comma missing somewhere? Thanks =)

awesome will give it a try in the morning, will let you know how it works out

Hi again =) I have an index.php where the var $result comes from a drop down box when i press submit that var gets passed to a redirect page and used in an if query to direct the user to one of three pages. I want to carry that choice from the first drop down ($result) to the customer input page. here's the code =) index.php <?php //connect include require("connect.php"); #" echo '<form method="post" name="f1" action="redirect.php">'; $query = "SELECT DISTINCT name FROM `ride` ORDER BY name DESC"; $result = mysql_query($query); echo"<select name='name'<option value=''>Select Ride</option>"; while( $row = mysql_fetch_array($result) ) { echo '<option>'.$row['name'].'</option>'; } echo '</select>'; mysql_free_result( $result ); echo "<input type='submit' value='Submit'>"; echo "</form>"; ?> redirect.php <?php require ('connect.php'); $result=$_POST['name']; //redirect code if ($result == "Swinging Ship") { header('Location: Swing.php'); } elseif ($result == "Roller Coaster") { header('Location: Roller.php'); } elseif ($result == "Ice Blast") { header('Location: Ice.php'); } ?> Swing.php <?php //connect include require("connect.php"); $result=$_POST ['name']; //extract data $extract =mysql_query("SELECT * FROM ride WHERE rideID ='1'"); $numrows = mysql_num_rows($extract); //start of form echo '<form method="post" name="f1" action="formOne.php">'; echo 'Please choose a seat: '; echo"<select name='seat'>"; while( $row = mysql_fetch_assoc($extract)) { $rideID = $row ['rideID']; $name = $row ['name']; $seatNumber = $row ['seatNumber']; $time = $row ['time']; $price = $row ['price']; echo "<option name='ride'> $seatNumber </option>"; } echo '</select><br>'; mysql_free_result( $extract ); //show time and price echo "The price of the ride is: £$price<br>The duration if of the ride is: $time minutes<br>" ; //submit button echo "<input type='submit' value='Submit'>"; echo "</form>"; ?> formOne.php <?php require ('connect.php'); $extract=$_POST['seat']; $result=$_POST['name']; echo " <p> the seat choosen is : $extract <p> "; echo " <p> the ride choosen is : $result <p> "; ?> so as you can see the ride name has to go from index to formOne and further for inserting and deleting records etc..The question i guess i'm asking is how do i make results from drop down boxes or any query accessible to the entire site? Thanks in advance =)

can you please explain how i might do this, i can't see how. my first inclination is to say no that is not possible because of duplicate data in the seat table, but if you can see something i can't, can you explain it to me =) thanks =)

The problem is the seatNumber is duplicated so i can't do it that way. the swinging ship has 48 seats, the roller coaster has 20 and the iceblast has 24 so there are 24 rows of the seatNumber being the same. The unique field is the seatID but that is meaningless atm, I need the name and price and time of the ride which is in the table ride. ride has a the unique field of RrideID, I need to match RrideID and SrideID to pull the name, time and price. at the moment the code i have only pulls the seatNumber from seats, I need to pull the SrideID too, so i can match the two fields and pull the data from the table ride. unless i'm missing something silly I can't see how I do it with what i already have. =)

Hi I have an index.php with three drop down boxes on, each drop down uses an SQL statement to pull seatNumber from 'seats' each seat number has a UI and a forgein key field called SrideID. I have the buttons on the dorp down boxes going to dd-check.php, here the seat chosen is posted and a simple echo(just testing it works atm) for me to do any queries I also need the SrideID within the dropdown box, i tried adding it within the <option></option> but it only made the drop down duplicate. 1 1 2 2 3 3 ect..... what i would like is for the SrideID field to be included with in the dropdown box but hidden so i can post it to the dd-check.php and then show the time and price of that particular ride. here is the table and the code so far. Thanks for any help. CREATE TABLE `ride` ( `RrideID` tinyint(1) default NULL, `name` varchar(20) default NULL, `time` tinyint(1) default NULL, `price` varchar(4) default NULL ) INSERT INTO `ride` VALUES (1, 'Swinging Ship', 7, '2.50'); INSERT INTO `ride` VALUES (2, 'Roller Coaster', 5, '3.75'); INSERT INTO `ride` VALUES (3, 'Ice Blast', 4, '3.00'); CREATE TABLE `seats` ( `seatID` int( NOT NULL default '0', `SrideID` tinyint(1) default NULL, `seatNumber` int(2) default NULL, PRIMARY KEY (`seatID`) ) INSERT INTO `seats` VALUES (1, 1, 1); INSERT INTO `seats` VALUES (2, 1, 2); INSERT INTO `seats` VALUES (3, 1, 3); INSERT INTO `seats` VALUES (4, 1, 4); INSERT INTO `seats` VALUES (5, 1, 5); INSERT INTO `seats` VALUES (49, 2, 1); INSERT INTO `seats` VALUES (50, 2, 2); INSERT INTO `seats` VALUES (51, 2, 3); INSERT INTO `seats` VALUES (52, 2, 4); INSERT INTO `seats` VALUES (53, 2, 5); INSERT INTO `seats` VALUES (69, 3, 1); INSERT INTO `seats` VALUES (70, 3, 2); INSERT INTO `seats` VALUES (71, 3, 3); INSERT INTO `seats` VALUES (72, 3, 4); INSERT INTO `seats` VALUES (73, 3, 5); code for index.php <table width="200" border="1"> <tr> <h1>Swinging Ship</h1> <?php echo '<form method="post" name="f1" action="dd-check.php">'; $query_s = "SELECT * FROM `seats` WHERE SrideID='1' ORDER BY seatID"; $result = mysql_query($query_s); echo"<select name='seatNumber'><option value=''>Select Seat</option>"; while( $row = mysql_fetch_array($result) ) { echo '<option>'.$row['seatNumber'].'</option>'; } echo '</select>'; mysql_free_result( $result ); echo "<input type='submit' value='Submit'>"; echo "</form>"; ?> </tr> <tr> <h1>Roller Coaster</h1> <?php echo '<form method="post" name="f2" action="dd-check.php">'; $query_r = "SELECT * FROM `seats` WHERE SrideID='2' ORDER BY seatID"; $result = mysql_query($query_r); echo"<select name='seatNumber'><option value=''>Select Seat</option>"; while( $row = mysql_fetch_array($result) ) { echo '<option>'.$row['seatNumber'].'</option>'; } echo '</select>'; mysql_free_result( $result ); echo "<input type='submit' value='Submit'>"; echo "</form>"; ?> </tr> <tr> <h1>Ice Blast</h1> <?php echo '<form method="post" name="f3" action="dd-check.php">'; $query_i = "SELECT * FROM `seats` WHERE SrideID='3' ORDER BY seatID"; $result = mysql_query($query_i); echo"<select name='seatNumber'><option value=''>Select Seat</option>"; while( $row = mysql_fetch_array($result) ) { echo '<option>'.$row['seatNumber'].'</option>'; } echo '</select>'; mysql_free_result( $result ); echo "<input type='submit' value='Submit'>"; echo "</form>"; ?> </tr> </table> code for dd-check.php <?php $result=$_POST['seatNumber']; echo " <p> the seat choosen is : $result <p> "; //TEST PULL ALL QUERY $testPullAll = mysql_query("SELECT * FROM ride"); echo "<table border='1'> <tr> <th>Name</th> <th>Duration</th> <th>Price</th> </tr>"; while($row = mysql_fetch_array($testPullAll)) { echo "<tr>"; echo "<td>" . $row['name'] . "</td>"; echo "<td>" . $row['time'] . "</td>"; echo "<td>" . $row['price'] . "</td>"; echo "</tr>"; } echo "</table>"; ?> the end result will be a query in dd-check.php that says something like if [hidden SrideID = 1] echo 'the name, time and price of the ride' if [hidden SrideID =2 echo name, time and price if number 3 then echo the rest of the row. any help would be great, i've been using trial and error so far (since yesterday afternoon) with no success =( ps sorry for the long post, i wanted to try and explain everything the best i can. =)

Thankyou, It's messed up how strict and loose php can be, order is everything in this language. Once I get used to it, i'll be fine untill then i'll keep asking for help and learning Thanks again for a quick reply