Databases
StackOverflow2013
Postsdbo
POGive User Custom Message Based on Database Fields
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POGive User Custom Message Based on Database Fields
    primarykey
    data
    text
    <p>This is a registration form for students to sign up for a time to attend an orientation session. I have already made the email address field a UNIQUE field in the database. </p> <p>What I need to do is if the email address exists, that means the student has already signed up for a day and time to go to orientation. So instead of returning the error message "That email address already exists", I want to return a message that says: "You have already signed up for an orientation day/time. You signed up for at . If you wish to change your day/time, please cancel the first day/time and then come back to sign up for your new time." </p> <p>So I need to know how to search the database to find the day and time they signed up for and return that in the customized message that is returned when a user tries to sign up more than once. </p> <pre><code>&lt;?php // set the mode if(isset($_GET['p'])) $mode = $_GET['p']; else if(isset($_POST['p'])) $mode = $_POST['p']; else $mode = ''; // sanitize input if(isset($_GET['time_id'])) { $timestamp = (int)$_GET['timestamp']; $time_id = (int)$_GET['time_id']; } if(isset($_POST['time_id'])) { $timestamp = (int)$_POST['timestamp']; $time_id = (int)$_POST['time_id']; } // validate input $error = ''; if(date("G", $timestamp) != 0) $error .= 'Invalid timestamp.&lt;br/&gt;'; if(($time_result = valid_time_id($time_id)) == false) $error .= 'Invalid time id.&lt;br/&gt;'; else $time_row = mysql_fetch_array($time_result); switch($mode) { default: break; case "schedule": // sanitize input $first_name = sanitize_input($_POST['first_name']); $last_name = sanitize_input($_POST['last_name']); $email = sanitize_input($_POST['email']); $retype_email = sanitize_input($_POST['retype_email']); $college_id = sanitize_input($_POST['college_id']); $retype_college_id = sanitize_input($_POST['retype_college_id']); $phone = sanitize_input($_POST['phone']); $first = (isset($_POST['first']) ? 1 : 0); $verification = $_POST['verification']; // validate input $error = ''; if(empty($first_name)) $error .= 'You must enter a first name.&lt;br&gt;'; if(empty($last_name)) $error .= 'You must enter a last name.&lt;br&gt;'; if(!valid_email($email)) $error .= 'Invalid email.&lt;br&gt;'; if($email != $retype_email) $error .= 'The two email addresses don\'t match.&lt;br&gt;'; if(!valid_college_id($college_id)) $error .= 'Invalid student id. Student id must contain seven digits including zeros.&lt;br&gt;'; if($college_id != $retype_college_id) $error .= 'The two student ids don\'t match.&lt;br&gt;'; if(empty($phone)) $error .= 'You must enter a phone number.&lt;br&gt;'; $student_result = db_query("select id from ".$GLOBALS['db_pre']."student where canceled='0' and timestamp='".$timestamp."' and time_id='".$time_id."'"); if(mysql_num_rows($student_result) &gt;= $time_row['slots']) $error .= 'Sorry, too many people are already scheduled for this time slot.&lt;br&gt;'; if($_SESSION['captcha'] != $verification) $error .= 'Invalid image verification.&lt;br&gt;'; // if there's no error if($error == '') { // schedule it db_query("insert into ".$GLOBALS['db_pre']."student set first_name='".$first_name ."',last_name='".$last_name ."',email='".$email ."',college_id='".$college_id ."',phone='".$phone ."',timestamp='".$timestamp ."',time_id='".$time_id ."',unschedule_code='".md5(time()) ."',inserted_at='".gmdate("Y-m-d H:i:s") ."'"); $student_id = mysql_insert_id(); // send email to student $subject = "A-B Tech New Student Appointment Confirmation"; if(current_site() == "orientation") $subject = "A-B Tech New Student Orientation"; else $subject = "A-B Tech Campus Tour"; $message = format_text("Scheduling Email", $student_id); email($email, $subject, $message); // get the start and end times for the appointment $time_result = db_query("select * from ".$GLOBALS['db_pre']."time where id='".$time_id."'"); $time_row = mysql_fetch_array($time_result); //$timestamp_start = strtotime(date("F j, Y", $timestamp).", ".$time_row['time']); //$timestamp_end = strtotime("+1 hour", $timestamp_start); /*// send email, with calendar attachment, to counselors if(current_site() == "orientation") $subject = "A-B Tech New Student Orientation: "; else $subject = "A-B Tech Campus Tour: "; $subject .= date("F j, Y", $timestamp).", ".$time_row['time']."; ".$first_name." ".$last_name.""; $message = "A student has scheduled an appointment:\r\n\r\n"; $message .= "Name: ".$first_name." ".$last_name."\r\n"; $message .= "Date: ".date("F j, Y", $timestamp).", ".$time_row['time']."\r\n"; $message .= "Email: ".$email."\r\n"; $message .= "Phone: ".$phone."\r\n"; // send the email to all the counselors $user_result = db_query("select * from user where no_email=0"); while($user_row = mysql_fetch_array($user_result)) { email($user_row['email'], $subject, $message); }*/ } break; } // captcha image verification srand(time()); $_SESSION['captcha'] = substr(md5(rand(1,9999)), rand(1,15), 5); $_SESSION['captcha'] = str_replace("O", "1", $_SESSION['captcha']); // to avoid confusion $_SESSION['captcha'] = str_replace("o", "2", $_SESSION['captcha']); // ... $_SESSION['captcha'] = str_replace("0", "3", $_SESSION['captcha']); // ... // the top layout layout_top(date("F j, Y", $timestamp).', '.$time_row['time']); // the middle layout switch($mode) { default: if($mode == "schedule" &amp;&amp; $error == "") { echo display_text("Scheduling Text", $student_id); ?&gt;&lt;p&gt;&lt;a href="index.php"&gt;Click here to go back&lt;/a&gt;&lt;/p&gt;&lt;?php } else { ?&gt; &lt;h1 align="center" style="padding-bottom: 0; margin-bottom: 0;"&gt;&lt;?=strtoupper(date("F j, Y", $timestamp).' '.$time_row['time'])?&gt;&lt;/h1&gt; &lt;p align="center" style="padding-top: 0; margin-top: 0;"&gt;&lt;strong&gt;&lt;a href="index.php?month=&lt;?=date("n", $timestamp)?&gt;&amp;year=&lt;?=date("Y", $timestamp)?&gt;"&gt;choose another date&lt;/a&gt;&lt;/strong&gt;&lt;/p&gt; &lt;?php if($mode == "schedule" &amp;&amp; $error != '') { ?&gt; &lt;p class="error"&gt;&lt;?=$error?&gt;&lt;/p&gt; &lt;?php } ?&gt; &lt;form action="&lt;?=$_SERVER['PHP_SELF']?&gt;" method="post"&gt; &lt;input type="hidden" name="p" value="schedule"&gt; &lt;input type="hidden" name="timestamp" value="&lt;?=$timestamp?&gt;"&gt; &lt;input type="hidden" name="time_id" value="&lt;?=$time_id?&gt;"&gt; &lt;fieldset&gt; &lt;legend&gt;Schedule an appointment for this date&lt;/legend&gt; &lt;p&gt;Fill out this form to schedule a New Student appointment on this date. Make sure you use a valid email address.&lt;/p&gt; &lt;ul&gt; &lt;li&gt; &lt;label for="first_name"&gt;First Name&lt;/label&gt; &lt;input type="text" name="first_name"&lt;?=($mode == "schedule" ? ' value="'.$first_name.'"' : '')?&gt;&gt; &lt;/li&gt; &lt;li&gt; &lt;label for="last_name"&gt;Last Name&lt;/label&gt; &lt;input type="text" name="last_name"&lt;?=($mode == "schedule" ? ' value="'.$last_name.'"' : '')?&gt;&gt; &lt;/li&gt; &lt;li&gt; &lt;label for="email"&gt;Email&lt;/label&gt; &lt;input type="text" name="email" size="30"&lt;?=($mode == "schedule" ? ' value="'.$email.'"' : '')?&gt;&gt; &lt;/li&gt; &lt;li&gt; &lt;label for="retype_email"&gt;Retype Email&lt;/label&gt; &lt;input type="text" name="retype_email" size="30"&lt;?=($mode == "schedule" ? ' value="'.$retype_email.'"' : '')?&gt;&gt; &lt;/li&gt; &lt;li&gt; &lt;label for="college_id"&gt;Student ID(For your student ID#, please refer to the e-mail you received regarding your A-B Tech WebAdvisor and Email Accounts.) &lt;/label&gt; &lt;input type="text" name="college_id" size="30"&lt;?=($mode == "schedule" ? ' value="'.$college_id.'"' : '')?&gt;&gt; &lt;/li&gt; &lt;li&gt; &lt;label for="retype_college_id"&gt;Retype Student ID&lt;/label&gt; &lt;input type="text" name="retype_college_id" size="30"&lt;?=($mode == "schedule" ? ' value="'.$retype_college_id.'"' : '')?&gt;&gt; &lt;/li&gt; &lt;li&gt; &lt;label for="phone"&gt;Phone&lt;/label&gt; &lt;input type="text" name="phone"&lt;?=($mode == "schedule" ? ' value="'.$phone.'"' : '')?&gt;&gt; &lt;/li&gt; &lt;li&gt; &lt;label for="verification"&gt;Verification&lt;/label&gt; &lt;img src="../images/verify.php" width="180" height="40" alt="Verification"&gt;&lt;br/&gt; &lt;input type="text" name="verification" size="10"&gt; &lt;small&gt;&amp;laquo; type the characters in the image above into this box&lt;/small&gt; &lt;/li&gt; &lt;li&gt; &lt;input type="submit" value="Submit"&gt; &lt;/li&gt; &lt;/ul&gt; &lt;/fieldset&gt; &lt;/form&gt; &lt;?php } break; } // the bottom layout layout_bottom(); ?&gt; </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USKatieK
    1. USHoppedUpDesigns
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COPlease, don't use `mysql_*` functions to write new code. They are no longer maintained and the community has begun [deprecation process](http://goo.gl/KJveJ). See the [*red box*](http://goo.gl/GPmFd)? Instead you should learn about [prepared statements](http://goo.gl/vn8zQ) and use either [PDO](http://php.net/pdo) or [MySQLi](http://php.net/mysqli). If you can't decide which, [this article](http://goo.gl/3gqF9) will help you. If you pick PDO, [here is good tutorial](http://goo.gl/vFWnC).
      singulars
      1. POGive User Custom Message Based on Database Fields
      1. UStereško
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload