PHP 5.6 Tutorial

Introduction to MYSQL

Introduction to MYSQL Database Management System (DBMS) is used to store, retrieve, and modify the data. A good database engine serves as connector between you and your data, organizing and cataloging the data for quick and easy retrieval. Database Architectures Before you work with database, you need decide on which database you want to experiment. …

Introduction to MYSQL Read More »

Adding Data to a Table

Adding Data to a Table To insert the data in a Table related to the courses use the SQL INSERT statement. INSERT INTO table VALUES (value1, value2, …); This inserts values into each of the fields of the table, in the order that the fields were created. Alternatively, you can create a row with only …

Adding Data to a Table Read More »

Reading data In MYSQL

Reading data In MYSQL Here , we will study how to read data from the database. To read the data from the database use the SELECT statement. To send SQL statements to the MySQL server, a user need to use the query method of the PDO object: $conn- > query ( $sql ); If the …

Reading data In MYSQL Read More »

Connecting PHP with MYSQL

Connecting PHP with MYSQL Here, you will learn how PHP Script communicates with MySql. At the time of writing, PHP provides two main ways to connect to MySQL databases: i)mysqli (MySQL improved) — This extension is specifically attached to MySQL, and provides the most complete access to MySQL from PHP. It gives both procedural -oriented and …

Connecting PHP with MYSQL Read More »

Inserting Records In PHP

Inserting Records In PHP Here, you will how to insert a row of data. INSERT INTO table VALUES ( value1 , value2 , … ); If a user wants to Inserting Records In PHP only some values, leaving NULLs or other default values in the remaining fields, use: INSERT INTO table ( field1 , field2 …

Inserting Records In PHP Read More »

Updating Records In PHP

As with inserting new records, updating records via the PHP script is simply a case of using PDO::query() .if a user is passing literal values in the UPDATE statement, or PDO::prepare() with placeholders. For example, the following script changes the email address field in the “ Aman nagpal ” record. <?php $dsn = “mysql:dbname=mydatabase”; $username …

Updating Records In PHP Read More »

Building a Member Registration Application form In PHP

Building a Member Registration Application Form In PHP Here, we will create a simple registration form in PHP and mysql. Registration form is created for all online small website to a big websites. Registration means providing necessary information to the website for further activities. The website will store all the information into their database and …

Building a Member Registration Application form In PHP Read More »

Creating HTML forms In PHP

Creating HTML forms In PHP An HTML form or Web form is simply a collection of HTML elements inserted within a standard Web page. By adding different types of elements, you can create different form fields, such as text fields, pull-down menus, checkboxes, and so on. All Web forms start with an opening <form> tag, …

Creating HTML forms In PHP Read More »

Capturing Form Data with PHP ($_GET, $_POST, $_REQUEST)

Capturing Form Data with PHP ($_GET, $_POST, $_REQUEST) The form’s action attributes needs to contain the URL of the PHP script that will handle the form. Example < form action=”form_handler.php” method=”post” > To read the data from a form, a user use a few superglobal variables.A superglobal is a built – in PHP variable that …

Capturing Form Data with PHP ($_GET, $_POST, $_REQUEST) Read More »

Scroll to Top