Posts

Showing posts from July, 2017

Insert Image With unique Number Using PHP Mysqli

<?php                                     include "config.php";                                     if(isset($_POST['btn_rgister']))                                     {                                     extract($_POST);                                     $name1=$_FILES['product_photo']['name'];   ...

Update Image Using PHP Mysqli

<div class="fileupload-preview fileupload-exists thumbnail" style="max-width: 200px; max-height: 225px; line-height: 20px;"><img src="images/<?php echo $row['att_user_photo']?>" height="90" width="90"></div>                                 <div>                                                                        <input type="file" name="att_user_photo" ></span>                ...

Insert Image Using PHP Mysqli

 <input type="file" name="att_user_photo"  class=" validate[required] text-input"  /> <?php include "include/connection.php"; if(isset($_POST['btn-submit'])) { extract($_POST); $name1=$_FILES['att_user_photo']['name']; $size=$_FILES['att_user_photo']['size']; $type=$_FILES['att_user_photo']['type']; $temp=$_FILES['att_user_photo']['tmp_name'];  move_uploaded_file($temp,"images/".$name1); $q=mysqli_query($con,"insert into att_add_user(att_user_name,att_user_gender,att_user_mobileno,att_user_address,att_user_photo,att_user_dob,att_user_jd,att_user_ld,att_user_post,att_user_department,att_user_fe,att_user_se,att_user_te,att_user_be,att_user_email,att_user_password,att_user_cpassword) values( '$att_user_name','$att_user_gender','$att_user_mobileno','$att_user_address','$name1','$att_user_dob','$att_user...

Delete Data Using PHP Mysqli

<?php if(isset($_GET['id'])) { $con=mysqli_connect("localhost","root","root","example") or die(mysqli_error());             $query= 'delete from student_info where id="'.$_GET['id'].'" ' ;           $result = mysqli_query($con,$query);          // $row = mysqli_fetch_array($result);   if($result)                           {  echo '<script type="text/javascript">';  echo " alert('Record Deleted');";  echo 'window.location.href = "view.php";';  echo '</script>';                         } }   ?> 

Update Data using PHP Mysqi

<?php if(isset($_GET['id'])) {  extract($_POST); $con=mysqli_connect("localhost","root","root","example") or die(mysqli_error());   $query= mysqli_query($con,"select * from student_info where id='{$_GET['id']}' ") ;         //$result = mysqli_query($con,$query);           $row = mysqli_fetch_array($query);         ?>             <!-- form start -->             <form id="form11" method="post">                                     <table align="center" border="1">              <tr>              <td>Name</td>                <td><input type="text" name...

View Data Using PHP Mysqli

<?php $con=mysqli_connect("localhost","root","root","example") or die(mysqli_error()); $query = mysqli_query($con, "select * from student_info"); if(mysqli_num_rows($query)>0) { ?>                         <table border="1" align="center">                 <thead>                 <tr>                  <th><div align="center">id</div></th>                  <th><div align="center">name</div></th>                                                    <th><div align="center">E-Mail</th></div...

Insert Data Using PHP Mysqli

<form id="form1" name="form1" method="post" > <table width="445" height="394" border="1" align="center">   <tr>     <td>Name</td>     <td>            <input type="text" name="name" />     </td>   </tr>   <tr>     <td>email</td>         <td>     <input type="email" name="email" />     </td>   </tr>   <tr>     <td>address</td>     <td><textarea name="address"></textarea></td>   </tr>   <tr>     <td>mobile no.</td>     <td>     <input type="text" name="mobile" />     </td>   </tr>   <tr>     <td><input type="submit" name="submit" value="submi...