There's no real mystery to ajax. It is simply a GET or POST to a standard cfml file, the response of which is then processed/acted on by JavaScript.
First thing to confirm is whether the url that the ajax is calling is working. You should be able to create a url yourself, my guess is it would look something like:-
Untested. Assuming your table contains an id column. Set a cookie of the id of the last image displayed. If this is first time (cookie doesn't exist) simply set a $cookieId of 1.
Amend your query to
$q ="SELECT * FROM headerrotatorimage WHERE rotator = 1 AND status = 1 and id <> $cookieId ORDER BY RAND() LIMIT 1" or die (mysqli_error($link));
You said you already have an email function - you can simply feed $message from the code below into your email function.
<?php
$username = "root"; // Mysql username
$password = "root"; // Mysql password
$db_name = "Stock"; // Database name
$host = "somehost";
mysql_connect($host, $username, $password) or die("Failed to connect to MySQL");
mysql_select_db($db_name); //SELECT THE CORRECT DATABASE
$rs = mysql_query("select ProductID, ProductDescription from Products where ProductQuantity < 1");
if(mysql_num_rows($rs)>0) {
$message = '<p>The following products are out of stock</p><ul>';
while($row = mysql_fetch_assoc($rs)) {
$message .= '<li>'.$row['ProductID'].' '.$row['ProductDescription'].'</li>';
}
$message .= '</ul>';
echo $message;
//email your $message
} else {
//email a message that all products have stock
}
?>
As iamthwee and myself mentioned - our idea was to send an email at the time that a particular product's stock level becomes zero.
Your code appears to want to check all products' stock levels on demand and send an email.
So forget code... let's think process. Do you simply want a function that can be run anytime that checks the stock level of all products and sends an email reporting which products are at zero?
I presume there is a PHP function you call to remove an item from the database. After this function is run, you should simply run the function that returns the product quantity of the item and then send a PHP email if quantity is less than 1.
Pseudo code (PHP):
decrementProduct($productId);
$product = getProductDetails($productId);
//assumption that returned $product is an array
if($product['quantity']<1) {
sendNoStockEmail($product);
}
Your array has two identical records (both [id] => 2), so I assume you copy/pasted for quickness. You also have a ; missing in your for statement after $contents
foreach($_SESSION['cartItems'] as $key => $products){
if($products['id']==$delid) {
unset($_SESSION['cartItems'][$key]);
}
}
Need a little more snippet.. e.g. where did $user_length come from ? is u0003:omied:123456-12-1234:male:married:privatesector:dfsfsdf:603-32323242:6016-2343432:omied@gmail.com:omeid123:dingo1234 associated with a variable?
I've never used backbone, and just trying to get my head around it's concepts.. but the documentation appears to suggest that the .create will fire a "request"
Creating a model will cause an immediate "add" event to be triggered on the collection, a "request" event as the new model is sent to the server, as well as a....
A quick look at your screenshot would suggest that you are not truncating the table - simply running the script over and over. e.g. id numbers for Westville Jnr are in increments of 39.
Sorry, I ran your code five times and every time was successful. The only thing that did error was your fclose - you need to change it to fclose($handle);
If I were going to use tables for a quick layout they would have been for the 3 columns at the top, but you have used floated divs, then further down you appear to be using a table where simple divs or paras are called for.
I would start by ripping out the CSS styles e.g. <h3 class="B"> make it <h3>. Your style sheet has a lot of horrendous style names which thankfully you don't appear to be using.
