Page 1 of 1

Need help with code

Posted: Mon Jan 25, 2010 1:14 pm
by joanneci
ok - I have a data collection form that runs a script. The script works - adds the data to the database if it's not a dupe. The problem is in the redirect to header., It goes to index.php, but is not printing the message, only the button to return to the menu. I'm running PHP5. I know it has to be something really dumb. All this head banging has given me a headache! Any help is REALLY appreciated.

Pertinent files:
add_med.proc
<?
//include database connection
include ("includes/class.database.php");
require ("includes/functions.php");


$med_name = $_POST['med_name'];
$gen_name = $_POST['gen_name'];

//check to make sure medname is available
$listmeds = new DB_Sql;
$listmeds->query("Select * from medication where med_name='$med_name' and generic_name='$gen_name'");
while($listmeds->next_record()){
header('Location: index.php?message=190');
exit;
}

$addmed = new DB_Sql;
if ( isset($addmed)){

$addmed->query("insert into medication (med_name,generic_name) values ('$med_name','$gen_name')");
header('Location: index.php?message=188');
}
?>

index.php
<?
require ("includes/class.database.php");
require ("includes/functions.php");

//verifylogin();

require ("includes/header.php");



?>
<table cellspacing="0" cellpadding="0" border="0">
<tr>
<td width="1100" align="center">
<?

//check for system messages
printmessage($message);
print "$message";
print "<br>";
print "<input type='button' value='Return to Main Menu'onclick= location.href='../index.php'></td></tr>";


?>

<br>
<br>
</td>
</tr>
</table>

<?
//require ("../includes/footer.php");
?>

functions.php
<?php
function printmessage($message){
//set predefined messages
if ($message=="101"){
$displaymessage=("Message: Client Record Added Successfully!");
}
else if ($message=="102"){
$displaymessage=("Message: Client Record Edited Successfully!");
}
else if ($message=="103"){
$displaymessage=("Error: Client Record Already Exists!");
}
else if ($message=="111"){
$displaymessage=("Message: Client Guardian Record Added Successfully!");
}
else if ($message=="112"){
$displaymessage=("Message: Client Guardian Record Updated Successfully!");
}
else if ($message=="121"){
$displaymessage=("Message: New Client Note Added Successfully!");
}
else if ($message=="122"){
$displaymessage=("Message: Client Note is Blank!");
}
else if ($message=="179"){
$displaymessage=("Message: Billing Source Name or Abbreviation Already Exists!");
}
else if ($message=="180"){
$displaymessage=("Message: Employee added Successfully!");
}
else if ($message=="181"){
$displaymessage=("Message: Employee Record Edited Successfully!");
}
else if ($message=="182"){
$displaymessage=("Message: Employee Benefit Updated Successfully!");
}
else if ($message=="183"){
$displaymessage=("Message: Employee Benefit Edited Successfully!");

}
else if ($message=="184"){
$displaymessage=("Message: Billing Source Added Successfully!");

}
else if ($message=="185"){
$displaymessage=("Message: Billing Source Edited Successfully!");
}
else if ($message=="186"){
$displaymessage=("Message: Contract Updated Successfully!");
}

else if ($message=="187"){
$displaymessage=("Message: Contract Added Successfully!");
}
else if ($message=="188"){
$displaymessage=("Message: Medication Added Successfully!");
}
else if ($message=="189"){
$displaymessage=("Message: User Edited Successfully!");
}
else if ($message=="190"){
$displaymessage=("Error: Medication Already Exists.");
}
else if ($message=="191"){
$displaymessage=("Error: User Email Already Exists.");
}
else if ($message=="192"){
$displaymessage=("Error: Employee Already Exists.");
}
else if ($message=="193"){
$displaymessage=("Error:Duplicate Email Not Allowed. Does Employee Already Exist?");
}
else if ($message=="194"){
$displaymessage=("Message: Service Added Successfully");
}
else if ($message=="195"){
$displaymessage=("Error: Service Already Exists.");
}
else if ($message=="196"){
$displaymessage=("Message: Service Edited Successfully");
}
else if ($message=="197"){
$displaymessage=("Error: Invalid ID/Password");
}
else if ($message=="198"){
$displaymessage=("Error: Not Logged On. Log On to Continue");
}

else if ($message=="1010"){
$displaymessage=("Message: User Record Deleted");
}
else if ($message=="3333"){
$displaymessage=("Message: Agency Record Deleted");
}
else if ($message=="4444"){
$displaymessage=("Message: User Record Updated");
}
else{
$displaymessage=("");
}
if ($displaymessage<>""){
print ("<font color=\"red\"><strong>$displaymessage</strong></font><br><br>");
}
}

Re: Need help with code

Posted: Mon Jan 25, 2010 2:05 pm
by AbraCadaver
I can see this script won't ever do anything other than print a message, but to help you with that part:

http://us2.php.net/manual/en/reserved.variables.get.php

Code: Select all

printmessage($_GET['message']);

Re: Need help with code

Posted: Mon Jan 25, 2010 2:37 pm
by joanneci
Thanks - I knew it would be something easy.