1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

Script problem/ i don't understand

Discussion in 'PHP' started by Jaslynne, Feb 28, 2010.

  1. Jaslynne

    Jaslynne New Member

    Hello All, I've been taking a PHP class for the past 7 weeks and are getting a little hard. This is the first time I have ever messed with PHP and i just don't seem to get it. I have the following assignment:

    -Name a script solution09.php
    -Wtihin the script construct a SELECT statement which will query the "expenses" table for all the purchases made.
    -Process the resulting recordset with a while loop which will create a separate line for each expense.
    -On each line display the category, date, and amount of expenses.
    -Create an HTML form , provide the visitor with an input box so they may use it to enter an expenses ategory (THIS IS DONE)
    -Modify the schript so that it retrieves the value entered by the visitor
    -Modify the SELECT statement created within the script so thatit includes a WHERE clause which will test to make sure that the category column is equal to the valueentered by the visitor.

    Now, I think I got the script pretty much done EXCEPT for hte last two steps. I don't understand what im supposed to do or where Im supporsed to start. Any help is greatly appreciated :cryin:
     
  2. Jaslynne

    Jaslynne New Member

    sorry i forgot to post my script:
    Code:
    <?php
    $connection=mysql_connect ("localhost", "spike", "9sj7En4");
    if (!$connection)
    {
    die  ('Could not Connect: '. mysql_error());
    }
    mysql_select_db ("My_DB", $connection) or die (mysql_error());
    $result = mysql_query ("SELECT * FROM Expenses") or die (mysql_error());
    echo "<table  border='2'>
    <tr>
    <th>Category</th>
    <th>Date</th>
    <th>Dollar Amount</th>
    </tr>";
    while ($row= mysql_fetch_array ($result))
    {
    echo  "<tr>";
    echo  "<td>" .$row ['Category'] ."</td>" ;
    echo  "<td>" .$row ['Date']  ."  </td>";
    echo  "<td>" .$row ['Dollar Amount'] . "  </td>";
    echo  "</tr>";
    }
    echo "</table>";
    mysql_close ($connection);
    ?>
     
    Last edited by a moderator: Feb 28, 2010
  3. angelg107

    angelg107 New Member

    PHP:
    <?php
    $connection
    =mysql_connect ("localhost""spike""9sj7En4");
    if (!
    $connection)
    {
    die  (
    'Could not Connect: 'mysql_error());
    }
    mysql_select_db ("My_DB"$connection) or die (mysql_error());
    if(!(isset(
    $_POST['submit_button']))){
    // they did not click the button
    $result mysql_query ("SELECT * FROM Expenses") or die (mysql_error());
    echo 
    "<table  border='2'>
    <tr>
    <th>Category</th>
    <th>Date</th>
    <th>Dollar Amount</th>
    </tr>"
    ;
    while (
    $rowmysql_fetch_array ($result))
    {
    echo  
    "<tr>";
    echo  
    "<td>" .$row ['Category'] ."</td>" ;
    echo  
    "<td>" .$row ['Date']  ."  </td>";
    echo  
    "<td>" .$row ['Dollar Amount'] . "  </td>";
    echo  
    "</tr>";
    }
    echo 
    "</table>";
    }else{
    // the form was submitted
    // retrieve all the values from the form here
    }
    mysql_close ($connection);
    ?> 
    Now, you only have to make sure the button name in the form
    is 'submit_button' for example :

    HTML:
    <form action="" method="post">
    ......
    <input type="submit" value="GO" name="submit_button" />
    </form>
    
    Considering your new to PHP, I want to let you know using single-quotes instead
    of double-quotes speeds up your script.

    Regards.
     

Share This Page