Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $n="SELECT COUNT('id_product')
- FROM 'products'";
- $value=mysql_query($n);
- do
- {
- $selectionASC='SELECT id_product
- FROM products
- ORDER BY id_product ASC
- LIMIT 1';
- $selectionDESC='SELECT id_product
- FROM products
- ORDER BY id_product DESC
- LIMIT 1';
- $ASC=mysql_query($selectionASC)
- or die ('Impossible execute the query <br />').mysql_error();
- $DESC=mysql_query($selectionDESC)
- or die ('Impossible execute the query <br />').mysql_error();
- //____________________________________________________________________
- $rand_n=rand(($ASC-1),($DESC+1));
- //____________________________________________________________________
- $selected='SELECT id_product,name, price, img
- FROM products
- WHERE id_product='.$rand_n;
- //____________________________________________________________________
- while($row=mysql_fetch_array($selected))
- {
- echo "Product'id:  "; echo $row[0];
- echo '<br />';
- echo "Name:  "; echo $row[1];
- echo '<br />';
- echo "Price::  "; echo $row[2];
- echo '<br />';
- echo "Immage: <img src='images/".$row['img']."' alt='Image'>";;
- echo '<hr> <br />';
- $value--;
- }
- }
- while ($value==0)
- $allowedExts=array("gif", "jpeg", "jpg", "png");
- if(isset($_POST['submit']))
- {
- $temp=explode(".", $_FILES["file"]["name"]);
- $extension=end($temp);
- if(isset($_FILES['file']['name']))
- {
- if(!empty($_FILES['file']['name']))
- {
- $directory='wwwv1.2loaded';
- $uploadfile = $directory . basename($_FILES['file']['name']);
- if ((($_FILES["file"]["type"] == "image/gif")
- || ($_FILES["file"]["type"] == "image/jpeg")
- || ($_FILES["file"]["type"] == "image/jpg")
- || ($_FILES["file"]["type"] == "image/pjpeg")
- || ($_FILES["file"]["type"] == "image/x-png")
- || ($_FILES["file"]["type"] == "image/png"))
- && ($_FILES["file"]["size"] < 20000)
- && in_array($extension, $allowedExts))
- {
- if ($_FILES["file"]["error"] > 0)
- {
- echo "Return Code: " . $_FILES["file"]["error"] . "<br>";
- }
- else
- {
- //$nameImage=$_FILES(["file"]["name"]);
- $typeImage=$_FILES["file"]["type"];
- $sizeImage=$_FILES["file"]["size"];
- if (file_exists("upload/" . $_FILES["file"]["name"]))
- {
- echo $_FILES["file"]["name"] . " already exists. ";
- }
- else
- {
- if (move_uploaded_file($_FILES['file']['tmp_name'], $uploadfile))
- {
- $insert="INSERT INTO 'img'
- VALUES ('','$uploadfile','$typeImage','$sizeImage')";
- echo "File's extension valid, upload executed";
- }
- else
- {
- echo "Upload failed: ceck the size and the extension";
- }
- }
- }
- }
- else
- {
- echo "Invalid file";
- }
- }
- }
- echo "Immage: <img src='images/".$row['img']."' alt='Image'>";;
- echo "Immage: <img src='images/".$row['3']."' alt='Image'>";
- while($row=mysql_fetch_assoc($selected))
- {
- echo "Product'id:  "; echo $row['id_product'];
- echo '<br />';
- echo "Name:  "; echo $row['name'];
- echo '<br />';
- echo "Price::  "; echo $row['price'];
- echo '<br />';
- echo "Immage: <img src='images/".$row['img']."' alt='Image'>";
- echo '<hr> <br />';
- $value--;
- }
- $selected='SELECT id_product,name, price, img
- FROM products
- WHERE id_product='.$rand_n;
- $selected = mysql_query($selected);
- while($row=mysql_fetch_assoc($selected))
- {
- echo "Product'id:  "; echo $row['id_product'];
- echo '<br />';
- echo "Name:  "; echo $row['name'];
- echo '<br />';
- echo "Price::  "; echo $row['price'];
- echo '<br />';
- echo "Immage: <img src='images/".$row['img']."' alt='Image'>";
- echo '<hr> <br />';
- $value--;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement