Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > PHP/MySQL > PHP Databases
Password Reminder
Register
Register | FAQ | Members List | Calendar | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old August 19th, 2013, 02: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>
Reply With Quote
  #2 (permalink)  
Old August 20th, 2013, 09: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';
}
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

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 06:10 PM
Need help, what code should I write here? vincentleo ASP.NET 2.0 Basics 2 March 10th, 2008 11:09 AM
re write a code kgoldvas XSLT 3 August 1st, 2007 08:40 AM
how write vb code in c# ravpaw General .NET 2 July 1st, 2007 03:13 PM



All times are GMT -4. The time now is 10:15 AM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.