PHP - Moved: Using A If Condition In A Model

Can a person instantiate a model? If so how do you do it. I already know how to instantiate a class

thank you

Hello

I'm developing a Model-View-Controller framework for my personal learning curve. I've created an active record class and I've got stuck when using variables in a where clause. My problem is this:

When, in a where statement, you want to find the Users with the first name Mike, you might write
SELECT Firstname, Surname FROM Users WHERE Firstname = 'Mike'

Where Mike is enclosed with quotation marks. When you're comparing entities quotation marks shouldn't be used.
For example,

SELECT Firstname, Surname, OrderTitle FROM Users, Orders WHERE Firstname = 'Mike' AND Users.Firstname = Orders.Firstname

So when using variables in my where statements, like

$Name = Mike
$this->Where(Firstname',$Name);
$this->Where('Users.Firstname','Orders.Firstname');

How do I differentiate, in my function Where() when to enclose the string with quotation marks, i.e when it is a (Table.Entity) rather than a constant.

Thank you

Hey all,   I am making a application that requires a user to login in. I have a user model, which does such things as finds, registers, logins in, updates etc a user. It also grabs all of a users data from a database, such as their username, email address etc and checks whether or not a user is logged in.   The problem I face is this. I want to control what content a user can see depending on if they are logged in or not. In addition to this, I want to output the users data, such as their username, in other parts of the website – such as the header and footer. There is no real easy way of doing this, and requires the user model to be instantiated on every page. My question is should this class be a model or just a core library class?

Hi,

I have a cakePHP program that works and displays data from a database table.
The part I dont understand and I couldnt find anything on the cakephp blog as yet was the model was left blank?

q1) The model is left blank but still works so what is the default behaviour here for the model? It doesnt seem to be needed to do anything i?.

q2)I am selecting all the data from 1 table but how do I add  a sql statement to select part of the table or a join of 2 tables? the find 'all' seems to just do that only in finding all data from a table.   <?php
class Post extends AppModel
{
/*var $name='User';*/
}
?>


<?php
class PostsController extends AppController
{
public $helpers=array('Html','Form');

public function index()
{
$this->set('posts',$this->Post->find('all'));
}

public function home()
{
$this->set('posts',$this->Post->find('all'));
}
}
?>

view
///
..
<?php foreach ($posts as $item):
echo '<tr><td>'. $item['Post']['id']. '</td>';
echo '<td>'. $item['Post']['title'].'</td>';
echo '<td>'. $item['Post']['body'].'</td>';

echo '<td>'. $item['Post']['created'] .'</td>';
echo '</tr>';
endforeach;
unset($item);
?>

Hi all, I was just wondering is this possible what I'm trying to do? Models can only store one object at a time... I'm trying to access multiple objects via one model...

<?php

	class users extends Model {
		
		protected $username;
		protected $firstname;
		protected $secondname;
		protected $age;
		// There will be more here...
		
		public function __construct($id = NULL) {
			
			if($id != NULL) {
				
				$this->username = $sql->getUsername($id);
				$this->firstname = $sql->getFirstname($id);
				$this->secondname = $sql->getSecondname($id);
				$this->age = $sql->getAge($id);
				
			}
			
		}
		
		public function numOfUsers() {
			
			$num = $sql->countAllUsers($query);
			
			return $num;
			
		}
		
		public function getUsername() {
			
			return $this->username;
			
		}
		
		public function getFirstname() {
			
			return $this->firstname;
			
		}
		
		public function getSecondname() {
			
			return $this->secondname;
			
		}
		
		public function getAge() {
			
			return $this->age;
			
		}
		
	};
	
	class UsersView extends View {
		
		$users = new users();
		
		for($i = 0; $i < $users->numOfUsers(); $i++) {
		
			$user = new users($i);
			echo "Username: {$user->getUsername()}";
			echo "Username: {$user->getFirstname()}";
			echo "Username: {$user->getSecondname()}";
			echo "Username: {$user->getAge()}";
			
		}
		
	};

?>

Hi Everyone.
I am in need of assistance,
I need a form that i will use on a model agency site i am making, the form i have only has the option to upload one image and records name, age etc... What i need is a form that will upload multiple images, 2 will do but if i had a option to add more that would be great, and a pdf resume, does anyone have a similar form i can have a look at that does this, any help be awesome, i am already over the deadline.

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...

if u use this for one condition

if ($nr > 5)

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

thanks !

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?

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" ; }

<?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' , ?

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

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&nbsp;</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

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

Dear Members,
I am a PHP developer and desisgning a WAP page for mobiles.I need some php code to find out the model of a mobile phone from where request is coming so that based on that information I can upload the proper CSS for my page.If you can give me some hints as well that would also help me to proceed further.Currently I am able to fetch user-agent of mobile but not able to find out the specific model of mobile.