Guest User

Untitled

a guest
Sep 18th, 2018
107
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.19 KB | None | 0 0
  1. data is not inserting in mysqli
  2. <?php
  3.  
  4. session_start();
  5.  
  6.  
  7. $username="xxx";
  8. $password="xxx";
  9. $database="mobile_app";
  10.  
  11. $mysqli = new mysqli("localhost", $username, $password, $database);
  12.  
  13. /* check connection */
  14. if (mysqli_connect_errno()) {
  15. printf("Connect failed: %sn", mysqli_connect_error());
  16. die();
  17. }
  18.  
  19. $result = 0;
  20.  
  21. if(getimagesize($_FILES['fileImage']['tmp_name'])){
  22.  
  23. if( is_file("ImageFiles/".$_FILES['fileImage']['name'])) {
  24. $parts = explode(".",$_FILES['fileImage']['name']);
  25. $ext = array_pop($parts);
  26. $base = implode(".",$parts);
  27. $n = 2;
  28.  
  29. while( is_file("ImageFiles/".$base."_".$n.".".$ext)) $n++;
  30. $_FILES['fileImage']['name'] = $base."_".$n.".".$ext;
  31.  
  32. move_uploaded_file($_FILES["fileImage"]["tmp_name"],
  33. "ImageFiles/" . $_FILES["fileImage"]["name"]);
  34. $result = 1;
  35.  
  36. $imagesql = "INSERT INTO Image (ImageFile)
  37. VALUES (?)";
  38.  
  39. if (!$insert = $mysqli->prepare($imagesql)) {
  40. // Handle errors with prepare operation here
  41. }
  42.  
  43. $insert->bind_param("s",'ImageFiles/' . $_FILES['fileImage']['name']);
  44.  
  45. $insert->execute();
  46.  
  47. if ($insert->errno) {
  48. // Handle query error here
  49. }
  50.  
  51. $insert->close();
  52.  
  53.  
  54. }
  55. else
  56. {
  57. move_uploaded_file($_FILES["fileImage"]["tmp_name"],
  58. "ImageFiles/" . $_FILES["fileImage"]["name"]);
  59. $result = 1;
  60.  
  61. $imagesql = "INSERT INTO Image (ImageFile)
  62. VALUES (?)";
  63.  
  64. if (!$insert = $mysqli->prepare($imagesql)) {
  65. // Handle errors with prepare operation here
  66. }
  67.  
  68. $insert->bind_param("s",'ImageFiles/' . $_FILES['fileImage']['name']);
  69.  
  70. $insert->execute();
  71.  
  72. if ($insert->errno) {
  73. // Handle query error here
  74. }
  75.  
  76. $insert->close();
  77.  
  78.  
  79. }
  80. }
  81. ?>
  82.  
  83. <?php
  84.  
  85. session_start();
  86.  
  87.  
  88. $username="xxx";
  89. $password="xxx";
  90. $database="mobile_app";
  91.  
  92. mysql_connect('localhost',$username,$password);
  93.  
  94. mysql_select_db($database) or die( "Unable to select database");
  95.  
  96. $result = 0;
  97.  
  98. if(getimagesize($_FILES['fileImage']['tmp_name'])){
  99.  
  100. if( is_file("ImageFiles/".$_FILES['fileImage']['name'])) {
  101. $parts = explode(".",$_FILES['fileImage']['name']);
  102. $ext = array_pop($parts);
  103. $base = implode(".",$parts);
  104. $n = 2;
  105.  
  106. while( is_file("ImageFiles/".$base."_".$n.".".$ext)) $n++;
  107. $_FILES['fileImage']['name'] = $base."_".$n.".".$ext;
  108.  
  109. move_uploaded_file($_FILES["fileImage"]["tmp_name"],
  110. "ImageFiles/" . $_FILES["fileImage"]["name"]);
  111. $result = 1;
  112.  
  113. $imagesql = "INSERT INTO Image (ImageFile)
  114. VALUES ('ImageFiles/".mysql_real_escape_string($_FILES['fileImage']['name'])."')";
  115.  
  116. mysql_query($imagesql);
  117.  
  118. }
  119. else
  120. {
  121. move_uploaded_file($_FILES["fileImage"]["tmp_name"],
  122. "ImageFiles/" . $_FILES["fileImage"]["name"]);
  123. $result = 1;
  124.  
  125. $imagesql = "INSERT INTO Image (ImageFile)
  126. VALUES ('ImageFiles/".mysql_real_escape_string($_FILES['fileImage']['name'])."')";
  127.  
  128. mysql_query($imagesql);
  129.  
  130. }
  131.  
  132. }
  133. mysql_close();
  134.  
  135. ?>
  136.  
  137. <script language="javascript" type="text/javascript">
  138. window.top.stopImageUpload(<?php echo $result ? 'true' : 'false'; ?>, '<?php echo $_FILES['fileImage']['name'] ?>');
  139. </script>
  140.  
  141. <?php
  142. $imagesql = "INSERT
  143. INTO Image (ImageFile)
  144. VALUES (?)";
  145.  
  146. $insert = $mysqli->prepare($imagesql);
  147.  
  148. //Dont pass data directly to bind_param store it in a variable
  149. $insert->bind_param("s",$img);
  150.  
  151. //Assign the variable
  152. $img = 'ImageFiles/'.$_FILES['fileImage']['name'];
  153.  
  154. $insert->execute();
  155. ?>
  156.  
  157. <?php
  158. //If POST
  159. if($_SERVER['REQUEST_METHOD']=='POST'){
  160. //Check no errors on upload
  161. if($_FILES['fileImage']['error']==0){
  162.  
  163. if(isset($_FILES['fileImage']['tmp_name'])){
  164. $imgSize = getimagesize($_FILES['fileImage']['tmp_name']);
  165. ...
  166. ...
  167. }
  168.  
  169. }else{
  170. //get error code and display error
  171. }
  172.  
  173. }else{
  174. //No POST
  175. }
  176. ?>
Add Comment
Please, Sign In to add comment