How to Store Old pic in Database if no new image Updated In php -


hi in form when user submit form , select no image database updated blank can me wrong in code don't have php knowledge need help

here full php code hope got wrong

i want if user not select image old image not replace blank

i try in code still got blank!

<?php include("connect.php");     if(isset($_post['submit']))     {         $id = $_post['id'];         $form_no = $_post['form_no'];         $shop_name = $_post['shop_name'];         $shop_address = $_post['shop_address'];         $owner_name = $_post['owner_name'];         $owner_address = $_post['owner_address'];         $phone = $_post['phone'];         $m_no = $_post['m_no'];         $email = $_post['email'];         $d_o_b = $_post['d_o_b'];         $d_o_m = $_post['d_o_m'];         $b_type = $_post['b_type'];         $reg_no = $_post['reg_no'];         $coment = $_post['coment'];         $date = date('y-m-d');         $errors = "";         $plan = $_post['select'];         $oldpic=$_post["oldpic"];         if($_files['image']['name'] != "" && $errors == "")         {             $file_name = $_files['image']['name'];             $file_size = $_files['image']['size'];             $file_tmp = $_files['image']['tmp_name'];             $file_type = $_files['image']['type'];             $file_ext=strtolower(end(explode('.',$file_name)));             $expensions= array("jpeg","jpg","png");             if(!in_array($file_ext,$expensions))             {                 $errors="extension not allowed, please choose jpeg or png file.";             }              if($file_size > 2097152)             {                 $errors ='file size must excately 2 mb';             }             if(empty($errors))             {                 $new_file_name = uniqid().'.'.$file_ext;                 move_uploaded_file($file_tmp,"user/".$new_file_name);             }         }          if(empty($errors))         {             $qreury = "update members set              ref_no='$ref_no',shop_name='$shop_name', form_no='$form_no',             shop_address='$shop_address', owner_name='$owner_name',             owner_address='$owner_address', tel_no='$phone', mobile_no='$m_no',             email='$email',dob='$d_o_b',marrige_date='$d_o_m',bussiness_type='$b_type',             reg_no='$reg_no',extra_note='$coment',user_pic='$new_file_name',             plan='$plan',target=(select price members_plan id ='$plan') id='$id'";             $reslt = mysql_query($qreury)or die(mysql_error());             header("location:registered_members.php");          }     elseif(empty($oldpic))         {             $qreury = "update members set              ref_no='$ref_no',shop_name='$shop_name', form_no='$form_no',             shop_address='$shop_address', owner_name='$owner_name',             owner_address='$owner_address', tel_no='$phone', mobile_no='$m_no',             email='$email',dob='$d_o_b',marrige_date='$d_o_m',bussiness_type='$b_type',             reg_no='$reg_no',extra_note='$coment',user_pic='$oldpic',             plan='$plan',target=(select price members_plan id ='$plan') id='$id'";             $reslt = mysql_query($qreury)or die(mysql_error());             header("location:registered_members.php");         }     } ?>

i understand problem, please let code doing. if storing null don't worry. store null , put avtar default image on file system, , can following while fetching image view you:

    <img src=" <?php !empty($your-image-with-directory)?$your-image-with-directory:"upload-directory/avtar.png"?>" width="100">

Comments

Post a Comment

Popular posts from this blog

ubuntu - PHP script to find files of certain extensions in a directory, returns populated array when run in browser, but empty array when run from terminal -

i running os ububtu 16.04. ultimate goal able run php script cron job every minute. here php script located @ /var/www/html/tests/test/index.php : <?php $directorypath = $_server['document_root']."/tests/test/data/"; echo "directorypath: $directorypath<br><br>";//check $imagefilepathsarray = glob($directorypath . "*.{png,gif}", glob_brace); echo "<br><br>imagefilepathsarray: "; print_r($imagefilepathsarray);//check ?> when open php script in browser visiting url my-ip-address/tests/test/index.php , get: directorypath: /var/www/html/tests/test/data/ imagefilepathsarray:array( [0] => /var/www/html/tests/test/data/pic.png [1] => /var/www/html/tests/test/data/pic.gif ) before writing cron job in crontab file, need check if can run anywhere using terminal . opened ubuntu terminal @ /home/ location, , executed in terminal: sudo php /var/www/html/tests/test/index.php i got following out...
Read more

php - How can i create a user dashboard -

today have questions you, want create user dashboard site, include (obviously), users data, example -email -username -and others stuff how can information, , print them in html page? if can, how can these information via php sessions? shuld use session? example, if user login, , start new session ( session_start() ), how can data print in dashboard? should use php "project"? in advice, have day , thank time!
Read more

javascript - How to detect toggling of the fullscreen-toolbar in jQuery Mobile? -

i have jquery mobile page fixed full-screen toolbar, data-tap-toggle enabled. straight under toolbar have positioned banner should slide upwards when toolbar hiding , slide downward when toolbar showing. jquery mobile toggles toolbar applying , removing ui-fixed-hidden class - sadly, can't find in documentation of toolbar widget toggle , hide or show event that. how can detect when toolbar toggled, reposition banner? .banner { position: fixed; background-color: darkseagreen; top: 46px; min-height: 48px; width: 100%; text-align: center; line-height: 48px; } <!doctype html> <html> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=no"> <link rel="stylesheet" href="https://code.jquery.com/mobile/1.4.5/jquery.mobile-1.4.5.css"> <script src="https://code.jquery.com/jquery-1....
Read more