Learn VBA & Macros in 1 Week!

PHP - How To Jump To Program If Condition Is True?

Full Excel VBA Course - Beginner to Expert

How To Jump To Program If Condition Is True?	View Content

How do I execute display.php if condition is true?

I have only included relevant code.

$query = "SELECT * FROM airplanes WHERE ama='$ama'";
if (mysql_num_rows($result) == 0)
    {
          //print error message
if (mysql_num_rows($result) == 1)
    {
          // execute display.php. How do I do this?

I do plan on changing the 2 ifs to if/else

Full Excel VBA Course - Beginner to Expert

Is It Possible To Jump Into A Live Program And Detect Where The Program Is Coming From.

Similar Tutorials

View Content

For example with an IDE to run a program is there a way to put some code in the path and let it tell me where it came from like a referral?
For example lets say I am at pgm1.php and at the top of that program i put something like.

$ref = $_SERVER['HTTP_REFERER'];
echo("$ref<br>";

Result: https://www.mydomain.com/wp-admin/admin.php?page=lambo

As you can clearly see the page that we have entered the code in is referred by the URL here.

It tells me that it was last at a word press page /wp-admin/admin-php and I can go to that page and it will be the last page it was at..

So bottom line then if i add this code to the admin page and click the same button i had before.. it will tell me the file that called out the admin page.

Baslcaly I am looking for ideas on how to track the page i am now all the way back to the page with the button on it and all intermediate pages that it passes thru to get to the final destination. It seems that to succesfully troubleshoot a fault is to follow the path of the entire job and see if any breaks...

Any thoughts or suggestions on how to best do this would greatly be appreciated.

Php Of One Php Condition Is True

Similar Tutorials

View Content

<?php
$id1 = '5' ;
$id = array(1,2,3,4,5,6,7);

   foreach($id as $value){
if($id1==$value){
   echo 'One of them matches, ' ;
   echo 'Do not execute command <BR>' ;
} ////// if ends here
} ////// loop ends here

?> How to do something if all statements are false ? like when id $id1 = '10' , ?

301 Redirect Using Htacess If Condition Is True

Similar Tutorials

View Content

Dear PHP Experts, I have one simple question to ask you that i have to redirect an entire site into new domain using 301 Redirect In Htaccess. Also i have to check one condition. I have variable called $country; It stores country name, I have to redirect only if the country become "INDIA" Im confused that my condition is comes in my php file & 301 redirect is in htaccess. How its possible ? Thanks IN Advance PHPLazy

Looping While Condition Is Set And End On Second Condition.

Similar Tutorials

View Content

Find Value In Array And Make Sure It's Set To True, If Not Make It True.

Similar Tutorials

View Content

$looponce = 1;
foreach ($this->info as $k => $v) {
if ( (($k == 'subject') && ($v['required'])) && (!$this->settings['customSubject'])) {
for ($i = 0; $i <= 0; $i++) {
$output[] = $this->display_errors('error_system_subject');
}
}
if ( (($k == 'name') && (!$v['required'])) || ((!array_key_exists("name", $this->info)) && ($looponce == 1)) ) {
$output[] = $this->display_errors('error_system_name');
$looponce++;
}
}

That is my loop that i check things in. What i'm more interested in is the name if statement.

If currently checks for a name key in an array(below) and makes sure that it is set to required. If it's not set to required, print out a system error and die()'s.

I'm looking for ways to remove the need for program errors and just change them to what is needed to run.

What i know how to do is, get into the inner array, what i don't know is how to edit the data and put it back exactly as it was given to me. The inner array data can be put back in any order, but the outer array must be in exact order as it was given.

above code $this->info = $formdata;

$formdata = array(
'name' => array('name'=>"Full Name", 'required'=>false, 'type'=>'text'), # This needs to be required=>true, but i can't trust the user, which is why i have the error.
'telephone' => array('name'=>"Telephone", 'required'=>false, 'type'=>'phone'),
);

Any help is greatly appreciated, also am i doing the foreach loop in the code above in an efficient manner or is there another way?

Unable To Jump To Row Zero

Similar Tutorials

View Content

I get the unable to jump to row zero mysql error.

Code: [Select]
function is_admin($uid, $cid)
{
$uid = (int)$uid;
$cid = (int)$cid;

$sql = "SELECT
`users`.`id` AS `uid`,
`companies`.`companyid` AS `cid`,
`companies`.`adminid` AS `aid`
FROM `companies`
LEFT JOIN `users`
ON `users`.`id` = companies.adminid
WHERE `users`.`id` = {$uid}
AND `companies`.`companyid` = {$cid}";

$user = mysql_query($sql);

return (mysql_result($user, 0) == '1') ? true : false;
}

Jump Line In File

Similar Tutorials

View Content

So I'm basically done an assignment, however I'm having the biggest brainfart at the moment. For the life of me I cannot remember how to "jump line" in a file and have to put "end" at the end of my txt files. Also I have to put a break in my code which messes up my formatting:

$coursedata = explode('
', rtrim($coursedata));

$studentdata = explode('
', rtrim($studentdata));

fwrite($fp, $number.'||'.$_POST['course'].'
'.$content);

Here is the main code below for the script:

<html>
<head>
<?php
	$success = 0;
	$number_of_registered = 0;
	$course_array = getdatafile('courses.txt');
	$registered_array = getdatafile('register.txt');
	#______________global variables____________________
	function getdatafile($file) {
	# code...
		$coursedata = file_get_contents($file);
		$coursedata = explode('
', rtrim($coursedata));
		unset($coursedata[count($coursedata) - 1]);
		$course_array = array();
		foreach($coursedata as $row) { 
			$course_array[] = explode('||', $row);
		}
		return $course_array;
	}

	#_____________functions_______________________
	if (isset ($_POST['name']) and isset ($_POST['number']) and isset ($_POST['course'])) {
		#________________test if the post exists
		$name = $_POST['name'];
		$number = $_POST['number'];
		$found = 0;
		$findregistered = 0;

		for ($i = 0; $i < sizeof($registered_array); $i++) {
			if ($registered_array[$i][0] == $_POST['number'] && $registered_array[$i][1] == $_POST['course']) {
				# ___________test if the student is enrolled in this course
				$findregistered = 1;
			}

			if($registered_array[$i][1] == $_POST['course']) {
				#________counter of the number registered in this course
				$number_of_registered++;
			}
		}

		for ($i = 0; $i < sizeof($course_array); $i++) {
			if ($course_array[$i][1] == $_POST['course']) {
				# ______________this test if the number of registered is the max
				$course_name = $course_array[$i][0];
				$findcourse = 1;
				if($number_of_registered < $course_array[$i][2]) {
					$number_max = 0;
				} 
				else {
					$number_max = 1;
				}
			}
		}

	$studentdata = file_get_contents('students.txt');
	$studentdata = explode('
', rtrim($studentdata));
	for ($i = 0; $i < sizeof($studentdata); $i++) {
		list($studentname, $studentnumber) = explode("||", rtrim($studentdata[$i]));
		if (strtoupper($name) == strtoupper($studentname) && strtoupper($number) == strtoupper($studentnumber)) {
			$found = 1;
			if ($findcourse == 1 && $findregistered == 0 && $number_max == 0) {
				# _____________________do all the tests to record the student in the course("register.txt") and do it if all the test are checked
				$success = 1;
				$content = file_get_contents('register.txt');
				$fp = fopen('register.txt', 'w');
				fwrite($fp, $number.'||'.$_POST['course'].'
'.$content);
				fclose($fp);

				echo "<title>".strtoupper($name).",".strtoupper($studentname)."</title>";
			}
		}
	}
}
?>

<style>
	body, p{padding: 0;margin: 0;}
</style>
</head>

<body>
<form action="index.php" method="POST">
	<?php
        if (isset ($_POST['course'])) {
            $course = htmlentities ($_POST['course']); 
    
            # ___________________print the information of rgester  in the screen for 
            if ($success == 1) {
                echo "You have successfully enrolled in $course_name, $course!";
            }
    
            if($found == 0) {
                echo 'The credentials you have entered are incorrect, please try again.';
            }
            else {
                if($findregistered == 1) {
                    echo 'You have already enrolled in this course.';
                }
                else {
                    if($number_max == 1) {
                        echo "Sorry $course_name, $course is full, please select another course.";
                    }
                }
            }
        }
    ?>
<p>Courses</p>
	<p><input name = "name" placeholder = "Student Name" type = "text"></p>
	<p><input name = "number" placeholder = "Student Number" type = "text"></p>
	<p><select name = "course" size = "1">
        <option id = "select">-- Select Course --</option> 
        <?php 
            for ($i = 0; $i <sizeof($course_array); $i++) {
                $number_of_registered1 = 0;
                for ($j = 0; $j < sizeof($registered_array); $j++) {
                    if($registered_array[$j][1] == $course_array[$i][1]) {
                        $number_of_registered1++;
                    }
                }
                $a = '<option value = "'.$course_array[$i][1].'">'.$course_array[$i][0].' registered:'.$number_of_registered1.'</option>';
                echo $a;
            } 
		?>
	</select></p>

	<p><input type = "submit" value = "Send"><input type = "reset" value = "Clear"></p>
</form>
</body>
</html>

Attached Files courses.txt 94bytes 0 downloads register.txt 3bytes 0 downloads students.txt 103bytes 0 downloads index.php 4.19KB 0 downloads

Need Help In My If Condition

Similar Tutorials

View Content

I have this if statement with validations and mysql query

Code: [Select]
<?php
if(isset($_POST['submit']))
{
$errors = array();

$required_fields = array('menu_name', 'position', 'visible');

foreach($required_fields as $fieldname)
{
if(!isset($_POST[$fieldname]) || (empty($_POST[$fieldname]) && $_POST[$fieldname] != 0))
{
$errors[] = $fieldname;
}
}

$fields_with_length = array('menu_name' => 30);

foreach($fields_with_length as $fieldname => $maxlength)
{
if (strlen(trim(mysql_prep($_POST[$fieldname]))) > $maxlength)
{
$errors[] = $fieldname;
}
}

if(empty($errors))
{
//Perform Update

$id = mysql_prep($_GET['subj']);
$menu_name = mysql_prep($_POST['menu_name']);
$position = mysql_prep($_POST['position']);
$visible = mysql_prep($_POST['visible']);

$query = "UPDATE subjects SET menu_name = '{$menu_name}', position = {$position}, visible = {$visible} WHERE id = {$id}";

$result = mysql_query($query, $connection);
if(mysql_affected_rows() == 1)
{
//success
$message = "Record has been successfuly updated!";
}
else
{
//failed
$message = "The subject update failed";
$message .= "<br>". mysql_error();
}

}
else
{
//Error Occured
$message = "There were ". count($errors) . " error in the form";
}

}

?>

I'm having problem on this line

Code: [Select]
<?php
if(!isset($_POST[$fieldname]) || (empty($_POST[$fieldname]) && $_POST[$fieldname] != 0))
?>

this line is for validation of my radio button which has a 0 and 1 value.

Quote

&& $_POST[$fieldname] != 0

Eventhough the textbox is not set and is empty, it's still bypassing my if statement and still executing the update query...

While(true) - Ok?

Similar Tutorials

View Content

Apart from the fact this can cause an infinite loop is it OK to use?

$user->reset_token = $user->generate_password(32);

// Make sure the token is unique
while(TRUE)
{
$count = ORM::factory('manager')->where('reset_token', '=', $user->reset_token)->count_all();
if($count < 1) break;

$user->reset_token = $user->generate_password(32);
}

Or would you approach the logic for this differently?

Thoughts appreciated. Cheers

True Vs 1

Similar Tutorials

View Content

Is there any reason why I would want to use this...

Code: [Select]
$_SESSION['loggedIn'] = TRUE;
versus this...

Code: [Select]
$_SESSION['loggedIn'] = 1;
(The first one is easier to read...)

Debbie

Is True True?

Similar Tutorials

View Content

I am wondering if these "true" values are the same to PHP...
Code: [Select]
<a href="' . BASE_URL . 'members/log_in.php?addComment=true">Log In</a>

Code: [Select]
if (isset($_GET['addComment']) && ($_GET['addComment']==TRUE)){

Debbie

Php If || Condition Not Working

Similar Tutorials

View Content

Code: [Select]
if($this->color=="Blue" || $this->color=="Green" || $this->color=="Red" || $this->color=="Yellow") {
return true;
} else {
return false;
}

This is returning false, when it should be returning true because $this->color DOES equal "Red"...
I can NEVER EVER get these conditional things to work UNLESS it's &&, but I even tried:
!$this->color != "Red" && .........

as well to see if that would work even though that's really confusing.

Can someone help me finally understand this stupid OR stuff?

Problem In If Condition

Similar Tutorials

View Content

Hi..

I tried this code:

Code: [Select]
<?php
     error_reporting(0);
   date_default_timezone_set("Asia/Singapore"); //set the time zone
$con = mysql_connect('localhost', 'root','');
  mysql_select_db("mes", $con);
if (!$con) {
    echo 'failed';
    die();
}

$sql = "SELECT PCODE, total FROM kanban_checker ORDER BY PCODE";
$res = mysql_query($sql, $con) or die(mysql_error());

while($row = mysql_fetch_assoc($res)){
    $PCODE = $row['PCODE'];
    $total = $row['total'];
}
  $sql = "SELECT
                P28, P28_max, P28_min,
                P30, P30_max, P30_min,
                P32, P32_max, P32_min,
                P33, P33_max, P33_min,
                P35, P35_max, P35_min,
                P35M, P35M_max, P35M_min,
                P35W, P35W_max, P35W_min,
                P38, P38_max, P38_min,
                P41, P41_max, P41_min,
                P42, P42_max, P42_min,
                P43, P43_max, P43_min,
                P46, P46_max, P46_min
                FROM parameter_settings";
        $res_pcode = mysql_query($sql, $con);

  $row = mysql_fetch_assoc($res_pcode);
            $P28 = $row['P28'];
            $P28_max = $row['P28_max'];
            $P28_min = $row['P28_min'];

            $P30 = $row['P30'];
            $P30_max = $row['P30_max'];
            $P30_min = $row['P30_min'];

            $P32 = $row['P32'];
            $P32_max = $row['P32_max'];
            $P32_min = $row['P32_min'];

            $P33 = $row['P33'];
            $P33_max = $row['P33_max'];
            $P33_min = $row['P33_min'];

            $P35 = $row['P35'];
            $P35_max = $row['P35_max'];
            $P35_min = $row['P35_min'];

            $P35M = $row['P35M'];
            $P35M_max = $row['P35M_max'];
            $P35M_min = $row['P35M_min'];

            $P35W = $row['P35W'];
            $P35W_max = $row['P35W_max'];
            $P35W_min = $row['P35W_min'];

            $P38 = $row['P38'];
            $P38_max = $row['P38_max'];
            $P38_min = $row['P38_min'];

            $P41 = $row['P41'];
            $P41_max = $row['P41_max'];
            $P41_min = $row['P41_min'];

            $P42 = $row['P42'];
            $P42_max = $row['P42_max'];
            $P42_min = $row['P42_min'];

            $P43 = $row['P43'];
            $P43_max = $row['P43_max'];
            $P43_min = $row['P43_min'];

            $P46 = $row['P46'];
            $P46_max = $row['P46_max'];
            $P46_min = $row['P46_min'];

            $P47 = $row['P47'];
            $P47_max = $row['P47_max'];
            $P47_min = $row['P47_min'];
       if($PCODE = $P28 || $total = $P28_min){
            echo $P28_min;
        }
        elseif($PCODE = $P30 || $total = $P30_min){
            echo $P30_min;
        }
        elseif($PCODE = $P32 || $total = $P32_min){
            echo $P32_min;
        }
        elseif($PCODE = $P33 || $total = $P33_min){
            echo $P33_min;
        }
        elseif($PCODE = $P35 || $total = $P35_min){
            echo $P35_min;
        }
        elseif($PCODE = $P35M || $total = $P35M_min){
            echo $P35M_min;
        }
        elseif($PCODE = $P35W || $total = $P35W_min){
            echo $P35W_min;
        }
        elseif($PCODE = $P38 || $total = $P38_min){
            echo $P38_min;
        }
        elseif($PCODE = $P41 || $total = $P41_min){
            echo $P41_min;
        }
        elseif($PCODE = $P42 || $total = $P42_min){
            echo $P42_min;
        }
        elseif($PCODE = $P43 || $total = $P43_min){
            echo $P43_min;
        }
        elseif($PCODE = $P46 || $total = $P46_min){
            echo $P46_min;
        }
        elseif($PCODE = $P47 || $total = $P47_min){
            echo $P47_min;
        }
        else{
            echo '';
        }
?>

for display data if total = min.

The problem is, in this condition he satisfied if condition even though $total is not equal to $P28_min.

Thank you

Double Condition

Similar Tutorials

View Content

if u use this for one condition

if ($nr > 5)

how would u check if the nr is between 5 and 50

thanks !

Condition For Checkbox

Similar Tutorials

View Content

Hi..

I have form for leave and now I need to add checkbox for halfday.

if checkbox is checked the HOURS_LEAVE = HOURS_LEAVE * 4 because his leave is halfday only.
then if checkbox is not check the HOURS_LEAVE = HOURS_LEAVE * 8 .
and also if checkbox is check the value is H else W then it also save to database
here is my code for LeaveEmp.php

<?php
include 'config.php';
date_default_timezone_set('Asia/Singapore');
session_start();
$currentEmpID = $_SESSION['empID'];

      $EMP_NO = $_GET['EMP_NO'];
      $NAME = $_GET['NAME'];
      $DATE_LEAVE_FROM = $_GET['DATE_LEAVE_FROM'];
      $DATE_LEAVE_TO = $_GET['DATE_LEAVE_TO'];
      $HOURS_LEAVE = $_GET['HOURS_LEAVE'];
      $Approve = $_GET['Approve'];
      $TYPE =$_GET['TYPE'];
      $dateprocess = $_GET['dateprocess'];
      $DATE_LEAVE = $_GET['DATE_LEAVE'];
      $EMPNO = $_GET['EMPNO'];

function GetDays($StartDate, $EndDate){
$StartDate = date("Y-m-d", strtotime($StartDate));
$EndDate = date("Y-m-d", strtotime($EndDate));
$Days[] = $StartDate;
$CurrentDate = $StartDate;
  while($CurrentDate < $EndDate){
    $CurrentDate = date("Y-m-d", strtotime("+1 day", strtotime($CurrentDate)));

        if(date("w",strtotime($CurrentDate))>0){
        $Days[] = $CurrentDate;

        }

  }
return count($Days);
}

$HOURS_LEAVE = GetDays($DATE_LEAVE_FROM, $DATE_LEAVE_TO);

$smarty->assign('LeaveStatus', array(SickLeave=>'Sick Leave',VacationLeave=>'Vacation Leave',BirthdayLeave=>'Birthday Leave',MaternityLeave=>'Maternity Leave', PaternityLeave=>'Paternity Leave', UnionLeave=>'Union Leave', Holiday=>'Holiday'));
$smarty->assign('TYPE', $TYPE);

$sql = "SELECT l.EMP_NO, l.DATE_LEAVE_FROM,
l.DATE_LEAVE_TO, l.HOURS_LEAVE, l.TYPE_LEAVE, l.STATUS_LEAVE
FROM $ADODB_DB.employment em, $PAYROLL.leave_data l
WHERE em.EMP_NO = l.EMP_NO AND em.EMP_ID = '$currentEmpID' AND l.DATE_LEAVE_FROM = '$DATE_LEAVE_FROM'";
$result_edit = $conn2->Execute($sql);

$DATE_LEAVE_FROM = $result_edit->fields['DATE_LEAVE_FROM'];
$DATE_LEAVE_TO = $result_edit->fields['DATE_LEAVE_TO'];

$smarty->assign('DATE_LEAVE_FROM', $DATE_LEAVE_FROM);
$smarty->assign('DATE_LEAVE_TO', $DATE_LEAVE_TO);

$sql = "SELECT l.EMP_NO, p.EMP_ID, CONCAT(LNAME, ', ',  FNAME, ' ', MI, '.') AS FULLNAME, l.DATE_LEAVE_FROM, l.DATE_LEAVE_TO, l.HOURS_LEAVE, l.TYPE_LEAVE, l.STATUS_LEAVE FROM $ADODB_DB.PERSONAL p, $ADODB_DB.employment em, $PAYROLL.leave_data l WHERE em.EMP_NO = l.EMP_NO AND p.EMP_ID = em.EMP_ID ORDER BY FULLNAME";
$rs = $conn2->GetAll($sql);

$smarty->assign('getleave', $rs);

$smarty->display('header_att.tpl');
$smarty->display('LeaveForm.tpl');
$smarty->display('footer.tpl');
?>

here is my code for saving leave:

<?php
  include 'config.php';
  date_default_timezone_set('Asia/Singapore');
  $currentEmpID      = $_SESSION["empID"];

$EMP_NO = $_GET['EMP_NO'];
      $NAME = $_GET['NAME'];
      $DATE_LEAVE_FROM = $_GET['DATE_LEAVE_FROM'];
      $DATE_LEAVE_TO = $_GET['DATE_LEAVE_TO'];
      $HOURS_LEAVE = $_GET['HOURS_LEAVE'];
      $TYPE =$_GET['TYPE'];
      $Approve = $_GET['Approve'];
      $dateprocess = $_GET['dateprocess'];

      $today = date("Y-m-d");

function GetDays($StartDate, $EndDate){
$StartDate = date("Y-m-d", strtotime($StartDate));
$EndDate = date("Y-m-d", strtotime($EndDate));
$Days[] = $StartDate;
$CurrentDate = $StartDate;
  while($CurrentDate < $EndDate){
    $CurrentDate = date("Y-m-d", strtotime("+1 day", strtotime($CurrentDate)));

        if(date("w",strtotime($CurrentDate))>0){
        $Days[] = $CurrentDate;

        }

  }
return count($Days);
}

$HOURS_LEAVE = GetDays($DATE_LEAVE_FROM, $DATE_LEAVE_TO);
$HOURS_LEAVE = $HOURS_LEAVE * 8;
$smarty->assign('LeaveStatus', array(SickLeave=>'Sick Leave',VacationLeave=>'Vacation Leave',BirthdayLeave=>'Birthday Leave',MaternityLeave=>'Maternity Leave', PaternityLeave=>'Paternity Leave', UnionLeave=>'Union Leave', Holiday=>'Holiday'));
$smarty->assign('TYPE', $TYPE);

$smarty->assign('DATE_LEAVE_FROM', $DATE_LEAVE_FROM);
$smarty->assign('DATE_LEAVE_TO', $DATE_LEAVE_TO);
$smarty->assign('EMP_NO', $EMP_NO);
$smarty->assign('NAME', $NAME);
$smarty->assign('HOURS_LEAVE', $HOURS_LEAVE);
$smarty->assign('TYPE', $TYPE);
$smarty->assign('dateprocess', $today);
  $sql = "SELECT EMP_NO, DATE_LEAVE_FROM, DATE_LEAVE_TO, HOURS_LEAVE, TYPE_LEAVE, STATUS_LEAVE, DATE_PROCESS FROM leave_data WHERE EMP_NO = '$EMP_NO' AND DATE_LEAVE_FROM = '$DATE_LEAVE_FROM' AND DATE_LEAVE_TO = '$DATE_LEAVE_TO'";
  $RsLeave = $conn2->Execute($sql);

  $numrowsRsLeave = $RsLeave->RecordCount();

   if($numrowsRsLeave > 0){
  echo "<script>alert('Transaction has already been process')</script>";
  echo "<script>navigate('LeaveEmp.php')</script>";
  }

  else {
  $sql = "SELECT EMP_NO, DATE_LEAVE_FROM, DATE_LEAVE_TO, HOURS_LEAVE, TYPE_LEAVE, STATUS_LEAVE, DATE_PROCESS FROM leave_data WHERE EMP_NO = '$EMP_NO' AND DATE_LEAVE_FROM = '$DATE_LEAVE_FROM' AND DATE_LEAVE_TO = '$DATE_LEAVE_TO'";
  $RsLeave = $conn2->Execute($sql);

    $saverec['EMP_NO'] = $EMP_NO;
  $saverec['DATE_LEAVE_FROM'] = $DATE_LEAVE_FROM;
  $saverec['DATE_LEAVE_TO'] = $DATE_LEAVE_TO;
  $saverec['HOURS_LEAVE'] = $HOURS_LEAVE;
  $saverec['TYPE_LEAVE'] = $TYPE;
  $saverec['STATUS_LEAVE'] = $Approve;
  $saverec['DATE_PROCESS'] = $today;

  $insertSQL = $conn2->GetInsertSQL($RsLeave, $saverec);
  $conn2->Execute($insertSQL);
  }


  $sql = "SELECT EMP_NO, DATE_LEAVE_FROM, DATE_LEAVE_TO, HOURS_LEAVE, TYPE_LEAVE, STATUS_LEAVE, DATE_PROCESS FROM leave_log WHERE EMP_NO = '$EMP_NO' AND DATE_LEAVE_FROM = '$DATE_LEAVE_FROM' AND DATE_LEAVE_TO = '$DATE_LEAVE_TO'";
  $RsLeaveLog = $conn2->Execute($sql);

  $numrowsRsLeave = $RsLeaveLog->RecordCount();

  if($numrowsRsLeave > 0){
  echo "<script>alert('Transaction has already been process')</script>";
  echo "<script>navigate('LeaveEmp.php')</script>";
  }

  else{
  $sql = "SELECT EMP_NO, DATE_LEAVE_FROM, DATE_LEAVE_TO, HOURS_LEAVE, TYPE_LEAVE, STATUS_LEAVE, DATE_PROCESS FROM leave_log WHERE EMP_NO = '$EMP_NO' AND DATE_LEAVE_FROM = '$DATE_LEAVE_FROM' AND DATE_LEAVE_TO = '$DATE_LEAVE_TO'";
  $RsLeaveLog = $conn2->Execute($sql);

    $saverec['EMP_NO'] = $EMP_NO;
  $saverec['DATE_LEAVE_FROM'] = $DATE_LEAVE_FROM;
  $saverec['DATE_LEAVE_TO'] = $DATE_LEAVE_TO;
  $saverec['HOURS_LEAVE'] = $HOURS_LEAVE;
  $saverec['TYPE_LEAVE'] = $TYPE;
  $saverec['STATUS_LEAVE'] = $Approve;
  $saverec['DATE_PROCESS'] = $today;

  $insertSQL = $conn2->GetInsertSQL($RsLeaveLog, $saverec);
  $conn2->Execute($insertSQL);
  }

session_write_close();
header("Location:LeaveEmp.php");
exit();
?>

And here is the LeaveForm.tpl

<script>
window.onload = function() {

  var ul = document.getElementById('searchpayroll');
  var links = ul.getElementsByTagName('a');
  var i = 0;

document.onkeyup = function(e){

e = window.event || e;

   var key = e.charCode || e.keyCode;

     if (key == 40) {

      if (i < links.length - 1) i++;
        links[i].focus();
    }
    else if (key == 38) {
      if (i > 0) i--;
      links[i].focus();
    }

}
}

function ApproveLeaveOP(){
    var EMP_NO = document.getElementById('EMP_NO').value;
    var DATE_LEAVE_FROM = document.getElementById('DATE_LEAVE_FROM').value;
    var DATE_LEAVE_TO = document.getElementById('DATE_LEAVE_TO').value;
    var NAME = document.getElementById('NAME').value;
    var HOURS_LEAVE = document.getElementById('HOURS_LEAVE').value;
    var Approve = document.getElementById('Approve').value;
    var TYPE = document.getElementById('TYPE').value;
    var dateprocess = document.getElementById('dateprocess').value;
    var H = document.getElementById('H').value;
    document.sampleform.action="AddLeave.php?EMP_NO="+EMP_NO+"&DATE_LEAVE_FROM="+DATE_LEAVE_FROM+"&DATE_LEAVE_TO="+DATE_LEAVE_TO+"&NAME="+NAME+"&HOURS_LEAVE="+HOURS_LEAVE+"&Approve="+Approve+"&TYPE="+TYPE+"&dateprocess="+dateprocess+"&H="+H;
    document.sampleform.submit();
}
</script>
<script type="text/javascript" src="op_from_date_leave.js">
</script>
<script type="text/javascript"  src="op_from_date_leave_conf2.js"></script>

<div id="Search">
<form>
<p class="serif"><b>Search Lastname:</b></p>
<input type="text" name="search_" size="20" onkeyup="searchEmpLeaveOP(this.value);">
<div>

<hr />
<ul id="searchpayroll" style="overflow:auto; height:380px; width:100%; margin-left:2px;">
{section name=co_emp loop=$personalAll}
<li><a href="LeaveData.php?queryEmpID={$personalAll[co_emp].EMP_ID}">{$personalAll[co_emp].FULLNAME}</a></li>

<hr />
{sectionelse}
<li>No records found</li>
{/section}
</ul>
</div>
<div id="EmpOTForm">
<fieldset>
<legend>Overtime and Leave Form</legend>
<input type="button" name="OTbtn" value="Overtime" onclick="OtFrmOP()")>
<input type="button" name="Leavebtn" value="Leave" onClick="LeaveOP()">

<p class="serif">
<label id="LeaveEmpIDLabel">EMP ID</label><label id="LeaveNameLabel">NAME</label><label id="FromLeave"><a href="Javascript:showCal('RegCalendar1')">FROM DATE </a></label><label id="DaysLabel"><a href="Javascript:showCal('RegCalendar2')">TO DATE</a></label><label id="TypeLeave">LEAVE TYPE</label><label id="HLeave">H</label>
<input type="text" name="EMP_NO" id="EMP_NO" value="{$empno}" size="8" >
<input type="text" name="NAME" id="NAME" value="{$fullname}" size="35" >
<input type="text" name="DATE_LEAVE_FROM" id="DATE_LEAVE_FROM" value="{$DATE_LEAVE_FROM}" size="9">
<input type="text" name="DATE_LEAVE_TO" id="DATE_LEAVE_TO" value="{$DATE_LEAVE_TO}" size="9">

{html_options id=TYPE name=TYPE options=$LeaveStatus selected=$TYPE style="width:140px;"}
<input type="checkbox" name="H" id="H" value="">
<input type="button" name="Approve" value="Approve" id="Approve" onclick="ApproveLeaveOP()">
<input type="button" name="Edit" value="Edit" id="Edit" onclick="EditLeaveOP()">
<input type="hidden" name="dateprocess" id="dateprocess" value="{$dateprocess}">
</p>
<input type="hidden" id="HOURS_LEAVE">
</fieldset>
<div>
<p>
<table border="1" class="stat" width="auto">
<tr>
<th>EMP ID</th>
<th>NAME</th>
<th>FROM DATE</th>
<th>TO DATE</th>
<th># of HOURS</th>
<th>TYPE</th>
<th>STATUS</th>
</tr>
{section name=att loop=$getleave}
  <tr>
    <td id = "EMPNO">{$getleave[att].EMP_NO}</td>
    <td >{$getleave[att].FULLNAME}</td>
    <td id = "DATE_LEAVE" onclick="opleave_edit('{$getleave[att].DATE_LEAVE_FROM}')">{$getleave[att].DATE_LEAVE_FROM}</td>
    <td >{$getleave[att].DATE_LEAVE_TO}</td>
    <td >{$getleave[att].HOURS_LEAVE}</td>
    <td >{$getleave[att].TYPE_LEAVE}</td>
    <td >{$getleave[att].STATUS_LEAVE}</td>
  </tr>
{/section}

</table>
</p>

</form>
</div>
</div>
</div>

I attach the sample form.

Thank you

If Statment Condition

Similar Tutorials

View Content

this code works fine if the conditions are absolute ( pass, fail or empty). im trying to make the fail work if its part of the query. ive tried %fail% but didnt work.

$choice = strtoupper($rows['comments']);
if($choice == "PASS"){
$bgc = "#ff25f0" ; }
elseif($choice == "FAIL"){
$bgc = "#666666" ;
}else{
$bgc = "#FF6600" ; }

If Else Double Condition Using &&

Similar Tutorials

View Content

Can someone please tell me what i have got wrong here?

I am trying to return value C if conditions a AND B are met or return value D. Not sure if its parenthesis or something else?

<?php if (($row_Recordset4['multidirection']=="yes") &&
($_POST["widthcheck"] < $row_Recordset4['drop'])) echo $row_Recordset4['width'];else echo $row_Recordset4['drop'] ?>

Thanks

If 2 Varibles Are True

Similar Tutorials

View Content

hi i have set 2 varibles, and want to echo them out if they are true, i have this script but doesnt work, please help.
<?php
$month=$_GET['month'];
$year=$_GET['year'];

If($year!=0 && $month!=0)
{
echo $month;
echo $year;

}
?>

cheers matt

True And False Or 1 And 0?

Similar Tutorials

View Content

Just a silly question. I've been using 1 and 0 to tell if something is true or false, such as if a feature is enabled or not. I see that some use the words true and false. Is there a proper way or is either way correct? Thanks!

Sort And Paging With Where Condition

Similar Tutorials

View Content

Hello everybody, i have page called cat.php $cat_name get the data submited from othe .php page see line 77 this page show records WHERE category='$cat_name' see line 78 i have 2 problems: first problem: if i dont have this "where" condition, the sort function works fine see line 74 second problem: if i dont have this "where" condition, the paging function works fine see line from 108 here is my code thank you very much for your help Rafal

<html>
<head>
<title></title>
</head>
<body>
<?php>
include("config.php");
?>
<?php
$verbindung1 = mysql_connect("$hoster", "$nameuser", "$password")
or die ("connection error");
mysql_select_db("$basedata")
or die ("database error");
$abfrage = "SELECT cat_id, cat_name FROM $table3 ORDER BY cat_name ASC";
$ergebnis = mysql_query($abfrage);
$num = mysql_num_rows($ergebnis);
?>
<table>
<tr>
<?php
while ($row = mysql_fetch_object($ergebnis))
{
?>
<td>
<font face="Arial" size="2">
<form action="cat.php" method="post" name="cat_form" id="cat_form">
<input type="hidden" name="inp_cat_name" value="<?php echo $row->cat_name; ?>">
<input type="submit" value="<?php echo $row->cat_name; ?>">
</form>
</font>
</td>
<?php
}
?>
</tr></table>
<?php>
include("config.php");
?>
<?Php
try
{
$dbo = new PDO('mysql:host=db.abcdef.fr;dbname='.$basedata, $nameuser, $password);
}
catch (PDOException $e)
{
print "Error!: " . $e->getMessage() . "<br/>";
die();
}
$page_name="cat.php"; // page name
@$sort=$_GET['sort'];
if(strlen($sort)>0 and !ctype_alnum($sort))
{ 
echo "Data Error";
exit;
}
@$start=$_GET['start'];
if(strlen($start) > 0 and !is_numeric($start))
{
echo "Data Error";
exit;
}
$zero = ($start - 0); 
$limit = 20; // number of rows per page
$this1 = $zero + $limit; 
$back = $zero - $limit; 
$next = $zero + $limit;
$query2=" SELECT destination, stars, price FROM $table1 WHERE vis='yes'";
$count=$dbo->prepare($query2);

$count->execute();
$nume=$count->rowCount();
?>
<font face="Arial" size="2">Sortieren nach:<br>
<?php echo "<a href='$page_name?sort=destination'>Zielort</a>"; ?> | <?php echo "<a href='$page_name?sort=stars'>Sterne</a>"; ?> | <?php echo "<a href='$page_name?sort=price'>Preis</a>"; ?><br><br>
</font>
<?php
$cat_name = $_POST["inp_cat_name"];
$query=" SELECT * FROM $table1 WHERE category='$cat_name'";
if(isset($sort) and strlen($sort)>0){
$query = $query . " order by $sort";
}
$query = $query. " limit $zero, $limit ";
foreach ($dbo->query($query) as $row)
{
?>
<table cellspacing="0" cellpadding="0" border="1" width="600px" class="table">
<tr>
<td rowspan="2" valign="top" class="td">
<img src="<?php if ($row[photo1] != '') { ?><?php echo $row[photo1] ?><?php } ?><?php if ($row[photo1] == '') { ?><?php echo 'cloud/500x282.gif' ?><?php } ?>" width="200" height="113">
</td>
<th width="400px" class="th"><font face="Arial" size="2"><b><?php echo  $row[product] ?></b>
<?php if ($row[stars] == "1") { ?><?php echo "<img src='cloud/star.png'>"; } ?>
<?php echo  $row[destination] ?> (<?php echo  $row[category] ?>)</font></th>
</tr>
<tr>
<td valign="top" class="td" style="padding:7px;">
<font face="Arial" size="2">
<?php echo  $row[shortdesc] ?><br>
from <font size="4"><b><?php echo  $row[price] ?> &euro;</b></font> <font face="Arial" size="1">Nr. <?php echo  $row[inventar] ?></font><br>
<br>
</font>
</td></tr>
</table>
<br>
<?php
}
if($back >=0) { 
echo "<a href='$page_name?start=$back&sort=$sort'><font face='Verdana' size='2'>back</font></a>"; 
} 
echo "&nbsp;";
$i=0;
$l=1;
for($i=0;$i < $nume;$i=$i+$limit){
if($i <> $zero){
echo " <a href='$page_name?start=$i&sort=$sort'><font face='Verdana' size='2'>$l</font></a> ";
}
else { echo "<font face='arial' size='2' color='black'>$l</font>";}
$l=$l+1;
}
echo "&nbsp;";
if($this1 < $nume) { 
echo "<a href='$page_name?start=$next&sort=$sort'><font face='Verdana' size='2'>next</font></a>";} 
?>
</body>
</html>