Posted by Caonex Tue 13th Mar 2007 16:04 - Syntax is PHP - 14 viewsRun this post in the PHP shell
Download | New Post | Modify | Hide line numbers
PHP parser reported no syntax errors in this post!
Description:
Fill.php is called to display the table from database....it

  2. $link = mysql_connect('mysql283.secureserver.net', 'caonex', 'caonex2007')
  3.    or die('Could not connect: ' . mysql_error());
  4. //echo 'Connected successfully';
  5. mysql_select_db('caonex') or die('Could not select database');
  6. $selected = $_GET['Type'];
  7. // Performing SQL query
  8. if ($_GET['Type'] != ""){
  9. $query = "SELECT `Paid` ,`Id` , `FirstName` , `LastName` , `Guest` , `Parish` , `Type` , `ReceptionAdults` , `ReceptionChildren` , `LucheonTotal` , `LuncheonTotalChildren` , `TotalDue` ,  `Address` , `City` , `State` , `Zip` , `Phone`
  10. FROM Conference Where `Type`='".$selected."' ORDER BY Id";
  11. }
  12. else {
  13. $query = 'SELECT `Paid` ,`Id` , `FirstName` , `LastName` , `Guest` , `Parish` , `Type` , `ReceptionAdults` , `ReceptionChildren` , `LucheonTotal` , `LuncheonTotalChildren` , `TotalDue` ,  `Address` , `City` , `State` , `Zip` , `Phone`
  14. FROM Conference ORDER BY Id ';
  15. }
  16. $result = mysql_query($query) or die('Query failed: ' . mysql_error());
  17.  
  18.  
  19.  
  20. echo "\n";
  21. echo "
    22. \n";
  22. $color = 0;
  23. while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
  24.     if($color == 0){
  25.            echo "\t
    26. \n";
  26.            $color = 1;
  27.        }
  28.        else{
  29.            $color = 0;
  30.            echo "\t
    31. \n";
  31.        }
  32.            echo "\t\t
    33. \n";
  33.        echo "\t\t
    34. \n";
  34.        foreach ($line as $col_value) {
  35.         echo "\t\t
    36. \n";
  36.        }
  37.  
  38.        echo "\t
    39. \n";
  39. }
  40. echo "
    41. Paid # First Name Last Name Guest Parish Type PR Adults PR Children Luncheon Adults Luncheon Children Total Phone City State Zip Phone
    \"javascript: req('Delete.php?Id=".$line['Id']."','Delete')\"  name=\"Delete\" type=\"button\" value=\"Delete\"/> \"javascript: req('Paid2.php?Id=".$line['Id']."','Paid')\"  name=\"Paid\" type=\"button\" value=\"Paid\"/> $col_value
    \n"    ;
  41.  
  42.  
  43. // Free resultset
  44. mysql_free_result($result);
  45.  
  46. // Closing connection
  47. mysql_close($link);
  48.  
  49.  
  50. ?>

PermaLink to this entry https://pastebin.co.uk/11822
Posted by Caonex Tue 13th Mar 2007 16:04 - Syntax is PHP - 14 viewsRun this post in the PHP shell
Download | New Post | Modify | Hide line numbers

 

Comments: 0