Do I Need Arrays?

[eddcaton]

Hello, 

 

I have done some work with PHP but just can't seem to find a solution to my problem.

 

I would like to be able to make a ticket reservation system for a local charity. So what i would like to end up with is a form with text fields that will take the users details etc etc... << Which i have working.

 

When the user comes to choosing how many tickets they want, it will give them 3 different tickets they can get and a text field of drop down menu next to them:

Adult 

Kid

Family (2 Adults + 2 Kids)

 

So for an example the user has selected 1 adult and 2 kids i want to be able to insert 3 separate rows to one MYSQL table with the correct information on them (e.g. 1 Adult row and 2 Kids rows).

 

Here is what is really confusing me as i don't know where i should start looking. If anyone has any ideas of where i can look.... or even if it can be done or not.....

 

Thanks 

 

Edd

[CroNiX]

You wouldn't want to store 3 separate rows. You'd store in a single row for the transaction, and that row would have a column for adult quantity and child quantity.

[gizmola]

I don't see the "reservation" aspect of this app.  

 

What problem(s) are you actually trying to solve?  You're down in the weeds and you have to start with the requirements of the app.

[eddcaton]

The reason behind the seperate rows is that, i would like to have a reference number for each ticket which will be converted into a QR code that can be scanned at the entrance upon arrival.

 

Edd

Edited July 1, 2015 by eddcaton

[scootstah]

There's several ways that you could structure your frontend to obtain the desired information. An easy one is to just put a quantity beside Adult and Kid.

[eddcaton]

I have created a working form that has quantity next to adult and kid. I just want to be able to input a row into mysql for each ticket

Edited July 1, 2015 by eddcaton

[scootstah]

Then you need a for loop. http://php.net/manual/en/control-structures.for.php

[EddNicks]

After reading many tutorials i really have no clue where to start on this... Could anyone lend me a hand??

[ginerjm]

What do you have to show us so far?

[EddNicks]

Here is my html form that posts to my submit.php

<table width="396" border="0">
<form action="submit.php" method="post">

   <tr>
    <td width="44"> </td>
    <td colspan="2"><center><h2>A Bit About You..</h2></center></td>
    <td width="58"> </td>
  </tr>
  <tr>
    <td> </td>
    <td width="107"><p>Forename: </p></td>
    <td width="159"><input type="text" name="firstname" required></td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td>Surname:</td>
    <td><input type="text" name="secondname" required></td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td colspan="2"><center><h2>How Do We Get In Touch?</h2></center></td>
    <td></td>
  </tr>
  <tr>
    <td> </td>
    <td>Email Address:</td>
    <td><input type="text" name="email" required></td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td colspan="2"><p><center><h2>When Are You Visiting?</h2></center></p></td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td colspan="2"> <center>   <select name="dayattending">
    <option value="Saturday 16th">Saturday 16th</option>
    <option value="Sunday 17th">Sunday 17th</option>
    </select></center></td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td colspan="2"><center><h2>Who's Coming?</h2></center></td>
    <td> </td>
  </tr>
    <tr>
    <td> </td>
    <td colspan="2"><center>Early Bird Discount
    <br />
    Adult Ticket £2.50
    <br />
    Childrens Ticket (age 3-15) £0.50
     <br />
     Family Pass : £6.00
      <br /><br />
    </center></td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td><center>Adult Ticket</center></td>
    <td><center>Childrens Ticket (age 3-15)</center></td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td><center><input type="text" size = "2" name="adults" value="0"></center></td>
    <td><center><input type="text" size = "2" name="kids" value="0"></center></td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td colspan="2"><center>Family Ticket (2 Adults & 2 Children)</center></td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td colspan="2"><center><input type="text" size = "2" name="family" value="0"></center></td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td colspan="2"><center><input type="submit"></center></td>
    <td> </td>
  </tr>
</table>

I am finding it really hard to get my head around the arrays as i have never used them before. If someone can give me an example i can try to build.

 

I want to input each ticket as a single post in a MYSQL table so they can have their own booking number, which i will convert into a barcode to the public can be scanner in to the venue...

[scootstah]

You don't even need arrays, you just need to do some action * number of tickets. That is what a for loop is used for.

$numAdults = $_POST['adults'];
$numKids = $_POST['kids'];

if ($numAdults != 0) {
    for ($i = 0; $i < $numAdults; $i++) {
        // create an adult ticket
    }    
}

if ($numKids != 0) {
    for ($i = 0; $i < $numKids; $i++) {
        // create a kid ticket
    }       
}

Rather than running an INSERT query on each loop iteration, though, I'd recommend that you compile a list of values to insert and do it all at once with a batch insert. Manual here. Edited July 15, 2015 by scootstah

[ginerjm]

1 - you are missing a closing form tag here.

2 - you want to post each single ticket with a separate booking number. That means a customer with 3 tickets has 3 booking numbers? Really? How will you tie the tickets to the purchaser?

[EddNicks]

Yes thats correct..

I will look at tying all the tickets together with a transaction id number or the payment email address that will be the same for all the tickets bought in that transaction. Then when a customer is logged into the online system they can see all of their tickets....

[EddNicks]

So would the adults submit work something like this???

Obviously i will have to but a few lines in to connect to the DB but..

I have added a random number generator for now to make the transaction Number...

$randomgen = mt_rand() . "\n";
echo mt_rand(10);
$transaction_no = "$randomgen";
$numAdults = $_POST['adults'];
$numKids = $_POST['kids'];

if ($numAdults != 0) {
    for ($i = 0; $i < $numAdults; $i++) {
        // create an adult ticket
mysqli_query($connect,"INSERT INTO tickets (ticket_type, transaction_no)
VALUES ('$i','$transaction_no')");
    }    
}

Edited July 15, 2015 by EddNicks

[EddNicks]

 

So would the adults submit work something like this???

Obviously i will have to but a few lines in to connect to the DB but..

I have added a random number generator for now to make the transaction Number...

$randomgen = mt_rand() . "\n";
echo mt_rand(10);
$transaction_no = "$randomgen";
$numAdults = $_POST['adults'];
$numKids = $_POST['kids'];

if ($numAdults != 0) {
    for ($i = 0; $i < $numAdults; $i++) {
        // create an adult ticket
mysqli_query($connect,"INSERT INTO tickets (ticket_type, transaction_no)
VALUES ('$i','$transaction_no')");
    }    
}

[scootstah]

mt_rand() is going to eventually produce duplicates. That is not a good way to do it. You'd probably want a "transactions" database table with the transaction number being the auto-incremented primary key. Of course, then the transaction numbers would be sequential, so if that is a problem you'll have to use something else.

[EddNicks]

Thanks scootstah .. Would the rest of the coding be correct??