PHP - Another Extremely Simple Problem, This Time Its Fopen()

Hi,

I am modding phpBB3 and I want to make the contents of a text documents appear in a border. This is what I have in my portal_style.html:

Code: [Select]
<!-- INCLUDE overall_header.html -->

<?php
$a1=fopen("/port/announce/announce1.txt", "r");
$a2=fopen("/port/announce/announce2.txt", "r");
$a3=fopen("/port/announce/announce3.txt", "r");
$a4=fopen("/port/announce/announce4.txt", "r");
$a5=fopen("/port/announce/announce5.txt", "r");
?>

<h2>Announcement!</h2>

<div class="panel">
   <div class="inner"><span class="corners-top"><span></span></span>

<div class="content">
    <?php
       echo $a1;
    ?>
   </div>

<span class="corners-bottom"><span></span></span></div></div>
  

<h2>Announcement!</h2>

<div class="panel">
   <div class="inner"><span class="corners-top"><span></span></span>

   <div class="content">
      <?php
      echo $a2;
      ?>
   </div>

   <span class="corners-bottom"><span></span></span></div>
</div>

<!-- INCLUDE jumpbox.html -->
<!-- INCLUDE overall_footer.html -->
Anyone mind showing me how to make it work?

Thanks.

Hi,

I am calling the sms gateway to send sms,



Quote

   
$sms_msg = "hi this is mubarak";
$url = $urlAccount_home."?username=".$userAccount."&password=".$passAccount."&number=".$O_Mobile."&sender=".$userSenderSMS."&msg=".$sms_msg;
      
      
      
         if (!($fp =fopen($url,"r")))
         echo "<br><center>خطا في الاتصال </center><br>";
         $result =fread($fp,10);
         fclose($fp);


when i am sending like this am sending only the message "Hi"

I am not getting the whole message...

What might be the problem in sending the sms gateway..

Please help me if you guys came to know,

Thanks and Regards,
Mubarak

Hi,
I was using latest php5 but as I couldn't find a ffmpeg-php extension for it, I actually swapped to latest php4, and now I'm having a problem when using fopen for urls, when it's used it just stops the script with no error / warning, i tried using the same php.ini used with my php5 too but it changes nothing.
Btw allow_url_fopen is enabled.
Thanks if someone can help.

So I am tryting to create a script to upload a CSV file into a MySql DB. It has like 10K records into SQL   My Code is copy below ...   I get the following errors.   Line 16 is the $handle line 18 is the While Statement   Error: Warning: fopen(): Filename cannot be empty in C:\local\htdocs\ADPStorage\DemandCSV.php on line 16

Warning: fopen()expects parameter 1 to be resource, boolean given in C:\local\htdocs\ADPStorage\DemandCSV.php on line 18       I use my script for another table and it worked like a charm. Less data and less colums do.   Bad Code: (good Code sample below. this one)

<?php

$today = date("m.d.y.h.m.s");                       
echo $today;

$BPTD_fy = '2014';
$BPTD_updatedate = $today;

  $conn = mysql_connect("Localhost","root","password") or die (mysql_error());
  mysql_select_db("ds_storage",$conn);
  
	if(isset($_POST['submit']))
	{
		$file = $_FILES['file']['tmp_name'];
		  
		  $handle = fopen($file, "r");
		
		while(($fileop = fgetcsv($handle, 100000, ",")) !==FALSE)
		{
			$BPTD_fy = $fileop[0];
			$BPTD_Status = $fileop[1];
			$BPTD_Classification = $fileop[2];
			$BPTD_ProcureCat = $fileop[3];
			$BPTD_Product = $fileop[4];
			$BPTD_Project = $fileop[5];
			$BPTD_DSCategory = $fileop[6];
			$BPTD_Calculated = $fileop[7];
			$BPTD_CapacityType = $fileop[8];
			$BPTD_Amount = $fileop[9];
			$BPTD_Jul = $fileop[10];
			$BPTD_Aug = $fileop[11];
			$BPTD_Sep = $fileop[12];
			$BPTD_Oct = $fileop[13];
			$BPTD_Nov = $fileop[14];
			$BPTD_Dec = $fileop[15];
			$BPTD_Jan = $fileop[16];
			$BPTD_Feb = $fileop[17];
			$BPTD_Mar = $fileop[18];
			$BPTD_Apr = $fileop[19];
			$BPTD_May = $fileop[20];
			$BPTD_Jun = $fileop[21];
			$BPTD_Location = $fileop[22];
			$BPTD_Env = $fileop[23];
			$BPTD_Requester = $fileop[24];
			$BPTD_ServiceArea = $fileop[25];
			$BPTD_ServiceGroup = $fileop[26];
			$BPTD_DepHead = $fileop[27];
			$BPTD_Recgroup = $fileop[28];
			$BPTD_RecOwner = $fileop[29];
			$BPTD_Entrydate = $fileop[30];
			$BPTD_updatedate = $fileop[31];
			
			
			$sql = mysql_query("INSERT INTO inv_bpt_demand (Status, Classification, ProcureCat, Product, Project, DSCategory, Calculated, CapacityType, Amount, Jul, Aug, Sep, Oct, Nov, Dec, 
			Jan, Feb, Mar, Apr, May, Jun, Location, Env, Requester, ServiceArea, ServiceGroup, DepHead, Recgroup, RecOwner, Entrydate, updatedate) 
			
			VALUES ('$BPTD_Status', '$BPTD_Classification', '$BPTD_ProcureCat', '$BPTD_Product', '$BPTD_Project', '$BPTD_DSCategory', '$BPTD_Calculated', '$BPTD_CapacityType', '$BPTD_Amount',
			'$BPTD_Jul', '$BPTD_Aug', '$BPTD_Sep', '$BPTD_Oct', '$BPTD_Nov', '$BPTD_Dec', '$BPTD_Jan', '$BPTD_Feb', '$BPTD_Mar', '$BPTD_Apr','$BPTD_May', '$BPTD_Jun','$BPTD_Location',
			'$BPTD_Env','$BPTD_Requester', '$BPTD_ServiceArea', '$BPTD_ServiceGroup','$BPTD_DepHead', '$BPTD_Recgroup','$BPTD_RecOwner','$BPTD_Entrydate','$BPTD_updatedate')");
			
			if($sql)
			{
			echo 'Data Uploaded Successfully';
			
			}
		}
	}
  
?>

<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="utf-8">
  <title>BPT Demand CSV</title>
  <link rel="stylesheet" type="text/css" href="file:///C|/local/htdocs/style/style.css" />
  <script type="text/javascript" src="//ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js"></script>
</head>
<body>
  <div id="mainWrapper">

    <form method="post" action="https://localhost/Storage/DemandCSV.php" enctype="multipart/form-data">
        <input type="file" name="file" />
        <br />
        <input type="submit" name="submit" value="Submit" />
    </form>
    
  </div><!--end mainWrapper-->
</body>
</html>

Similar Working code (good)

<?php
  $conn = mysql_connect("Localhost","root","password") or die (mysql_error());
  mysql_select_db("ds_storage",$conn);
  
	if(isset($_POST['submit']))
	{
		$file = $_FILES['file']['tmp_name'];
		  
		  $handle = fopen($file, "r");
		
		while(($fileop = fgetcsv($handle,1000,",")) !==FALSE)
		{
			
			$PC_Num = $fileop[0];
			$PC_Name = $fileop[1];
			$PC_BPTNUM = $fileop[2];
			$PC_busclass = $fileop[3];
			$PC_Note = $fileop[4];
			$PC_Acro = $fileop[5];
			$PC_type = $fileop[6];
						
			///echo $fileop[1];
			$sql = mysql_query("INSERT INTO inv_names (PC_Num, PC_Name, PC_BPTNUM, PC_busclass, PC_Note, PC_Acro, PC_type) 
			VALUES ('$PC_Num', '$PC_Name', '$PC_BPTNUM', '$PC_busclass', '$PC_Note', '$PC_Acro', '$PC_type')");
			
			if($sql)
			{
			echo 'Data Uploaded Successfully';
			
			}
		}
	}
  
?>

<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="utf-8">
  <title>Upload CSV</title>
  <link rel="stylesheet" type="text/css" href="file:///C|/local/htdocs/style/style.css" />
  <script type="text/javascript" src="//ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js"></script>
</head>
<body>
  <div id="mainWrapper">

    <form method="post" action="https://localhost/Storage/Storage_CSV.php" enctype="multipart/form-data">
        <input type="file" name="file" />
        <br />
        <input type="submit" name="submit" value="Submit" />
    </form>
    
  </div><!--end mainWrapper-->
</body>
</html>

Please help and thx in advance   ~J

I'm trying to convert the following time stamp: 12:03PM to military time 13:03.

I'm using the following code, but it's just outputing 12:03:
$sampledate=("2010-11-08, 12:03PM CST");

$xplodeDateStamp = explode(", ", $sampledate);
$xplodeDate = $xplodeDateStamp[0];
$xplodeTime = $xplodeDateStamp[1];
echo "Date: " . $xplodeDate . "<br>";
echo "Time: " . $xplodeTime . "<br>";
echo "Military Time: " .  date("H:i",strtotime("$xplodeTime"));

I have read almost every forum post I could find on this subject and still couldnt find what I am looking for.

What I need this program to do is allow an employee to punch in and punch out as often as needed. Then I need to be able to calculate the total time they were punched in for that day.

This is what I currently have set up.

The Database
id(auto inc) -- employee -- date -- time

Once the employee logs in I have a button they can click which will create a record in the database. What I need is to be able to do is run a mysql_query and show their total time.

I know there is still a lot left to script and code still. But I wanted to know if I am on the right track with the database. I wasnt sure if I should have two buttons "clock in" and "clock out" and record them in different columns, or if having one column for both clock in and out was sufficient for calculating hours.

I do not need the ability to change hours for an admin because I will be able to manually go into the database if need be. What I do need is to be able to keep this records so that you can look at past weeks.

<?php 
$user = $_SESSION['myusername'];
$result = mysql_query("SELECT * FROM hours WHERE member='$user'");

while ($row = mysql_fetch_array($result)){
echo $row['date'] . " " . $row['time'] . "<br />";
}die (mysql_error());

?>

This is what I currently have just to display all the records from the logged in user. I need to be able to subtract time and organize by date then by week.

Any help will be appreciated.

Thanks in advance.

Hi

I have a simple idea for a webapp I would like to pay someone to develop for my small business.

It's a system for tracking "one off" orders we get.

Basically at the moment we use paper notes. Problems with this:-

- They get lost
- In 6 months time if the customer wants to reorder, you have to take the customer's details again, which isn't very professional
- If I remember I've taken an order for something I can't do anything about it (i.e. let my colleagues know) until I'm next at work.
etc etc

I wanted built a web app (basically a webpage front end to a as yet non-existent database) which would allow us to log these items and then have a search/query function where we would look through:-
"open orders" "closed orders" "orders awaiting collection" etc
  offers to mefijob@forward.cat   thanks!

 
I'm calling a function that resets a couple arrays:


public function resetStuff() {
$this->someArray = array();
$this->someOtherArray = array();
}

However, someOtherArray is not resetting!! How could that be?

I can add debug statements to echo the size of the arrays before and after the function calls. It shows that:
someArray went from n to 0
someOtherArray went from n to n

How is that possible??

We are toying with the idea of using PHP to do sorting instead of our database to reduce load and scale. Basically what we would have is multidimensional arrays that are resturned from the SQL engine and we will need to sort them on a specific key in PHP. We have written this functionality, but are looking to make it faster ANYWAY possible. Do you guys see anyway to speed up this code, without throwing more hardware at the problem yet? Currently on our test server this code takes approx 2.4 - 2.6 seconds to execute. We would love others to try this code and report what it takes them to execute. We are shooting for sub 1 second time.

Code: [Select]
$array = array();
$temp = array();
for($i = 0; $i < 100000; $i++) {
$temp['id'] = rand(10000, 99999);
$temp['history_id'] = rand(100000000, 999999999);
$array[] = $temp;
}


////
// Start timer
////
$mtime = microtime();
$mtime = explode(" ",$mtime);
$mtime = $mtime[1] + $mtime[0];
$starttime = $mtime;

////
// Actual sort
////
usort($array, function($a, $b) {
//Compare numbers
if ($a['history_id'] == $b['history_id']) { return 0; }
return ($a['history_id'] < $b['history_id']) ? -1 : 1;
});

////
// End timer
////
$mtime = microtime();
$mtime = explode(" ",$mtime);
$mtime = $mtime[1] + $mtime[0];
$endtime = $mtime;
$totaltime = ($endtime - $starttime);

////
// Output execution time
////
echo "Executed in: <strong>". $totaltime ."</strong> seconds.";

Hi..


I got an issue in getting the total time.

I have this code to get the sum of total time:

Code: [Select]
$result = mysql_query("INSERT INTO payroll.casual_hours(EMP_NO, Hours) SELECT EMP_NO, sec_to_time(SUM(time_to_sec(Rendered))) FROM payroll.casual_att WHERE DATE_FORMAT(LOGOUT, '%W') IN ('Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday') GROUP BY EMP_NO") or die(mysql_error());

Rendered:
09:00:00
09:00:00
09:00:00
08:00:00
08:00:00
07:48:00

and the result of this is 50:48

but I need result is 50:80

the minutes is divided to 60

Is there any way to get the 50:80 result.


Thank you so much..

Hey all i am attempting to connect to a ftp address and display the contents of a file into a textarea and i keep getting errors is there something wrong with the code or the ftp server?


<?php
    $log_file= "ftp://username:password@68.232.164.100/czero/68.232.164.100:27015/czero/gsconsole.log"; 
    $log_handle = fopen($log_file, "r"); 
    $log_contents = fread($log_handle, filesize($log_file)); 
    fclose($log_handle);
?>
Console Log:
<textarea name="log_view" cols="110" rows="20" readonly="readonly" wrap="virtual"><?php echo "$log_contents" ; ?></textarea>

I'm having trouble connecting through fopen using variables as the login details, but with file_get_content it works fine?!

These are my variables:-


$ftpaddy="ftp.mydomain.com";
$username="me";
$password="password";

$editingdir="/public_html/edit/";
$editfile="editme.txt";


$myftppath = "ftp://" . $username . ":" . $password . "@" . $ftpaddy . $editingdir . $editfile; //puts all variables into string


When I try to connect and read the file using the following method it works fine:-

$file = file_get_contents("$myftppath", "r");

but when i try and use the same string with fopen as below it doesn't work?!

the line i have commented out however works and when i echo the $myftppath variable below it looks the same.. i don't really get it!



//$myftppath = "ftp://me:password@ftp.mydomain.com/public_html/edit/editme.txt";
$myftppath = "ftp://" . $username . ":" . $password . "@" . $ftpaddy . $editingdir . $editfile; //puts all variables into string
$stream_options = array('ftp' => array('overwrite' => true));
$stream_context = stream_context_create($stream_options);

if ($fh = fopen($myftppath, 'w', 0, $stream_context)){//fopen only likes the commented out $myftppath not the one using the variables?!
fputs($fh, $newcontents);
fclose($fh);
} else {
die('Could not open file.');
}


does anyone know if I am doing the syntax wrong and how to correct it? I read I may need to put another slash after domain.com but this didn't help either.
any help would be much appreciated!
thanks in advance
Kev.

Hey all, my doubt is the following:

Is there a way of opening files (images,pdf's,etc) in a popup window?

What I intend to do, is have a button, that when pressed, would acess and open certain files in a popup window.

I already know how to acess and download the files, but I would like to know how to open them inside the browser.

sorry for the bad English. Hope you understood and can help.

Thanks alot, Ruben

So the code works right, (I think)  but for some reason the way I built it the logic comes back null.

I can do All w a specific shift/s, and All with department/s but I can't do All shifts and All departments
it doesn't' error either, just brings back nothing, maybe timing out?


I'm very new at this so I apologize in advance.



Code below
############################################################
<form method="post" action="">
<br><br>
<table bordercolor="yellow" border="2">
 
<tr><td class="line"><b>Start Date:</b></td><td>
<input type="text" name="startdate" value="mm/dd/yyyy" /></td></tr>
</tr>
<tr><td class="line"><b>End Date:</b></td><td>
<input type="text" name="enddate" value="mm/dd/yyyy"  /></td></tr>
</tr>

<tr><td class="line"><b>Shift:</b></td><td>
         <SELECT NAME="shift" >
      <option selected>Select Shift</option>
     <option>First</option>
     <option>Second</option>
     <option>Third</option>
     <option>All</option>
      </SELECT> </td></tr>
     
<tr><td class="line"><b>Department:</b></td><td>
         <SELECT NAME="department" >
      <option selected>Select Department</option>
     <option>Advanced Hosting Support</option>
     <option>Server Support</option>
     <option>Managed Support</option>
     <option>All</option>
      </SELECT> </td></tr>
</tr>   
</tr>
</table>

<br><br>
<input type="submit" value="submit" />
</form>
<form action="" method="post">

</form>

</html>


<?php
require_once('global.inc.php');

   
class DataLogic
{
//function to obtain Employee names from RealID array to pass to MSSQL for call count

function GetEmpNames ($RealID)
{
   global $ems_db_connect;
   
   
foreach ($RealID as $emplist){

$query1 = mysql_query ("SELECT FirstName, LastName
                     FROM ems_employee_list
                  WHERE RealID=$emplist", $ems_db_connect) or die(mysql_error());;

while($row = mysql_fetch_array($query1))
                  {
                     $FirstName[] = $row['FirstName'];
                     $LastName[] = $row['LastName'];
                  }
                  
}
$friendlyname = array('first_name' => $FirstName, 'last_name' =>$LastName);
return $friendlyname;            
}
                  
//function to display Employee names from RealID array obtained from department and shift

function DisplayEmpNames ($RealID)
{
   global $ems_db_connect;
   
   
foreach ($RealID as $emplist){

$query1 = mysql_query ("SELECT FirstName, LastName
                     FROM ems_employee_list
                  WHERE RealID=$emplist", $ems_db_connect) or die(mysql_error());;

while($row = mysql_fetch_array($query1))
                  {
                     $FirstName = $row['FirstName'];
                     $LastName = $row['LastName'];
                     $fullname[] = "$LastName, $FirstName";
                  }
                  
}
return $fullname;
}

//function to pull the RealID's of Employees based on shift
//Returns a list of RealID's for use with GetIris and RepSort functions
function SelectEmpShift ($key)
{
global $ems_db_connect;


switch($key)
      {
         case "First":
            $shift = 1;
            break;
            
         case "Second":
            $shift = 2;
            break;
         
         case "Third":
            $shift = 3;
            break;
            
         default:
            $shift = 4;
         
      }   
if ($shift == 4){

   $query1 = mysql_query ("SELECT RealID
                     FROM ems_employee_list
                     LEFT JOIN ems_employee_schedules
                     USING (EmployeeID)
                     WHERE RealID > 0 AND Department='AHS'", $ems_db_connect) or die(mysql_error());
 
   while ($row = mysql_fetch_array($query1))
         {
         $x[]=$row['RealID'];
         }
            }

else {
      $query1 = mysql_query ("SELECT RealID
                           FROM ems_employee_list
                           LEFT JOIN ems_employee_schedules
                           USING (EmployeeID)
                           WHERE RealID > 0 AND Shift = $shift AND Department ='AHS'", $ems_db_connect);
                  
                  

      while ($row = mysql_fetch_array($query1))
         {
         $x[]=$row['RealID'];
         }
   }

return $x;
}

//Function to Select Employees based on Department
function SelectEmpDep ($key)
{
global $ems_db_connect;


switch($key)
      {
         case "Managed Support":
            $deptcode = 6;
            break;
            
         case "Server Support":
            $deptcode = 5;
            break;
         
         case "Advanced Hosting Support":
            $deptcode = 2;
            break;
            
         default:
            $deptcode = 7;
         
      }   
if ($deptcode == 7){
   
   $query1 = mysql_query ("SELECT RealID
                     FROM ems_employee_list
                     LEFT JOIN ems_employee_schedules
                     USING (EmployeeID)
                     WHERE RealID > 0 AND Department='AHS'", $ems_db_connect) or die(mysql_error());
 
   while ($row = mysql_fetch_array($query1))
         {
         $x[]=$row['RealID'];
         }
               }

elseif ($deptcode == 5){


   $query1 = mysql_query ("SELECT RealID
                     FROM ems_employee_list
                     LEFT JOIN ems_employee_schedules
                     USING (EmployeeID)
                     WHERE RealID > 0 AND AccessID=5 OR AccessID=3 AND Department='AHS' AND RealID >0", $ems_db_connect) or die(mysql_error());
 
   while ($row = mysql_fetch_array($query1))
         {
         $x[]=$row['RealID'];
         }
                  }

else {

      $query1 = mysql_query ("SELECT RealID
                           FROM ems_employee_list
                           LEFT JOIN ems_employee_schedules
                           USING (EmployeeID)
                           WHERE RealID > 0 AND AccessID=$deptcode AND Department ='AHS' ", $ems_db_connect);
                  
                  
      
      while ($row = mysql_fetch_array($query1))
         {
         $x[]=$row['RealID'];
         }

   }

return $x;
}


//function to sort Shift by multiple Deparments
function RepSortShiftDept ($RealIDShift, $RealIDDepartment='', $RealIDDepartment2='')

{
   $deptnumber = func_num_args();
   
      if ($deptnumber == 1)
         {
         
            $result = $RealIDShift;
         }
   
      elseif ($deptnumber == 2)
         {

            $result = array_intersect($RealIDShift, $RealIDDepartment);
         }
   
      else {
            $result = array_intersect($RealIDShift, array_merge($RealIDDepartment, $RealIDDepartment2));
         }

   return $result;
}

//function to sort Department by multiple Shifts
function RepSortDeptShift ($RealIDDepartment, $RealIDShift='', $RealIDShift2='')

{
      $shiftnumber = func_num_args();
   
      if ($shiftnumber == 1)
         {
         
            $result = $RealIDDepartment;
         }
   
      elseif ($shiftnumber == 2)
         {

            $result = array_intersect($RealIDDepartment, $RealIDShift);
         }
   
      else {
            $result = array_intersect($RealIDDepartment, array_merge($RealIDShift, $RealIDShift2));
         }

   return $result;

}


//Function to get and display count of Iris tickets from a date rage.
//$RealID needs to be an array of EmployeeIDs obtained from SelectEmpShift, SelectEmpDepart, and RepSort functions
function GetIris($RealID, $startdate, $enddate)
{
global $hocstat_db_connect;

foreach ($RealID as $emplist){

$mssqlquery = "SELECT COUNT (IncidentID) AS mycount
            FROM hocstats.dbo.DailyStatsEmployee
            WHERE hocstats.dbo.DailyStatsEmployee.EmployeeID=$emplist      
            AND(hocstats.dbo.DailyStatsEmployee.DateModified
            BETWEEN '$startdate 00:00:00.000' AND '$enddate 23:59:59.000')";
                                       
                  $query_3 = mssql_query ($mssqlquery,                              $hocstat_db_connect);                   
                     $row =(mssql_fetch_array($query_3)) ;
                     $iriscount[] = $row['mycount'];
}
return $iriscount;
}


//Function to get and display call counts from a date range. For use with GetEmpName ONLY
function GetCalls ($friendlyname, $startdate, $enddate)
{
global $hocstat_db_connect;

for ($x = 0; $x < count ($friendlyname['last_name']); $x++)
   {

$query1 ="SELECT ISNULL(SUM(CallsHandledToHalf), 0) AS calls
                  FROM Agent_Skill_Group_Half_Hour ASGHH WITH (NOLOCK)
                  INNER JOIN dbo.agent ON ASGHH.skilltargetid = dbo.agent.skilltargetid
      WHERE(dbo.agent.enterprisename = 'HOC_{$friendlyname['last_name'][$x]}_{$friendlyname['first_name'][$x]}'
      OR dbo.agent.enterprisename = '{$friendlyname['last_name'][$x]}_{$friendlyname['first_name'][$x]}')
                  AND (ASGHH.datetime BETWEEN '$startdate 00:00:00' AND '$enddate 23:59:00')";
                  
                  $mssqlquery = mssql_query ($query1, $hocstat_db_connect);
                  
while ($row =(mssql_fetch_array($mssqlquery)))
                     {                                                                                                                                                                                                                                                                                                                  
   $callcount[] = $row['calls'];   
}               
   
   }
return $callcount;   
}

}//class close


if($_POST)
//setting varibles from form input
{   
   
   $shift_id= isset($_POST['shift']) ? trim($_POST['shift']) : die('Missing entry: Shift Selection');
   $start_date= isset($_POST['startdate']) ? trim($_POST['startdate']) : die('Missing enty: Start Date');
   $end_date= isset($_POST['enddate']) ? trim($_POST['enddate']) : die('Missing enty: End Date');
   $depart_id= isset($_POST['department']) ? trim($_POST['department']) : die('Missing entry: Shift Selection');
   
}


echo "You have selected stats for $shift_id shift(s) and $depart_id department(s) from $start_date to $end_date. </br>" ;

$test=new DataLogic();

$calls = $test->GetCalls($test->GetEmpNames($test->RepSortShiftDept($test->SelectEmpShift("$shift_id"), $test->SelectEmpDep("$depart_id"))), $start_date, $end_date);


$iris= $test->GetIris ($test->RepSortShiftDept($test->SelectEmpShift("$shift_id"), $test->SelectEmpDep("$depart_id")), $start_date, $end_date);

$name= $test-> DisplayEmpNames($test->RepSortShiftDept($test->SelectEmpShift("$shift_id"), $test->SelectEmpDep("$depart_id")));

$table = array ( 'calls' => $calls, 'iris' => $iris, 'name' => $name);

for ($x = 0; $x < count ($table['calls']); $x++)
   {    
      echo $table["name"][$x];
      echo "</br> Calls Taken :";
      echo $table["calls"][$x];
      echo "</br> Iris Tickets Resolved:";
      echo $table["iris"][$x];
      echo "</br>";
   
   }

?>

ok so im wondering if you all could prob fix this code its not working and when "meta"when it refreshes the page nothing deletes

Code: [Select]
<?php
$host="localhost"; // Host name
$username="username"; // Mysql username
$password="password"; // Mysql password
$db_name="database name"; // Database name
$tbl_name="table name"; // Table name
// below was a replie from forums. it made alot of problems//

foreach($_POST['checkbox'] AS $ID) {
      $values[] = '\''.intval($ID).'\'';
    }

    $values = implode(' , ',$values);

    $myQuery = "DELETE FROM $tbl_name WHERE id IN ($values)";

    if(mysql_query($myQuery)) {
      header('Location: delete_multiple.php');
    } else {
      echo 'Query failed: "'.$myQuery.'"';
    }

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);

$count=mysql_num_rows($result);


?>
<style>
/*table affects look of the whole table look */
table {
margin-left: auto;
margin-right: auto;
border: 1px solid #330000;
border-collapse:collapse;
width:70%;

border-width: 5px 5px 5px 5px;
border-spacing: 1px;
border-style: outset outset outset outset;
border-color: #330000 #330000 #330000 #330000;
border-collapse: separate;
background-color: #330000;


#800517

f535aa

#330000 school color
#9A0000 school color2
#991B1E school color3
#CCCC99 school color4
#9A0000

}
/*th is table header */
th {
text-align: left;
height: 2.5em;
background-color: #330000;
color: #FC0;
font-size:1.5em;
}
/*td is table data or the cells below the header*/
td {
text-align: left;
height:1.0em;
font-size:1.0em;
vertical-align:bottom;
padding:10px;

border-width: 5px 5px 5px 5px;
padding: 8px 8px 8px 8px;
border-style: outset outset outset outset;
border-color: #9A0000 #9A0000 #9A0000 #9A0000;
background-color: #CCCC99;
-moz-border-radius: 0px 0px 0px 0px;

}
</style>
<table width="400" border="0" cellspacing="1" cellpadding="0">
<tr>
<td><form name="form1" method="post" action="">
<table width="400" border="0" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td bgcolor="#FFFFFF">&nbsp;</td>
<td colspan="4" bgcolor="#FFFFFF"><strong>Pick Which Rows you want to delete, Then press delete.</strong> </td>
</tr>
<tr>
<td align="center" bgcolor="#FFFFFF"><strong>Id</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Name</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Lastname</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Email</strong></td>
<td align="center" bgcolor="#FFFFFF">delete</td></tr>
<?php
while($rows=mysql_fetch_array($result)){
?>
<tr>
<td bgcolor="#FFFFFF"><? echo $rows['id']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['name']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['lastname']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['email']; ?></td>
<td align="center" bgcolor="#FFFFFF"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<? echo $rows['id']; ?>"></td>
</tr>
<?php
}
?>
<tr>
<td colspan="5" align="center" bgcolor="#FFFFFF"><input name="delete" type="submit" id="delete" value="Delete"></td>
</tr>
<?php
// Check if delete button active, start this // edited


if($delete){
for($i=0;$i<$count;$i++){
$del_id = $checkbox[$i];
$sql = "DELETE FROM $tbl_name WHERE id='$del_id'";
$result = mysql_query($sql);
}

// if successful redirect to delete_multiple.php
if($result){
echo "<meta http-equiv=\"refresh\" content=\"0;URL=delete_multiple.php\">";
}
}
mysql_close();
?>
</table>
</form>
</td>
</tr>
</table>


 this is whats wrong with it could i get some help?



Warning: Invalid argument supplied for foreach() in /home/sumersadl/public_html/testfile/delete_multiple.php on line 8

Warning: implode() [function.implode]: Invalid arguments passed in /home/sumersadl/public_html/testfile/delete_multiple.php on line 12

Warning: mysql_query() [function.mysql-query]: Access denied for user 'root'@'localhost' (using password: NO) in /home/sumersadl/public_html/testfile/delete_multiple.php on line 16

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/sumersadl/public_html/testfile/delete_multiple.php on line 16
Query failed: "DELETE FROM test_mysql WHERE id IN ()"