I'm creating backend pages for my site and I want to edit images that are already existing in my database using input control type "file".
But when I choose a new image it isn't modified in the database and moving up in its folder.
This is my code:
<?php
$db = new MySQLi(server,user,password,database);
//other function to show data
mysqli_query($db,'SET NAMES "utf8" COLLATE "utf8_general_ci"');
if ($db->connect_errno > 0) {
die ("Failed to connect to database".$db->connect_error);
}
$id = $_GET["id"];
$news_select = "select news_id,title,content,image,news_date
from news_slider
where news_id=$id";
if (!$news_result=$db->query($news_select)) {
die($db->error);
}
?>
<!--wrapper start -->
<div id="wrapper">
<!-- u data -->
<div id="u_data">
<?php
while ($row=$news_result->fetch_assoc()) {
?>
<img id="picture" src="../../images/slider_images/<?= $row["image"]; ?>">
<h3 class="id">News id:</h3>
<h3 class="id">Title:</h3>
<h3 class="id">Content:</h3>
<h3 class="id">News_date : </h3>
<ul id="data" >
<li class="data"><h4><?php echo $row["news_id"] ?></h4> </li>
<li class="data"><h4><?php echo $row["title"] ?></h4> </li>
<li class="data" style="height::10%"><h4><?php echo $row["content"] ?></h4></li>
<li class="data"><h4><?php echo $row["news_date"] ?></h4> </li>
</ul>
<?php
}
?>
</div>
<!-- udata end -->
This my form to change and edit the database. I will display just the question-related part:
<form name="edit_news" action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"])?>" method="get" enctype="multipart/form-data">
<h3> change pic </h3> <input type="file" name="pic" id="pic" />
<input type="hidden" name="id" value="<?php echo $id ;?>" />
<!-- div submit start-->
<div style="margin:10px 0 0 0" >
<input type="submit" name="go" value=" GO ">
<input type="reset" bame="back" value=" BACK ">
</div>
<!--div submit end -->
</form>
This part of code changes the images in the database:
<?php
if ($_SERVER["REQUEST_METHOD"]== 'GET') {
//change imge file news
if (isset($_FILES["pic"]) && !empty($_FILES["pic"])) {
//difneshion variables to file uploaded
//name of file + exetension
$imgtype=pathinfo($_FILES["pic"]["name"],PATHINFO_EXTENSION);
//echo $imgtype."<br />";
//root directory for file
$path="../../images/slider_images/";
//random name
$name=mt_rand(1000,1000000);
$target=$path.$name.".".$imgtype;
//image name to type it in DB
$imageName=$name.".".$imgtype;
if ($imgtype !='jpg' && $imgtype !='png') {
echo "invalid file type";
} else if($_FILES["pic"]["size"] > 2000000) {
echo "invalid file size";
}
/* sles of transfer file uploaded start*/
//transfer file to folder profile in site root and type the name in DB
else {
/* if statement of move file start */
if (move_uploaded_file($_FILES["pic"]["tmp_name"],$target)) {
//update imge file
$imge_update="update news_slider set image='$imageName' where news_id=$id";
if(!$imge_result=$db->query($imge_update)) {
die($db->error);
} else {
//header("location:../../bookstore/bookstore_en/news_control.php");
echo "done!!";
}
}//end of if move uploaded
}//end of else
}//end of change imge news
}// end of if REQUEST
I don't seem to find a solution to this problem.
It's buy the learning form. It's simply a list of things and your problem elegates come from a proxy that you define so far. PHP's lo_post operations seem to make far simpler and provides common concepts, like for example adding new posts, to be overall the links of the other users.
If you specify a listener, it is a command call. If you want the new_form feature, that is just a handy example.
If you fiddle with your current project, once /path/to/posts/plugin/ from the whole url: you mean how many link ways you should add them? What about "saving" events?
When your data you're in the store, you get a key approach with all the comments, and a single post created with that data:
function post_safe_url($path)
{
$file_list = "http://website.com/";
if(boost_post_lang($new_file))
{
$url = "http://www.facebook.com/us/users/ff/article/g";
$array = array();
for ($i = 0; $i < $counter; $i++)
{
$array[$i][0] = "[";
# $one[$i][level] = $url;
$array[$i++] = $array[$i++];
}
//update any authenticated values
$cached_array["now"] = $current_array["count"];
print_r($array);
$json[$id][2] = $first_key;
$authmax = array_diff($actualarr[$i],0);
if(!empty($bitsub) && $arraytab != 0) {
return Success;
}
//Deal with all 75
return 0;
}
return false;
}
FOLLOW to Commit...
if($client->creation_time > 1) {
$wsdl->targetWSDL = array('http://localhost/ACTUAL-2D42', '69085-cast-to-between-cells-0- 2');
//echo "ip is NULL"; //trim alert after brings
return;
}
If the query does not have @Exception, $result is failure but you have SQL error.
In Previous 500 Exception do Code: Project name: as u are not creating Error Message.
To git the non-throws you can check whether internet connection is good or not "Notice: Sorry, please receive the data again"
| asked | Loading |
| viewed | 15,022 times |
| active | Loading |
It was generated by a neural network.