School Map:  Home / Enroll $ Student Records; Class  
$ News @ LIVE Tech Radio * Support/FAQ | Store | FORUMS

Class / Forums / mysql101 Refresh the current page Week #4 ADVANCED To-Do Assignment
 

 (#27 2003-08-29 14:03:57) Post Reply

TDavid
php mySQL Perl C/C++
Principal


Enrolled: Mar 2000
Posts: 193
AP: 1

 Your Week #4 ADVANCED TO-DO assignment should be posted here in this thread only. If you have specific questions about the week 4 course text then please also post them in this thread so that other students can learn from the information and we can collectively build a knowledge base.

Here is the details on what you need to do in this assignment:

Do the basic assignment and add more features to the Display form. Allow sorting by entry date, Ascending Or Descending alphabetical order, add controls to set the default radio button states, and if You have added additional Tables to Your database create the means to add, edit, delete and display that information. Consider usefulness and ease of use. Consider adding rating or profit fields which can be displayed visually as bar charts, these can be as simple as a line of *** or can be stretchable images controlled by HTML through PHP. If You have advanced graphical skills these can even be complex 3D images.
 

 (#59 2003-10-21 19:42:05) Post Reply

lizabit
Need To Set


Enrolled: Jul 2003
Posts: 17
AP: 1

 Hi Logspirit,
Well its not brilliant and it needs work but here it is.

(I have to post it in 2 bits as its too big for the forum)
Part 1
**********
<?PHP
// set variables
$status = '<font size=1> </font>';
$status_err = ' ';
/*****************
// functions
*****************/
// checks radio buttons so Filter form shows query
// after page returns from server
function check_radio($field, $val, $default){
if($_POST[$field] == $val){
echo ' checked ';
}elseif(empty($_POST[$field]) && $default == $val){
echo ' checked ';
}
}
function sel($row_id,$frm) {
if($frm == 'w') { //see which form
if($row_id ==$_POST['website_list']) { //see if id matches posted value
echo 'selected';
}
}else if($frm =='s') {
if($row_id ==$_POST['sponsor_list']) { //see which form
echo 'selected'; //see if id matches posted value
}
}
}
function report_status($status_err) {
switch($status_err) {
case 'qry_ins' :
echo '<font color=red>Error Inserting into Database';
break;
case 'qry_ck' :
echo '<font color=red>Error Checking for Relationship';
break;
case 'rel_ex' :
echo '<font color=red>This Relationship Already Exists';
break;
case 'rel_add' :
echo '<font color=blue>Added Relationship to Database';
break;
case 'empty_w' :
echo '<font color=red>No website Selected';
break;
case '_empty_s' :
echo '<font color=red>No sponsor Selected';
break;
case 'empty_w_empty_s' :
echo '<font color=red>No website or sponsor Selected';
break;
case 'update':
echo '<font color=blue>Record updated';
break;
case 'not_update' :
echo '<font color=red>Could not update record.';
break;
case 'rel_delete' :
echo '<font color=blue>Relationship deleted.';
break;
case 'not_delete' :
echo '<font color=red>Could not delete relationship.';
break;
case 'add_record' :
echo '<font color=blue>Record added';
break;
case 'not_added' :
echo '<font color=red>Could not add record';
break;
case 'oops' :
echo '<font color=red>Please enter a name';
break;
case 'delete_record' :
echo '<font color=Blue>Record deleted';
break;
case 'delete_record_not' :
echo '<font color=red>Could not delete record';
break;
} //end switch
if(isset($status_err)) {
echo '<br><br></font>';
}
}
/***********************************
//end functions
***********************************/

// Note: @ suppresses standard error reporting
// Connect to Your MySQL server

$db = @ mysql_connect(localhost,xxx, xxx)
or die(Could not connect:. mysql_error());
// Connect to database:
@ mysql_select_db(ssMySQLclass,$db)
or die(Could not Connect to database:. mysql_error());

// Clean incoming data:
if(get_magic_quotes_gpc()){
foreach($_POST as $key => $value){
// Note: Changing the values in the $_POST array:
$_POST[$key] = mysql_escape_string(strip_tags(trim(stripslashes($value))));
}
}
$display_webs = SELECT DISTINCT w_name AS name, w_id AS id
FROM `Websites`;
$display_spon = SELECT DISTINCT s_name AS name, s_id AS id
FROM `Sponsors`;

// check for submission from filter form,
// set up query according to condition:
if(isset($_POST['filter'])){
// if Websites:
if($_POST['web_spon'] == 'web'){
// if all relationships:
if($_POST['relations'] == 'all'){
$query_list = SELECT DISTINCT w_name AS name, w_id AS id
FROM `Websites`;
// $display_spon = $query_list;
// add status conditional:
if($_POST['status'] == 'Pending'){
// Note use of the .= to add to the $query_list string:
$query_list .= WHERE w_status = 'Pending';
}else if($_POST['status'] == 'Active'){
$query_list .= WHERE w_status = 'Active';
}else if($_POST['status'] == 'Inactive'){
$query_list .= WHERE w_status = 'Inactive';
}else if($_POST['status'] == 'Defunct'){
$query_list .= WHERE w_status = 'Defunct';
}else if($_POST['status'] == 'all'){
$query_list .= ;
}
}else if($_POST['relations'] == 'yes'){
$query_list = SELECT DISTINCT w_name AS name, w_id AS id
FROM `Websites`, `Website_Sponsor`
WHERE w_id = ws_w_id;
if($_POST['status'] == 'Pending'){
$query_list .= AND w_status = 'Pending';
}else if($_POST['status'] == 'Active'){
$query_list .= AND w_status = 'Active';
}else if($_POST['status'] == 'Inactive'){
$query_list .= AND w_status = 'Inactive';
}else if($_POST['status'] == 'Defunct'){
$query_list .= AND w_status = 'Defunct';
}else if($_POST['status'] == 'all'){
$query_list .= ;
}
}else if($_POST['relations'] == 'no'){
$query_list = SELECT DISTINCT w_name AS name, w_id AS id
FROM `Websites`
LEFT JOIN `Website_Sponsor`
ON w_id = ws_w_id
WHERE ws_w_id IS NULL;
if($_POST['status'] == 'Pending'){
$query_list .= AND w_status = 'Pending';
}else if($_POST['status'] == 'Active'){
$query_list .= AND w_status = 'Active';
}else if($_POST['status'] == 'Inactive'){
$query_list .= AND w_status = 'Inactive';
}else if($_POST['status'] == 'Defunct'){
$query_list .= AND w_status = 'Defunct';
}else if($_POST['status'] == 'all'){
$query_list .= ;
}
}
}else if($_POST['web_spon'] == 'spon'){
// if Sponsors
if($_POST['relations'] == 'all'){
$query_list = SELECT DISTINCT s_name AS name, s_id AS id
FROM `Sponsors`;
if($_POST['status'] == 'Pending'){
$query_list .= WHERE s_status = 'Pending';
}else if($_POST['status'] == 'Active'){
$query_list .= WHERE s_status = 'Active';
}else if($_POST['status'] == 'Inactive'){
$query_list .= WHERE s_status = 'Inactive';
}else if($_POST['status'] == 'Defunct'){
$query_list .= WHERE s_status = 'Defunct';
}else if($_POST['status'] == 'all'){
$query_list .= ;

}
}else if($_POST['relations'] == 'yes'){
$query_list = SELECT DISTINCT s_name AS name, s_id AS id
FROM `Sponsors`, `Website_Sponsor`
WHERE s_id = ws_s_id;
if($_POST['status'] == 'Pending'){
$query_list .= AND s_status = 'Pending';
}else if($_POST['status'] == 'Active'){
$query_list .= AND s_status = 'Active';
}else if($_POST['status'] == 'Inactive'){
$query_list .= AND s_status = 'Inactive';
}else if($_POST['status'] == 'Defunct'){
$query_list .= AND s_status = 'Defunct';
}else if($_POST['status'] == 'all'){
$query_list .= ;
}
}else if($_POST['relations'] == 'no'){
$query_list = SELECT DISTINCT s_name AS name, s_id AS id
FROM `Sponsors`
LEFT JOIN `Website_Sponsor`
ON s_id = ws_s_id
WHERE ws_s_id IS NULL;
if($_POST['status'] == 'Pending'){
$query_list .= AND s_status = 'Pending';
}else if($_POST['status'] == 'Active'){
$query_list .= AND s_status = 'Active';
}else if($_POST['status'] == 'Inactive'){
$query_list .= AND s_status = 'Inactive';
}else if($_POST['status'] == 'Defunct'){
$query_list .= AND s_status = 'Defunct';
}else if($_POST['status'] == 'all'){
$query_list .= ;
}
}//END else if($_POST['relations'] == 'no'){
}//End else if($_POST['web_spon'] == 'spon'){
$status = '<strong><u>Results from Filter</strong></u><br>';
$display_webs = SELECT DISTINCT w_name AS name, w_id AS id
FROM `Websites`;
$display_spon = SELECT DISTINCT s_name AS name, s_id AS id
FROM `Sponsors`;
}//End if(isset($_POST['filter']))
/***************************
//web_sponsor relationships
***************************/
//Determine if form has been submitted:
if(isset($_POST['Submit_WS'])) {
//check if values exist from both lists:
if(!empty($_POST['website_list']) && !empty($_POST['sponsor_list'])) {
//write query, determine if duplicating relationship:
$query_check = SELECT * FROM website_sponsor
WHERE ws_w_id = '.$_POST['website_list'].'
AND ws_s_id = '.$_POST['sponsor_list'].'
;;
//Do duplicate query:
if($add_rel_result = @mysql_query($query_check, $db)) {
//if number of rows is one or more...
//Note that mysql_num_rows is used for SELECT queries
if(mysql_num_rows($add_rel_result) >=1) {
//This relationship already exists in the database:
$status_err = 'rel_ex';
} else { //OK to insert data...
//write insert query
$query_insert = INSERT INTO `website_sponsor`
Set ws_w_id = '.$_POST['website_list'].',
ws_s_id = '.$_POST['sponsor_list'].'
;
// Do query, check if one row affected:
//Note that mysql_affected rows is used for INSERT queries
if($add_rel_result = @mysql_query($query_insert,$db)
&& @mysql_affected_rows() == 1) {
//Report Success:
$status_err = 'rel_add';
} else {
//error Inserting result into database
$status_err = 'qry_ins';
} //end Do insert query/else error
} // end else OK to insert data
} else {//Duplicate query
// Error in getting result from query
$status_err = 'qry_ck';
} //end else duplicate query
} else { //End check for both list values
// One or both lists NOT selected:
if(empty($_POST['website_list'])) {
$status_err = 'empty_w';
}
if(empty($_POST['sponsor_list'])) {
// Note use of the .= to add string to $status variable
$status_err .='_empty_s';
}
} //end else check for both list values
} // end if form submitted

/*********************************
** Delete website_sponsor Stuff
**********************************/
if(isset($_GET['del_w']) && isset($_GET['del_s'])){
$query_delete = DELETE FROM website_sponsor
WHERE ws_w_id = '.$_GET['del_w'].'
AND ws_s_id = '.$_GET['del_s'].'
;
// Send query, check affected rows:
if(@mysql_query($query_delete,$db) && @mysql_affected_rows() == 1){
// query sent, set display status:
$status_err='rel_delete';
} else { // Problem sending query, set display status:
$status_err = 'not_delete';
}//End if(@ mysql_query
} //end isset

/***********************************
** Delete Website & sponsor
**********************************/
if(isset($_POST['sub_delete_web'])){
$query_delete_web = DELETE FROM Websites
WHERE w_id = '.$_POST['website_list'].'
;

// Send query, check affected rows:
if(@mysql_query($query_delete_web,$db) && @mysql_affected_rows() == 1){
// query sent, set display status:
$status_err = 'delete_record';
} else { // Problem sending query, set display status:
$status_err = 'delete_record_not';
}
$query_optimize_web = OPTIMIZE TABLE `Websites`;
@mysql_query($query_optimize_web,$db);

}
if(isset($_POST['sub_delete_spon'])){
$query_delete_spon = DELETE FROM Sponsors
WHERE s_id = '.$_POST['sponsor_list'].'
;

// Send query, check affected rows:
if(@mysql_query($query_delete_spon,$db) && @mysql_affected_rows() == 1){
// query sent, set display status:
$status_err = 'delete_record';
} else { // Problem sending query, set display status:
$status_err = 'delete_record_not';
}
$query_optimize_web = OPTIMIZE TABLE `Sponsors`;
@mysql_query($query_optimize_web,$db);
}
if(isset($_POST['display_add_websites'])) {
//only allow post if w_name is not blank
if ($_POST['w_name']){
//Write Insert Query to a Variable:
$query_insert_website = INSERT INTO `Websites`
SET w_name = '.$_POST['w_name'].',
w_url = '.$_POST['w_url'].',
w_desc = '.$_POST['w_desc'].',
w_status = '.$_POST['w_status'].'
;
//Do websites Table Data Insert, check if Row added:
if((@ mysql_query($query_insert_website, $db)) && @ mysql_affected_rows() == 1) {
$status_err = 'add_record';
}else {
$status_err = 'not_added';
}
}else {
$status_err = 'oops';
}
}
if(isset($_POST['display_add_spon'])) {
if($_POST['s_name']){
$query_insert_spon = INSERT INTO `Sponsors`
SET s_name = '.$_POST['s_name'].',
s_url = '.$_POST['s_url'].',
s_staturl = '.$_POST['s_staturl'].',
s_email = '.$_POST['s_email'].',
s_uname = '.$_POST['s_uname'].',
s_pass = '.$_POST['s_pass'].',
s_status = '.$_POST['s_status'].',
s_date = '.$_POST['s_date'].'
;
if((@ mysql_query($query_insert_spon, $db)) && @ mysql_affected_rows() == 1) {
$status_err = 'add_record';
}else {
$status_err = 'not_added';
}
}else {
$status_err = 'oops';
}
}
?>
/**********
end part 1*/
 

 (#60 2003-10-21 19:43:08) Post Reply

lizabit
Need To Set


Enrolled: Jul 2003
Posts: 17
AP: 1

 /*Part 2
************/
<html>
<head>
</head>
<body>
<div align="center">
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post"
name="filter" id="filter">
<table border="0" cellpadding="2" width="640" cellspacing="3">
<tr>
<td valign="top" align="center" bgcolor="#C0C0C0">Websites
<p>
<select name="website_list" size="10" id="website_list" style="background-color:#c0c0c0 ">
<?php
//create websites query:
$query_websites = "SELECT w_id, w_name FROM `websites`;";
//Do query obtain result:
$result = mysql_query($query_websites, $db);
// Get and display data one row at a time
while($row = mysql_fetch_array($result)) {
// Create option, use sel() to show if selected:
echo '<option value="'.$row['w_id'].'"'; sel($row['w_id'],'w');
echo '>'.$row['w_name'].'</option>';
}
?>
</select><br>
Select from<br>above to <br>edit website<br> details
<br><input type="submit" name="submit_edit_web" value="« Edit »">
<br>~~
<br><input type="submit" name="sub_delete_web" value="« Delete »">
~~<br><input type="submit" name="add_websites" value="« Add »">
</td>
<td>
<div align="center">
<center>
<table border="1" cellpadding="2" cellspacing="2" width="88%">
<tr>
<td width="100%" bgcolor="#ccffcc"><strong><u>Filter</u></strong><br>
<label for="web">Websites</label>
<input type="radio" name="web_spon" value="web" id="web"
<?php check_radio('web_spon','web','web'); ?>>
  
<label for="spon">Sponsors</label>
<input type="radio" name="web_spon" value="spon" id="spon"
<?php check_radio('web_spon','spon','web'); ?>>
<p>
<label for="rel1">With Relations</label>
<input type="radio" name="relations" value="yes" id="rel1"
<?php check_radio('relations','yes','yes'); ?>>
  
<label for="rel2">No Relations</label>
<input type="radio" name="relations" value="no" id="rel2"
<?php check_radio('relations','no','yes'); ?>>
  
<label for="rel3">All</label>
<input type="radio" name="relations" value="all" id="rel3"
<?php check_radio('relations','all','yes'); ?>>
  
<p>
<label for="status1">Pending</label>
<input type="radio" name="status" value="Pending" id="status1"
<?php check_radio('status','Pending','Active'); ?>>
  
<label for="status2">Active</label>
<input type="radio" name="status" value="Active" id="status2"
<?php check_radio('status','Active','Active'); ?>>
  
<label for="status3">Inactive</label>
<input type="radio" name="status" value="Inactive" id="status3"
<?php check_radio('status','Inactive','Active'); ?>>
  
<label for="status4">Defunct</label>
<input type="radio" name="status" value="Defunct" id="status4"
<?php check_radio('status','Defunct','Active'); ?>>
  
<label for="status5">All</label>
<input type="radio" name="status" value="All" id="status5"
<?php check_radio('status','All','Active'); ?>>
  
<br>
<center><input type="submit" name="filter" id="filter" value="Apply Filter">
<br></center>
</td>
</tr>
<tr>
<td bgcolor="#ffff99"><center>
Select website and sponsor from list <br>and click to add relationships
<input type="submit" name="Submit_WS"
value="« Add New Relationship »"> <br>~~<br>
<input type="submit" name="submit_show_rel"
value="« Show Relationships »"><br> </center>
</td></tr>
<tr>
<td width="100%">
<?php
/****************************
** Display area
****************************/
?>
<div id="Layer1" style="position:relative; width:390px; height:210px;
z-index:1; overflow:auto; background-color:#DDEEFF; layer-background-color:#c0c0c0;">
<blockquote><center><br>
<?php
/**************************
** Display filter results
**************************/
$result = @mysql_query($query_list,$db);
// Get data one row at a time:
while($row = @mysql_fetch_array($result)){
// Create options in an array:
echo $row['name']."<br>";
}
/**************************
** Display relationships
**************************/
if(isset($_POST['submit_show_rel'])){
echo 'Click on link to delete relationship:<br>';
$query_ws = "SELECT `ws_w_id`,`ws_s_id`,`w_name`,`s_name`
FROM `sponsors`,`websites`,`website_sponsor`
WHERE `s_id`= `ws_s_id` AND `w_id` = `ws_w_id`
";
$result = mysql_query($query_ws, $db);
// loop through data result
while($row = mysql_fetch_array($result)){
// create delete links to send id's through GET:
echo '<a href='.$_SERVER['PHP_SELF'].'?del_w='.$row['ws_w_id'].'&del_s='.$row['ws_s_id'].'>'.$row['w_name'].
' · '.$row['s_name'].'</a><br>';
}
$query_optimize_web = "OPTIMIZE TABLE `website_sponsor`";
@mysql_query($query_optimize_web,$db);
}//end if(isset($_POST['submit_show_rel']
/**************************
** Display add/edit websites (messy)
**************************/
if(isset($_POST['submit_edit_web'])|| (isset($_POST['add_websites']))){
if(isset($_POST['add_websites'])){
$set_flag = 'setflag';
}
$query_check = "SELECT * FROM `Websites`
WHERE w_id = '".$_POST['website_list']."'
";
if($set_flag != 'setflag'){
$result = mysql_query($query_check, $db);
$row = mysql_fetch_array($result);
$w_id = $row['w_id'];
$w_name = stripslashes($row['w_name']);
$w_url = stripslashes($row['w_url']);
$w_desc = stripslashes($row['w_desc']);
$w_status = stripslashes($row['w_status']);
// clear MySQL memory:
mysql_free_result($result);
}
//display form
echo '<div align="left">';
echo '<strong>Edit Website Details </strong> <br>';
echo 'Name:<br>';
echo '<input name="w_name" type="text" id="w_name" size="50" maxlength="255" value="';
echo $w_name;
echo '"><br>';
echo 'URL:<br>';
echo '<input name="w_url" type="text" id="w_url" size="50" maxlength="255" value="';
echo $w_url;
echo '"><br>';
echo 'Description:<br>';
echo '<textarea name="w_desc" cols="50" rows="5" id="w_desc" wrap="hard">';
echo $w_desc;
echo '</textarea><br>';
echo 'Status:<br>';
echo '<select name="w_status" id="w_status">';
echo '<option value="Pending"';
if($w_status == 'Pending') {
echo ' selected >'; }
echo '>Pending</option>';
echo '<option value="Active"';
if($w_status == 'Active') {
echo ' selected >'; }
echo '>Active</option>';
echo '<option value="Inactive"';
if($w_status == 'Inactive') {
echo ' selected >'; }
echo '>Inactive</option>';
echo '<option value="Defunct"';
if($w_status == 'Defunct') {
echo ' selected >'; }
echo '>Defunct</option>';
echo '</select><br></div>';
echo '<input name="w_id" type="hidden" value="';
echo $w_id;
echo '"><br>';
echo '<input type="reset" name="Reset" value="Reset">   ';
echo '<input name="display_edit_web" type="submit" id="display_edit_web" value="Edit">   ';
echo '<input name="display_add_websites" type="submit" id="display_add_websites" value="Add"><br>';
}elseif(isset($_POST['display_edit_web'])){
$query_update_web = "UPDATE `Websites`
SET w_name = '".$_POST['w_name']."',
w_url = '".$_POST['w_url']."',
w_desc = '".$_POST['w_desc']."',
w_status = '".$_POST['w_status']."'
WHERE w_id = '".$_POST['w_id']."'
";
if($result_edit = @mysql_query($query_update_web,$db) && @mysql_affected_rows($db) == 1){
$status_update = 'Edited Website Record';
$status_err = 'update';
}else{
$status_err = 'not_update';
$status_update = 'Did NOT Update Website Record';
} // optimize table to help prevent problems
$query_optimize_web = "OPTIMIZE TABLE `Websites`";
@mysql_query($query_optimize_web,$db);
}//End elseif(isset($_POST['display_edit_web']))

/**************************
** Display add/edit sponsors (messy)
**************************/
if(isset($_POST['submit_edit_spon'])||(isset($_POST['add_sponsors']))){
if(isset($_POST['add_sponsors'])){
$set_flag = 'setflag';
}
$query_spon_list = "SELECT * FROM `sponsors`
WHERE s_id = '".$_POST['sponsor_list']."'
";
if($set_flag != 'setflag')
{
$result = mysql_query($query_spon_list,$db);
$row = mysql_fetch_array($result);
$s_id = $row['s_id'];
$s_name = stripslashes($row['s_name']);
$s_url = stripslashes($row['s_url']);
$s_staturl = stripslashes($row['s_staturl']);
$s_email = stripslashes($row['s_email']);
$s_uname = stripslashes($row['s_uname']);
$s_pass = stripslashes($row['s_pass']);
$s_status = stripslashes($row['s_status']);
$s_date = stripslashes($row['s_date']);
// clear MySQL memory:
mysql_free_result($result);
}
echo '<strong>Add Sponsor / Edit Sponsor Details</strong><br>';
echo 'Name:<br>';
echo '<input name="s_name" type="text" id="s_name" size="50" maxlength="255" value="';
echo $s_name;
echo '"><br>URL:<br>';
echo '<input name="s_url" type="text" id="s_url" size="50" maxlength="255"value="';
echo $s_url;
echo '"><br>Statistics URL:<br>';
echo '<input name="s_staturl" type="text" id="s_staturl" size="50" maxlength="255"value="';
echo $s_staturl;
echo '"><br>Email:<br>';
echo '<input name="s_email" type="text" id="s_email" size="50" maxlength="255"value="';
echo $s_email;
echo '"><br>User Name:<br>';
echo '<input name="s_uname" type="text" id="s_uname" size="50" maxlength="255"value="';
echo $s_uname;
echo '"><br>Password:<br>';
echo '<input name="s_pass" type="text" id="s_pass" size="50" maxlength="255"value="';
echo $s_pass;
echo '"><br>Status:<br><select name="s_status" id="s_status">';
echo '<option value="Pending"';
if($s_status == 'Pending')
echo ' selected ';
echo '>Pending</option>';
echo '<option value="Active"';
if($s_status == 'Active')
echo ' selected ';
echo '>Active</option>';
echo '<option value="Inactive"';
if($s_status == 'Inactive')
echo ' selected ';
echo '>Inactive</option>';
echo '<option value="Defunct"';
if($s_status == 'Defunct')
echo ' selected ';
echo '>Defunct</option>';
echo '</select>Date:<br><input name="s_date" type="text" id="s_date" size="10" maxlength="10"value="';
echo $s_date;
echo '">   <font size="1">[ YYYY-MM-DD ]</font><br>';
echo '<input name="s_id" type="hidden" value="';
echo $s_id;
echo '"><input type="reset" name="Reset" value="Reset">   ';
echo '<input name="edit_spon" type="submit" id="edit_spon" value="Edit">   ';
echo '<input name="display_add_spon" type="submit" id="display_add_spon" value="Add" style="visibility:invisible"><br>';
echo $status_update;
}elseif(isset($_POST['edit_spon'])){
$query_update_spon = "UPDATE `Sponsors`
SET s_name = '".$_POST['s_name']."',
s_url = '".$_POST['s_url']."',
s_staturl = '".$_POST['s_staturl']."',
s_email = '".$_POST['s_email']."',
s_uname = '".$_POST['s_uname']."',
s_pass = '".$_POST['s_pass']."',
s_status = '".$_POST['s_status']."',
s_date = '".$_POST['s_date']."'
WHERE s_id = '".$_POST['s_id']."'
";
if($result = @mysql_query($query_update_spon,$db) && @mysql_affected_rows($db) == 1){
$status_err = 'update';
}else{
$status_err = 'not_update';
}
// optimize table to help prevent problems
$query_optimize_spon = "OPTIMIZE TABLE `Sponsors`";
@mysql_query($query_optimize_spon,$db);
}//End if(isset($_POST['edit_spon'])){

report_status($status_err);
echo $status;
?>
</center>
</blockquote>
</td>
</tr>
<tr><td align="center" bgcolor="#ffcccc">
</td></tr>
<tr><td>
</td></tr>
</table>
</center>
</div>
</td>
<td valign="top" align="center" bgcolor="#C0C0C0">Sponsors
<p>
<select name="sponsor_list" size="10" id="sponsor_list" style="background-color: #c0c0c0">
<?php
//create websites query:
$query_sponsors = "SELECT s_id, s_name FROM `sponsors`;";
//Do query obtain result:
$result = mysql_query($query_sponsors, $db);
// Get and display data one row at a time
while($row = mysql_fetch_array($result)) {
// Create option, use sel() to show if selected:
echo '<option value="'.$row['s_id'].'"';
sel($row['s_id'],'s');
echo '>'.$row['s_name'].'</option>';
}
?>
</select><br>
Select from<br>above to<br>edit sponsor<br> details
<br><input type="submit" name="submit_edit_spon" value="« Edit »"><br>~~
<br><input type="submit" name="sub_delete_spon" value="« Delete »"><br>~~
<br><input type="submit" name="add_sponsors" value="« Add »">
</td>
</tr>
</table>
</form>
</div>
</form>
</body>
</html>
Regards Liz
 

 (#61 2003-10-25 20:18:38) Post Reply

logspirit
Need To Set


Enrolled: Oct 2001
Posts: 63
AP: 1

 Liz,
If You are learning, that's all that counts!!!
The more practice You get and the deeper You go into the knowledge, the easier it will all become. Soon many typo errors and other simple mistakes (which EVERYBODY makes!!!) will become apparent just from a FRESH reading - I emphasise FRESH, because so often we get so involved in our own code that things that are right in front of us become invisible! Somehow, the observation part of our eyesight just doesn't work, almost like being hypnotized... So my advice - if You ever get stuck, just do something else for a while, and come back with FRESH eyes! I think You have done very well in this class and all Your efforts will be here to help others.

Hope You find some nice cool water to soak away the long hot AUSTRAILIAN summer!!!
From a buzzin' swamp somewhere in Florida, All My Best to You!

logspirit
 

 

View Previous Thread
Print this page Print This Page

View Next Thread

School Map:  Home / Enroll $ Student Records; Class  
$ News @ LIVE Tech Radio * Support/FAQ | Store

Advertising | Link To Us | Privacy 
Copyright 2000-2002 Script School Productions / KMR Enterprises 
No part of this website may be reproduced, copied and/or distributed in any medium 
without express written permission