Search Tutorials

Foss : PHP and MySQL - English

MySQL (Part 7) Changing the existing values of the databse table using HTML Forms. Update unique records using the id than individual values.

Foss : PHP and MySQL - English

MySQL (Part 6) Getting data from the database with the help of an HTML form. Creating a FORM where a user can specify a name and selecting the appropriate value from the database.

Foss : PHP and MySQL - English

MySQL (Part 8) DELETE QUERY - To Delete the specific or all the entries of the Database. DELETE FROM table_name WHERE field='xyz' // Deletes the entry from the database where the field = xyz.

Foss : PHP and MySQL - English

MySQL (Part 1) An Introduction to the PHPMyAdmin Interface. Creating a New Database Creating a new Table and entering the value of the field with the requisite datatype. SQL Query displayed in t..

Foss : PHP and MySQL - English

MySQL (Part 2) Connecting to the database and inserting dummy data into the database. mysql_connect("server_addr", "username", "password") - Connect to the Database Server with the authorised user..

Foss : PHP and MySQL - English

MySQL (Part 3) Writing some data into the database (INSERT and UPDATE Queries). mysql_query('TYPE_HERE_YOUR_MYSQL_QUERY') - This function is used to run specific queries on our database. INSERT Q..

Foss : PHP and MySQL - English

MySQL (Part 5) mysql_fetch_assoc — Fetch a result row as an associative array. array mysql_fetch_assoc ( resource $result ) //Returns an associative array that corresponds to the fetched row and m..

Foss : Netbeans - English

Connecting to a MySQL Database Configuring MySQL server properties Starting the MySQL server Creating and connecting to the database Creating database tables under which two method..

Foss : PHP and MySQL - English

MySQL (Part 4) Getting data from the database table and displaying it. SELECT QUERY - SELECT * FROM table_name WHERE att1='abc' // Query returns the value from the database where att1 = abc mysql..

Foss : PHP and MySQL - English

XAMPP in Windows Installing XAMPP in Windows XAMPP is a cumulative package consisting of Apache, PHP and MySQL Packages is available for Windows In this tutorial the XAMPP will be installed and t..

Foss : LibreOffice Suite Base - English

Indexes Table Filter SQL Command window How to open index window Firing query of mysql insert,update,delete Firing query of mysql create table,drop table and alter statements

Foss : PERL - English

1. Installation of Perl 5.14.2 on Ubuntu Linux Installing XAMPP in Linux (XAMPP is a cumulative package consisting of Apache, PERL, PHP and MySQL Packages is available for Linux) ..

Foss : PHP and MySQL - English

XAMPP in Linux Installing XAMPP in Linux XAMPP is a cumulative package consisting of Apache, PHP and MySQL Packages is available for Linux In this tutorial the XAMPP will be installed and the def..

Foss : Moodle Learning Management System - English

System requirements for installing Moodle Check for XAMPP PHP version check MySQL(MariaDB) version check Solve the error message "Unable to connect" and start XAMPP service Solve the error messa..

Foss : Joomla - English

Prerequisites List of the supporting software - PHP, MySql, Apache with their versions Server Environment Web server distribution - XAMPP, LAMP (link to XAMPP tutorial on spoken-tutorial.org) ..

Foss : PHP and MySQL - English

User Registration Part 1 Creating a form which allows user to input values in page

Foss : Joomla - English

Prerequisites List of the supporting software - PHP, MySql, Apache with their versions Server Environment Web server distribution - XAMPP, LAMP (link to XAMPP tutorial on spoken-tutorial.org) ..

Foss : PHP and MySQL - English

User Registration Part 2 Striping tags of inputed strings and converting password into md5 encryption. Use of : strip_tags(strigs) - cuts down unnecessary spaces,html tags and queries from string.

Foss : PHP and MySQL - English

User Password Change Part 1 We learn to obtain old existing password and new password from the user. start_session() - Hold information from previous pages to session page. $variable_name=$_SESSI..

Foss : PHP and MySQL - English

User Password Change Part 2 Checking whether encrypted old password matches with the database password and new password is same as confirm password. md5("parameter")- encrypts parameter into irrev..