Advertisement
Guest User

Untitled

a guest
Apr 16th, 2014
54
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.39 KB | None | 0 0
  1. $n="SELECT COUNT('id_product')
  2. FROM 'products'";
  3. $value=mysql_query($n);
  4.  
  5. do
  6. {
  7. $selectionASC='SELECT id_product
  8. FROM products
  9. ORDER BY id_product ASC
  10. LIMIT 1';
  11. $selectionDESC='SELECT id_product
  12. FROM products
  13. ORDER BY id_product DESC
  14. LIMIT 1';
  15. $ASC=mysql_query($selectionASC)
  16. or die ('Impossible execute the query <br />').mysql_error();
  17. $DESC=mysql_query($selectionDESC)
  18. or die ('Impossible execute the query <br />').mysql_error();
  19.  
  20. //____________________________________________________________________
  21. $rand_n=rand(($ASC-1),($DESC+1));
  22.  
  23. //____________________________________________________________________
  24. $selected='SELECT id_product,name, price, img
  25. FROM products
  26. WHERE id_product='.$rand_n;
  27. //____________________________________________________________________
  28. while($row=mysql_fetch_array($selected))
  29. {
  30. echo "Product'id: &nbsp"; echo $row[0];
  31. echo '<br />';
  32. echo "Name: &nbsp"; echo $row[1];
  33. echo '<br />';
  34. echo "Price:: &nbsp"; echo $row[2];
  35. echo '<br />';
  36. echo "Immage: <img src='images/".$row['img']."' alt='Image'>";;
  37. echo '<hr> <br />';
  38.  
  39. $value--;
  40. }
  41. }
  42. while ($value==0)
  43.  
  44. $allowedExts=array("gif", "jpeg", "jpg", "png");
  45.  
  46. if(isset($_POST['submit']))
  47. {
  48. $temp=explode(".", $_FILES["file"]["name"]);
  49. $extension=end($temp);
  50.  
  51. if(isset($_FILES['file']['name']))
  52. {
  53. if(!empty($_FILES['file']['name']))
  54. {
  55. $directory='wwwv1.2loaded';
  56. $uploadfile = $directory . basename($_FILES['file']['name']);
  57.  
  58. if ((($_FILES["file"]["type"] == "image/gif")
  59. || ($_FILES["file"]["type"] == "image/jpeg")
  60. || ($_FILES["file"]["type"] == "image/jpg")
  61. || ($_FILES["file"]["type"] == "image/pjpeg")
  62. || ($_FILES["file"]["type"] == "image/x-png")
  63. || ($_FILES["file"]["type"] == "image/png"))
  64. && ($_FILES["file"]["size"] < 20000)
  65. && in_array($extension, $allowedExts))
  66. {
  67. if ($_FILES["file"]["error"] > 0)
  68. {
  69. echo "Return Code: " . $_FILES["file"]["error"] . "<br>";
  70. }
  71. else
  72. {
  73. //$nameImage=$_FILES(["file"]["name"]);
  74. $typeImage=$_FILES["file"]["type"];
  75. $sizeImage=$_FILES["file"]["size"];
  76.  
  77. if (file_exists("upload/" . $_FILES["file"]["name"]))
  78. {
  79. echo $_FILES["file"]["name"] . " already exists. ";
  80. }
  81. else
  82. {
  83. if (move_uploaded_file($_FILES['file']['tmp_name'], $uploadfile))
  84. {
  85. $insert="INSERT INTO 'img'
  86. VALUES ('','$uploadfile','$typeImage','$sizeImage')";
  87. echo "File's extension valid, upload executed";
  88. }
  89. else
  90. {
  91. echo "Upload failed: ceck the size and the extension";
  92. }
  93. }
  94. }
  95. }
  96. else
  97. {
  98. echo "Invalid file";
  99. }
  100. }
  101. }
  102.  
  103. echo "Immage: <img src='images/".$row['img']."' alt='Image'>";;
  104.  
  105. echo "Immage: <img src='images/".$row['3']."' alt='Image'>";
  106.  
  107. while($row=mysql_fetch_assoc($selected))
  108. {
  109. echo "Product'id: &nbsp"; echo $row['id_product'];
  110. echo '<br />';
  111. echo "Name: &nbsp"; echo $row['name'];
  112. echo '<br />';
  113. echo "Price:: &nbsp"; echo $row['price'];
  114. echo '<br />';
  115. echo "Immage: <img src='images/".$row['img']."' alt='Image'>";
  116. echo '<hr> <br />';
  117.  
  118. $value--;
  119. }
  120.  
  121. $selected='SELECT id_product,name, price, img
  122. FROM products
  123. WHERE id_product='.$rand_n;
  124. $selected = mysql_query($selected);
  125.  
  126. while($row=mysql_fetch_assoc($selected))
  127. {
  128. echo "Product'id: &nbsp"; echo $row['id_product'];
  129. echo '<br />';
  130. echo "Name: &nbsp"; echo $row['name'];
  131. echo '<br />';
  132. echo "Price:: &nbsp"; echo $row['price'];
  133. echo '<br />';
  134. echo "Immage: <img src='images/".$row['img']."' alt='Image'>";
  135. echo '<hr> <br />';
  136.  
  137. $value--;
  138. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement