Tutorials
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Codewalkers ForumsOtherTutorials

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Codewalkers Forums Sponsor:
You eat, breathe and sleep innovation. Build your mobile intelligence with BlackBerry® experts this July. Register Today!
  #1  
Old October 8th, 2004, 10:08 PM
Anonymous Anonymous is offline
Registered User
Codewalkers God 35th Plane (22000 - 22499 posts)
 
Join Date: Apr 2007
Posts: 22,309 Anonymous User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 24
PHP arrays tutorial

okay, i was using the arrays tutorial to help me insert some data from a form into my database.

Firstly with this section of the tutorial

php Code:
Original - php Code
  1. <?php
  2. $books = array(0=>array('name'='A Book','price'=>9.99),1=>array('name'='Another Book','price'=>17.99));
  3. ?>


i had to change it to

php Code:
Original - php Code
  1. <?php
  2. $books = array(0=>array('name'=>'A Book','price'=>9.99),1=>array('name'=>'Another Book','price'=>17.99));
  3. ?>


or else i got syntax errors

Anyway, back to my code, I have this for my form

php Code:
Original - php Code
  1. if($_GET['action'] == "add"){
  2.  
  3.     echo "  <p class="h1">Add Mailing List Recipients</p>
  4.            
  5.             <form method="post" action="mailing_list.php?add=processing">
  6.             <table>
  7.                 <tr>
  8.                     <td>Name 1: </td>
  9.                         <td><input type="text" name="mailing_name_1" size="40"></td>
  10.                             <td>Email 1: </td>
  11.                                 <td><input type="text" name="mailing_email_1" size="40"></td>
  12.                 </tr>
  13.                 <tr>
  14.                     <td><br></td>
  15.                 </tr>
  16.                 <tr>
  17.                     <td>Name 2: </td>
  18.                         <td><input type="text" name="mailing_name_2" size="40"></td>
  19.                             <td>Email 2: </td>
  20.                                 <td><input type="text" name="mailing_email_2" size="40"></td>
  21.                 </tr>
  22.                 <tr>
  23.                     <td><br></td>
  24.                 </tr>
  25.                 <tr>
  26.                     <td>Name 3: </td>
  27.                         <td><input type="text" name="mailing_name_3" size="40"></td>
  28.                             <td>Email 3: </td>
  29.                                 <td><input type="text" name="mailing_email_3" size="40"></td>
  30.                 </tr>
  31.                 <tr>
  32.                     <td><br></td>
  33.                 </tr>
  34.                 <tr>
  35.                     <td>Name 4: </td>
  36.                         <td><input type="text" name="mailing_name_4" size="40"></td>
  37.                             <td>Email 4: </td>
  38.                                 <td><input type="text" name="mailing_email_4" size="40"></td>
  39.                 </tr>
  40.                 <tr>
  41.                     <td><br></td>
  42.                 </tr>
  43.                 <tr>
  44.                     <td>Name 5: </td>
  45.                         <td><input type="text" name="mailing_name_5" size="40"></td>
  46.                             <td>Email 5: </td>
  47.                                 <td><input type="text" name="mailing_email_5" size="40"></td>
  48.                 </tr>
  49.                 <tr>
  50.                     <td><br></td>
  51.                 </tr>
  52.                 <tr>
  53.                     <td>Name 6: </td>
  54.                         <td><input type="text" name="mailing_name_6" size="40"></td>
  55.                             <td>Email 6: </td>
  56.                                 <td><input type="text" name="mailing_email_6" size="40"></td>
  57.                 </tr>
  58.                 <tr>
  59.                     <td><br></td>
  60.                 </tr>
  61.                 <tr>
  62.                     <td>Name 7: </td>
  63.                         <td><input type="text" name="mailing_name_7" size="40"></td>
  64.                             <td>Email 7: </td>
  65.                                 <td><input type="text" name="mailing_email_7" size="40"></td>
  66.                 </tr>
  67.                 <tr>
  68.                     <td><br></td>
  69.                 </tr>
  70.                 <tr>
  71.                     <td>Name 8: </td>
  72.                         <td><input type="text" name="mailing_name_8" size="40"></td>
  73.                             <td>Email 8: </td>
  74.                                 <td><input type="text" name="mailing_email_8" size="40"></td>
  75.                 </tr>
  76.                 <tr>
  77.                     <td><br></td>
  78.                 </tr>
  79.                 <tr>
  80.                     <td>Name 9: </td>
  81.                         <td><input type="text" name="mailing_name_9" size="40"></td>
  82.                             <td>Email 9: </td>
  83.                                 <td><input type="text" name="mailing_email_9" size="40"></td>
  84.                 </tr>
  85.                 <tr>
  86.                     <td><br></td>
  87.                 </tr>
  88.                 <tr>
  89.                     <td>Name 10: </td>
  90.                         <td><input type="text" name="mailing_name_10" size="40"></td>
  91.                             <td>Email 10: </td>
  92.                                 <td><input type="text" name="mailing_email_10" size="40"></td>
  93.                 </tr>
  94.                 <tr>
  95.                     <td><br></td>
  96.                 </tr>
  97.                 <tr>
  98.                     <td colspan="2" align="center">
  99.                         <input type="reset" value="Reset">&nbsp;&nbsp;<input type="submit" value="Submit">
  100.                     </td>
  101.                 </tr>
  102.                
  103.                
  104.             </table>
  105.            
  106.             </form>
  107. ";
  108.  
  109. }
  110.     


And this for my processing page

php Code:
Original - php Code
  1. if($_GET['add'] == "processing"){
  2.  
  3. $mailing_name_1 = $_POST['mailing_name_1'];     $mailing_email_1 = $_POST['mailing_email_1'];
  4. $mailing_name_2 = $_POST['mailing_name_2'];     $mailing_email_2 = $_POST['mailing_email_2'];
  5. $mailing_name_3 = $_POST['mailing_name_3'];     $mailing_email_3 = $_POST['mailing_email_3'];
  6. $mailing_name_4 = $_POST['mailing_name_4'];     $mailing_email_4 = $_POST['mailing_email_4'];
  7. $mailing_name_5 = $_POST['mailing_name_5'];     $mailing_email_5 = $_POST['mailing_email_5'];
  8. $mailing_name_6 = $_POST['mailing_name_6'];     $mailing_email_6 = $_POST['mailing_email_6'];
  9. $mailing_name_7 = $_POST['mailing_name_7'];     $mailing_email_7 = $_POST['mailing_email_7'];
  10. $mailing_name_8 = $_POST['mailing_name_8'];     $mailing_email_8 = $_POST['mailing_email_8'];
  11. $mailing_name_9 = $_POST['mailing_name_9'];     $mailing_email_9 = $_POST['mailing_email_9'];
  12. $mailing_name_10 = $_POST['mailing_name_10'];     $mailing_email_10 = $_POST['mailing_email_10'];
  13.  
  14. $mailing_list = array(
  15.  0 => array('mailing_name_1' => '$mailing_name_1','mailing_email_1' => '$mailing_email_1'),
  16.  1 => array('mailing_name_2' => '$mailing_name_2','mailing_email_2' => '$mailing_email_2'),
  17.  2 => array('mailing_name_3' => '$mailing_name_3','mailing_email_3' => '$mailing_email_3'),
  18.  3 => array('mailing_name_4' => '$mailing_name_4','mailing_email_4' => '$mailing_email_4'),
  19.  4 => array('mailing_name_5' => '$mailing_name_5','mailing_email_5' => '$mailing_email_1'),
  20.  5 => array('mailing_name_6' => '$mailing_name_6','mailing_email_6' => '$mailing_email_6'),
  21.  6 => array('mailing_name_7' => '$mailing_name_7','mailing_email_7' => '$mailing_email_7'),
  22.  7 => array('mailing_name_8' => '$mailing_name_8','mailing_email_8' => '$mailing_email_8'),
  23.  8 => array('mailing_name_9' => '$mailing_name_9','mailing_email_9' => '$mailing_email_9'),
  24.  9 => array('mailing_name_10' => '$mailing_name_10','mailing_email_10' => '$mailing_email_10'));
  25.  
  26.  
  27. foreach($mailing_list as $recipient){
  28.  
  29.     $mailing_name = $recipient['mailing_name'];
  30.     $mailing_email = $recipient['mailing_email'];
  31.    
  32.  
  33.     if ((!empty($mailing_name)) && (!empty($mailing_email))) {
  34.        
  35.         $query = "INSERT INTO mailing_list (mailing_name, mailing_email) VALUES ('$mailing_name', '$mailing_email')";
  36.         $result = mysql_query($query) or die("<p class="h1">Error!</p>" . mysql_error() . "Please Contact Sanfly Web Design");
  37.        
  38.         if (!$result) {
  39.             echo "<p class="h1">Error!</p>Unable to enter names into mailing list database";
  40.         }
  41.         else {
  42.             echo "  <p class="h1">Add Mailing List Recipients</p>
  43.                     Recipeients successfully added to mailing list.<br>
  44.                     <br>
  45.                     <a href="mailing_list.php?action=add">Add More Recipients</a><br>
  46.                     <a href="mailing_list.php?action=edit">Edit Subscribers</a><br>
  47.                     <a href="mailing_list.php?action=email">Send Email to Mailing List</a><br>";
  48.         }
  49.  
  50.     }
  51.     else {
  52.        
  53.         if ((empty($mailing_name)) && (empty($mailing_email))) {
  54.             echo " no more recipients<br><br>";
  55.             exit();
  56.         }
  57.    
  58.         else {
  59.         echo "  <p class="h1">Error!</p>
  60.                 You have not entered the necessary information:<br>
  61.                 <br>";
  62.                    
  63.                 if ((empty($mailing_name))){
  64.                     echo "You need to enter a name for entry number $i<br><br>";
  65.                 }
  66.                 if ((empty($mailing_email))){
  67.                     echo "You need to enter an email address for entry number $i<br><br>";
  68.                 }
  69.         echo "  <a href="#" onclick="history.back()">« Go Back</a><br><br>";
  70.     }
  71.        
  72.     }
  73. }
  74. }


But I keep getting "no more recipients" with no information entered into the database, so either the variables are not getting passed from the form to the processing page, or the array and foreach code etc is not recognising the variables and they are being lost at some point

can anyone help?

Reply With Quote