Skip to main content

Posts

How to edit or update Table values in HTML webpage using php

 How to edit or update Table values in HTML webpage using php update.php <!DOCTYPE html> <html> <head> <title>Edit/Update Data</title> </head> <body> <?php include_once('config.php'); //Fetching all data (rows or tuples) from the student_details table $roll_no = $_GET['id']; $query = "SELECT * FROM students_details WHERE roll_no=$roll_no"; $result = mysql_query($query); $row = mysql_fetch_assoc($result); $name= $row['name']; $email = $row['email']; $address = $row['address']; $phone_number = $row['phone_number']; ?> <h1 align="center">Edit/Update Data</h1> <form action="config.php" method="POST"> <table border='1px' align="center" style="width:90%;">          <tr>             <th>Roll No</th>             <td>                 <input type="text" name="roll_n...
Post a Comment
Read more

How to view Table values in HTML webpage using php

 How to view Table values in HTML webpage using php Use the code below to view the table data. view.php <!DOCTYPE html> <html> <head> <title>View Data</title> </head> <body> <?php include_once('config.php'); //Fetching all data (rows or tuples) from the student_details table $query = "SELECT * FROM students_details"; //Executing the query $result = mysql_query($query); ?> <h1 align="center">View Data</h1> <table border='1px' align="center" style="width:90%;">          <tr>             <th><center>Roll No</center></th>             <th><center>Name</center></th>             <th><center>Email</center></th>             <th><center>Address</center></th>       ...
Post a Comment
Read more

How can I save an image from a file input field using PHP & MySQL?

How can I save an image from a file input field using PHP & MySQL? <?php $image = $_POST [ 'pic' ]; //Stores the filename as it was on the client computer. $imagename = $_FILES [ 'pic' ][ 'name' ]; //Stores the filetype e.g image/jpeg $imagetype = $_FILES [ 'pic' ][ 'type' ]; //Stores any error codes from the upload. $imageerror = $_FILES [ 'pic' ][ 'error' ]; //Stores the tempname as it is given by the host when uploaded. $imagetemp = $_FILES [ 'pic' ][ 'tmp_name' ]; //The path you wish to upload the image to $imagePath = "images/" ; if ( is_uploaded_file ( $imagetemp )) { if ( move_uploaded_file ( $imagetemp , $imagePath . $imagename )) { echo "Sussecfully uploaded your image." ; } else { echo "Failed to move your image." ; } } else { echo...
Post a Comment
Read more