Wrox Programmer Forums
Go Back   Wrox Programmer Forums > PHP/MySQL > PHP Databases
| Search | Today's Posts | Mark Forums Read
PHP Databases Using PHP in conjunction with databases. PHP questions not specific to databases should be directed to one of the other PHP forums.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the PHP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 19th, 2013, 01:15 PM
Registered User
Points: 5, Level: 1
Points: 5, Level: 1 Points: 5, Level: 1 Points: 5, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2013
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default can anyone help me write this code??

i want to compare $res[6] to the system time, and whenever the result is equal it will throw an alert saying "you have a callback"..for 3 days I've tried several things but cant get it to work..please someone help me... thanks in advance..any help is greatly appreciated
Code:
<?php
include("AgentLockout.php");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Agent-Homepage</title>
<link href="http://192.168.10.157:1234/iFixo_CRM/CSS/style_legend.css" rel="stylesheet" type="text/css" />
<script language="javascript" type="text/javascript">
function ValidateOnDelete()
{
	var ret = confirm("Are you sure you want to delete the callback?");
	if (ret == true)
	{
		event.returnValue = true;
	}
	else
	{
		event.returnValue = false;
	}
}
</script>
</head>
<body bgcolor="#1BD6E0" onload="javascript:pageOnLoad()">
	<table border="0" cellpadding="1" cellspacing="1" width="100%" >
		<tr>
			<td colspan="3" style="width:100%; height:5pt;"></td>
		</tr>
		<tr>
			<td style="width:15%;"></td>
			<td style="width:70%;">
				<table border="1" cellpadding="1" cellspacing="1" width="90%" bgcolor="#FFFFFF">
					<tr bgcolor="#9E9598">
						<td>
							<a href="http://192.168.10.157:1234/iFixo_CRM/Agent_Homepage.php">Home</a>
						</td>
						<td>
							<a href="http://192.168.10.157:1234/iFixo_CRM/Create_Case.php">Create Case</a>
						</td>
						<td>
							<a href="http://192.168.10.157:1234/iFixo_CRM/Create_Callback.php">Create Callback</a>
						</td>
						<td>
							<a href="http://192.168.10.157:1234/iFixo_CRM/View_Callback.php">View Callback</a>
						</td>
						<td>
							<a href="http://192.168.10.157:1234/iFixo_CRM/Agent_Change_Password.php">Change Password</a>
						</td>
						<td>
							<a href="http://192.168.10.157:1234/iFixo_CRM/Agent_Logout.php">Logout</a>
						</td>
					</tr>
					<tr>
						<td colspan="6" style="width:100%;">
							<table width="100%">
								<tr>
									<td align="right" valign="top" width="28%">Agent Name : </td>
									<td align="right" valign="top" width="2%"></td>
									<td align="left" valign="top" width="70%"><?php echo $agent_name; ?></td>
								</tr>
								<tr>
									<td colspan="3" width="100%">
										<table border="0" cellspacing="1" cellpadding="1" width="100%" >
											<tr>
												<td align="right" valign="top" width="15%" >	
													<div class="foo" style="background-color:#FFFFFF;"></div>
												</td>
												<td align="left" valign="top" width="30%">Existing Customer</td>
												<td align="center" valign="top" width="10%"></td>
												<td align="right" valign="top" width="15%">	
													<div class="foo" style="background-color:#F2CBC9;"></div>
												</td>
												<td align="left" valign="top" width="30%">Prospect Customer</td>
											</tr>
										</table>
									</td>
								</tr>
								<tr>
									<td colspan="3" width="100%">
										<table border="1" cellspacing="1" cellpadding="1" width="100%" >
											<tr bgcolor="#9E9598">
												<td align="center" valign="top" width="20%">Customer Name </td>
												<td align="center" valign="top" width="20%">Callback Date </td>
												<td align="center" valign="top" width="20%">Callback Time </td>
												<td align="center" valign="top" width="20%">Contact Number </td>
												<td align="center" valign="top" width="10%">Edit </td>
												<td align="center" valign="top" width="10%">Delete </td>
											</tr>
											<?php
												include("config.php");
												date_default_timezone_set('Asia/kolkata');
												$sql = "Select * from callback where userid='$agent_id' order by callbacktime";
												$result = mysql_query($sql);
												while($res = mysql_fetch_array($result))
												{
													if($res[7] == '0')
													{
											?>
														<tr>
															<td align="center" valign="top" width="20%"><?php echo $res[4]; ?></td>
															<td align="center" valign="top" width="20%"><?php echo $res[5]; ?></td>
															<td align="center" valign="top" width="20%"><?php echo $res[6]; ?></td>
															<td align="center" valign="top" width="20%"><?php echo $res[9]; ?></td>
															<td align="center" valign="top" width="10%"><a href="editcallback.php?id=<?= $res[0];?>">edit</a></td>
															<td align="center" valign="top" width="10%"><a href="deletecallback.php?id=<?=$res[0];?>" onclick="ValidateOnDelete()">delete</a></td>
														</tr>
											<?php 	}
													else
													{ 
											?>
														<tr bgcolor="#F2CBC9">
															<td align="center" valign="top" width="20%"><?php echo $res[4]; ?></td>
															<td align="center" valign="top" width="20%"><?php echo $res[5]; ?></td>
															<td align="center" valign="top" width="20%"><?php echo $res[6]; ?></td>
															<td align="center" valign="top" width="20%"><?php echo $res[9]; ?></td>
															<td align="center" valign="top" width="10%"><a href="editcallback.php?id=<?= $res[0];?>">edit</a></td>
															<td align="center" valign="top" width="10%"><a href="deletecallback.php?id=<?=$res[0];?>" onclick="ValidateOnDelete()">delete</a></td>
														</tr>
											<?php
													}
												}
											?>
										</table>
									</td>
								</tr>
							</table>
						</td>
					</tr>
				</table>
			</td>
			<td style="width:15%;"></td>
		</tr>
	</table>
</body>
</html>
 
Old August 20th, 2013, 08:43 AM
Friend of Wrox
Points: 651, Level: 9
Points: 651, Level: 9 Points: 651, Level: 9 Points: 651, Level: 9
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2011
Location: North East UK
Posts: 125
Thanks: 0
Thanked 24 Times in 24 Posts
Default

Greetings,

Post the output of the following;
Code:
$sql = "Select * from callback where userid='$agent_id' order by callbacktime";
if( $result = mysql_query($sql) )
{
	// array to hold data;
	$data = array();

	// loop over the database results
	while($res = mysql_fetch_array($result))
	{
		$data[] = $res;
	}

/* */
echo '<pre>';
print_r($data);
echo '</pre>';
/* */
}
else
{
	echo 'Query failed';
}




Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i write code like that? nir987 ASP.NET 3.5 Professionals 0 March 3rd, 2011 08:03 AM
How do i write code to go back or undo sanderson Beginning VB 6 1 July 9th, 2008 05:10 PM
Need help, what code should I write here? vincentleo ASP.NET 2.0 Basics 2 March 10th, 2008 10:09 AM
re write a code kgoldvas XSLT 3 August 1st, 2007 07:40 AM
how write vb code in c# ravpaw General .NET 2 July 1st, 2007 02:13 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.