PHP Help ...., Askquestions Php Questions

Home Tutorialhelp Comment PHP help ....

Comment

pree

PHP help ....,
March 29, 2010 at 1:16 PM

The table in phpmyadmin database having fields as follows:

Loguser, date, time, action (kommen OR gehen), IP address.

Loguser Account Date Time Action IP address
User1 Employee 2010-02-26 11:40:36 Coming 127.0.0.1
User1 Employee 2010-02-26 12:50:26 Gehen 127.0.0.1
User1 Employee 2010-02-26 12:30:00 Coming 127.0.0.1
User2 Admin 2010-02-27 09:40:00 Coming 129.0.0.1

I am getting the output as:
For User1

Date Kommen Gehen
2010-02-26 11:40:36 12:50:26 12:30:00

I want output in the form of HTML table as below :

Date Kommen Gehen
2010-02-26 11:40:36 12:50:26
12:30:00

My code for above programme is as follows:

Array3.php

<?php

$host="localhost";
$username="my_user";
$password="password";
$db_name="ict";

mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

echo "<TABLE border='1'>";

echo "<TR>";
echo "<TH id='a1'>Date</TH>";
echo "<TH id='a2'>Kommen</TH>";
echo "<TH id='a3'>Gehen</TH>";
echo "</TR>";

echo "<TR>";
echo "<TH id='a5' axis='month'>March</TH>";
echo "<TH></TH>";
echo "<TH></TH>";
echo "</TR>";

echo "<TR>";

echo "<TD id='a4'>2010-03-01</TD>";

$query1 = "SELECT COUNT(*) AS count FROM entry WHERE loguser='user1' and date='2010-03-01'";
$results1 = mysql_query($query1) or die ("Error reading from database");
$existingusername1 = mysql_fetch_array($results1);

if ($existingusername1['count'] = 3)
{

$query = "SELECT * FROM entry WHERE loguser='user1' and date='2010-03-01' ORDER BY date,time";

$result = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_array($result))
{

echo "<script language='javascript'>
result = document.getElementById('a4').innerHTML";
echo "</script>";

if($row['action'] == 'kommen' && $row['action'] == 'gehen')
{

echo "<TD headers='a5 a4 a2'>";
echo $row['time'];
echo "</TD>";

echo "<TD headers='a5 a4 a3'>";
echo $row['time'];
echo "</TD>";
}

else if($row['action'] == 'kommen')
{

echo "<TD headers='a5 a4 a2'>";
echo $row['time'];
echo "</TD>";

}

else if($row['action'] == 'gehen')
{
echo "<TD headers='a5 a4 a3'>";
echo $row['time'];
echo "</TD>";
}

else
{
echo "<TD headers='a5 a4 a2'> </TD>";
echo "<TD headers='a5 a4 a3'> </TD>";
}

}

}

echo "</script>";
echo "</TR>";

echo "<TR>";

echo "<TD> </TD>";

$query2 = "SELECT COUNT(*) AS count FROM entry WHERE loguser='user1' and date='2010-03-01'";
$results2 = mysql_query($query2) or die ("Error reading from database");
$existingusername2 = mysql_fetch_array($results2);

if ($existingusername2['count'] = 0)
{

$query3 = "SELECT * FROM entry WHERE loguser='user1' and date='2010-03-01' ORDER BY time";

$result3 = mysql_query($query3) or die(mysql_error());

while($row3 = mysql_fetch_array($result3))
{

if($row3['action'] == 'kommen')
{

echo "<TD headers='a5 a4 a2'>";
echo $row3['time'];
echo "</TD>";

}

else if($row3['action'] == 'gehen')
{
echo "<TD headers='a5 a4 a3'>";
echo $row3['time'];
echo "</TD>";
}

else
{
echo "<TD headers='a5 a4 a2'> </TD>";
echo "<TD headers='a5 a4 a3'> </TD>";
}
}
}

echo "</TR>";

echo "<TR>";

echo "<TD id='a6'>2010-03-02</TD>";

$query = "SELECT * FROM entry WHERE loguser='user1' and date='2010-03-02' ORDER BY date, time";

$result = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_array($result))
{

echo "<script language='javascript'>
result = document.getElementById('a6').innerHTML";
echo "</script>";

if($row['action'] == 'kommen')
{

echo "<TD headers='a5 a6 a2'>";
echo $row['time'];
echo "</TD>";

}

else if($row['action'] == 'gehen')
{
echo "<TD headers='a5 a6 a2'>";
echo $row['time'];
echo "</TD>";
}

else
{
echo "<TD headers='a5 a6 a2'> </TD>";
}

}

echo "</TR>";

echo "</TABLE>";

?>

Need an urgent help.

View All Comments | View Tutorial