Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- data is not inserting in mysqli
- <?php
- session_start();
- $username="xxx";
- $password="xxx";
- $database="mobile_app";
- $mysqli = new mysqli("localhost", $username, $password, $database);
- /* check connection */
- if (mysqli_connect_errno()) {
- printf("Connect failed: %sn", mysqli_connect_error());
- die();
- }
- $result = 0;
- if(getimagesize($_FILES['fileImage']['tmp_name'])){
- if( is_file("ImageFiles/".$_FILES['fileImage']['name'])) {
- $parts = explode(".",$_FILES['fileImage']['name']);
- $ext = array_pop($parts);
- $base = implode(".",$parts);
- $n = 2;
- while( is_file("ImageFiles/".$base."_".$n.".".$ext)) $n++;
- $_FILES['fileImage']['name'] = $base."_".$n.".".$ext;
- move_uploaded_file($_FILES["fileImage"]["tmp_name"],
- "ImageFiles/" . $_FILES["fileImage"]["name"]);
- $result = 1;
- $imagesql = "INSERT INTO Image (ImageFile)
- VALUES (?)";
- if (!$insert = $mysqli->prepare($imagesql)) {
- // Handle errors with prepare operation here
- }
- $insert->bind_param("s",'ImageFiles/' . $_FILES['fileImage']['name']);
- $insert->execute();
- if ($insert->errno) {
- // Handle query error here
- }
- $insert->close();
- }
- else
- {
- move_uploaded_file($_FILES["fileImage"]["tmp_name"],
- "ImageFiles/" . $_FILES["fileImage"]["name"]);
- $result = 1;
- $imagesql = "INSERT INTO Image (ImageFile)
- VALUES (?)";
- if (!$insert = $mysqli->prepare($imagesql)) {
- // Handle errors with prepare operation here
- }
- $insert->bind_param("s",'ImageFiles/' . $_FILES['fileImage']['name']);
- $insert->execute();
- if ($insert->errno) {
- // Handle query error here
- }
- $insert->close();
- }
- }
- ?>
- <?php
- session_start();
- $username="xxx";
- $password="xxx";
- $database="mobile_app";
- mysql_connect('localhost',$username,$password);
- mysql_select_db($database) or die( "Unable to select database");
- $result = 0;
- if(getimagesize($_FILES['fileImage']['tmp_name'])){
- if( is_file("ImageFiles/".$_FILES['fileImage']['name'])) {
- $parts = explode(".",$_FILES['fileImage']['name']);
- $ext = array_pop($parts);
- $base = implode(".",$parts);
- $n = 2;
- while( is_file("ImageFiles/".$base."_".$n.".".$ext)) $n++;
- $_FILES['fileImage']['name'] = $base."_".$n.".".$ext;
- move_uploaded_file($_FILES["fileImage"]["tmp_name"],
- "ImageFiles/" . $_FILES["fileImage"]["name"]);
- $result = 1;
- $imagesql = "INSERT INTO Image (ImageFile)
- VALUES ('ImageFiles/".mysql_real_escape_string($_FILES['fileImage']['name'])."')";
- mysql_query($imagesql);
- }
- else
- {
- move_uploaded_file($_FILES["fileImage"]["tmp_name"],
- "ImageFiles/" . $_FILES["fileImage"]["name"]);
- $result = 1;
- $imagesql = "INSERT INTO Image (ImageFile)
- VALUES ('ImageFiles/".mysql_real_escape_string($_FILES['fileImage']['name'])."')";
- mysql_query($imagesql);
- }
- }
- mysql_close();
- ?>
- <script language="javascript" type="text/javascript">
- window.top.stopImageUpload(<?php echo $result ? 'true' : 'false'; ?>, '<?php echo $_FILES['fileImage']['name'] ?>');
- </script>
- <?php
- $imagesql = "INSERT
- INTO Image (ImageFile)
- VALUES (?)";
- $insert = $mysqli->prepare($imagesql);
- //Dont pass data directly to bind_param store it in a variable
- $insert->bind_param("s",$img);
- //Assign the variable
- $img = 'ImageFiles/'.$_FILES['fileImage']['name'];
- $insert->execute();
- ?>
- <?php
- //If POST
- if($_SERVER['REQUEST_METHOD']=='POST'){
- //Check no errors on upload
- if($_FILES['fileImage']['error']==0){
- if(isset($_FILES['fileImage']['tmp_name'])){
- $imgSize = getimagesize($_FILES['fileImage']['tmp_name']);
- ...
- ...
- }
- }else{
- //get error code and display error
- }
- }else{
- //No POST
- }
- ?>
Add Comment
Please, Sign In to add comment