RE: [PHP-DB] problems with a script. .

John R. Sims, Jr. Thu, 12 May 2005 22:12:45 -0700

 Martin; I have taken your advice and read both of the articles, but
unfortunately I have not been able to find what needs to be changed.  As I
mentioned, I am very new at this.


Could you possibly look at the script and point me in the right direction?


Keep the faith

John

<html>

<head>

<title>Wireless Neighborhoods</title>
</head>  <?php
// Set the page title and include the HTML header.
$page_title = 'Wireless Neighborhoods';
include_once ('include/header.html');

$db_connection = mysql_connect ('db.wireless-neighborhoods.org', 'scfn',
'scfn75') or die (mysql_error());
$db_select = mysql_select_db('scfn') or die (mysql_error());
// If the form was submitted, process it.

if (isset($submit)) {
        $query = "insert into case_note values ('0', '$id',NOW(),
NOW(),'$cmanager', '$location', '$purpose', '$present', '$subject',
'$note')";
        if (@mysql_query ($query)) {
                echo 'A Case Note has been added.';
        } else {
                echo 'The case note could not be added.' . mysql_error();
        }
}

?>
<font face="Verdana">
<body bgcolor="#F0FFFD">

<p><font size="5">CTC Database Contact Log</font></p><?php
//Prints something like: Monday 15th of January 2003 05:51:38 AM
echo date("l dS of F Y -- h:i:s A");//Prints something like: Monday the 15th
?>
<fieldset>
<br><legend>Enter your information in the form below:</legend>
<form action="<?=$PHP_SELF ?>" method="post">

Client Name:<select name="id"><option>Select The Client</option>

<?php
// Select one of the Students.
$query = "SELECT id, CONCAT(fname, ', ', lname) AS name FROM client ORDER BY
lname ASC";
$query_result = @mysql_query ($query);
while ($row = @mysql_fetch_array ($query_result)) {
        echo "<option value=\"$row[id]\">$row[name]</option>\n";
}
?>
</select> <br><br>

Contact Date: <input type="text" name="date_added"
size="20">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

Case Manager: <select name="cmanager"><option>Select a Case Manager</option>
        <option>Freddie Boykin</option>
        <option>Monica Harmon</option>
        <option>Ed Rivers</option>
        <option>Joseph McLeod</option>
    <option>Chasity Cheatham</option>
        <option>Rick Flanagan</option>
</select><br />
        <p>Purpose of Contact: <select size="1" name="purpose">
        <option>Select One</option>
        <option>Initial Contact</option>
        <option>Follow-up Contact</option>
        <option>Event</option>
        
</select>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        Location of Contact:&nbsp; <select size="1" name="location">
        <option>Select One</option>
        <option>Office Visit</option>
        <option>School Visit</option>
        <option>Home Visit</option>
        <option>Neighborhood Visit</option>
        
</select>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        </p>
        <p>Present at Contact:&nbsp;&nbsp; <select size="1" name="present">
        <option>Select One</option>
        <option>Client</option>
        <option>Parent</option>
        <option>Teachers</option>
        </select>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </p>
        <p>Subject:&nbsp; <input type="text" name="subject"
size="69">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        </p>
        <p>Notes:&nbsp;&nbsp;&nbsp; <textarea rows="4" name="note"
cols="66"></textarea></p>
        <p><input type="submit" name="submit" value="Submit" /></p>
</form>
<p>&nbsp;</p>
<?php
include_once ('include/footer.html');
?>
</body>

</html>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] problems with a script. .

Reply via email to