In this tutorial, we will explain How to insert data into Mysql database using PHP. If you want to save the record in one place then insert the data into the database. Below Steps: index.php <form method="post" action="insert.php" enctype="multipart/form-data"> <div class="name"> <div class="name1"><h1>Student Name:</h1></div> <div class="name2"><input type="text" name="name" value="" /></div> </div> <div class="name"> <div class="name1"><h1>Father […]
How to Fetch Data From Mysql Database using PHP, from inserted data in Mysql database. HTML Code <div class="table"> <div class="tab1"><h1>Name</h1></div> <div class="tab1"><h1>Father name</h1></div> <div class="tab1"><h1>Mother name</h1></div> <div class="tab1"><h1>E-mail</h1></div> <div class="tab1"><h1>Address</h1></div> <div class="tab1"><h1>DOB</h1></div> <div class="tab1"><h1>Category</h1></div> <div class="tab1"><h1>Image</h1></div> <div class="tab1"><h1>Action</h1></div> <div class="tab1"><h1>Delete</h1></div> <?php $query1 = "select * from table"; $query2 = mysql_query($query1); while($row = mysql_fetch_array($query2)) { […]
In this tutorial, we will explain how to Delete Data from Mysql database which is already inserted in the database using PHP. table.php <?php include(db.php); ?> <html> <head> <title>Table</title> </head> <body> <div class="table"> <div class="tab1"><h1>Name</h1></div> <div class="tab1"><h1>Father name</h1></div> <div class="tab1"><h1>Mother name</h1></div> <div class="tab1"><h1>E-mail</h1></div> <div class="tab1"><h1>Address</h1></div> <div class="tab1"><h1>DOB</h1></div> <div class="tab1"><h1>Category</h1></div> <div class="tab1"><h1>Image</h1></div> <div class="tab1"><h1>Action</h1></div> <div class="tab1"><h1>Delete</h1></div> <?php […]
Today we will guide you How to Update Data into Database using PHP and MySQL. index.php <html> <head> <title>Update Data</title> </head> <body> <form method="post" action="update.php" enctype="multipart/form-data"> <div class="name"> <div class="name1"><h1>Student Name:</h1></div> <div class="name2"><input type="text" name="name" value="<?php echo $row['name']; ?>" /></div> </div> <div class="name"> <div class="name1"><h1>Father Name:</h1></div> <div class="name2"><input type="text" name="father_name" value="<?php echo $row['father_name']; ?>" /></div> […]
We will tell you how to connect the database in PHP. In any PHP file for insert/Delete/update/fetch data from Mysql database. we have to create a connection with the Mysql database. This connection will be the type of the database is Mysql. Follow the bellow Code to creating a connection with the Mysql database. Method […]
In this article, How to File Upload in Database using PHP. Follow below Steps: HTML Code: file.php <html> <head> <title>File Upload</title> <form method="post" enctype="multipart/form-data" action="upload.php"> <input class="tbl2" type="file" name="f"><span class="txt1">(Type : .jp/* /* eg, .jpg, .gif, .png)</span> <input class="butt2 bt" type="submit" value="save" name="save"> </form> </body> </html> PHP Code: upload.php <?php include('db.php'); if(!empty($_REQUEST['save'])) { $st2=1; $filename=$_FILES['f']['name']; […]
Why need status active and inactive in PHP? Making any task, user, or function active or inactive is the most important part and essential feature of any web application or website. It is also known as blocking or unblocking of user accounts. Some times user performs irrelevant activities and the ones required to deactivate his […]
In this article, we will explain how to create a login system in PHP using a session. ['username']!=$username && $row['password']!=$password) { $error="<p>Wrong User Name and Password</p>"; } if(isset($error)) { echo $error; } else{ require('db.php'); session_start(); $result =mysql_query("select * from users where username='$username' and password='$password'"); while($row=mysql_fetch_array($result)) { $_SESSION['username']=$row['username']; echo"<script>window.location.href='../invoice/'</script>"; } } } ?> db.php <?php mysql_connect('localhost','root',''); […]
This article, you will learn How to Import Data in PHP using Mysql Database. index.php <html> Mhead> <title>Import Data in PHP</title> </head> <body> <form action="import.php" method="post" name="upload_excel" enctype="multipart/form-data"> <fieldset> <legend>Import CSV/Excel file</legend> <div class="control-group"> <div class="control-label"> <label>CSV/Excel File:</label> </div> <div class="controls"> <input type="file" name="file" id="file" class="input-large"> </div> </div> <div class="control-group"> <div class="controls"> <button type="submit" id="submit" […]
In this article, you will learn How to Make Fees Receipt in PHP Using Mysql Database. index.php <html> <title>Add fees</title> </head> <body> <h1><a href="add.php">Add receipt</a>       <a href="search.php">Record</a></h1> <form method="POST" oninput="x.value=parseInt(a.value)+parseInt(b.value)+parseInt(c.value)" action="fees.php"> <input type="date" name="date"><br/><br/> Name <input type="text" name="name"><br/><br/> Registration No. <input type="number" name="rno"><br/><br/> Course <select name="course"> <option>Select Course</option> <option value="PHP">PHP</option> <option value="JAVA">JAVA</option> […]