Scroll page back to the top

PHP and MySQL Tutorials

In-line record update with jQuery and PHP

In-line record update with jQuery and PHP

In this tutorial I'm explaining how to create an in-line editing option for your records where by clicking on part of the text on the page - text is replaced by the input or textarea and on 'blur' event record is updated using jQuery post() method and PHP.

Time: 27:54 min

Sebastian Sulinski on 19th Jan 2012

Watch now!
Simple commenting system with PHP and jQuery

Simple commenting system with PHP and jQuery

In today's series we'll be learning how to create a simple commenting system to allow visitors to leave their feedback on any section of the website.

Time: 37:43 min

Sebastian Sulinski on 6th Jan 2012

Watch now!
Slice and sort arrays with PHP

Slice and sort arrays with PHP

Today we will have a look at how to return only a portion of array based on the start and end index using PHP's array_slice() function. We will also learn how to sort an array in the ascending or descending order.

Sebastian Sulinski on 4th Jan 2012

Read now!
Multilingual Content Management System with PHP, MySQL and jQuery

Multilingual Content Management System with PHP, MySQL and jQuery

This series will take you through the steps of creating a Multilingual Content Management System with Object Oriented PHP, MySQL and jQuery.

The system will allow you to manage the content of the pages, navigation, languages, labels, label types and users - all in different languages.
Both, the front and the back end of the system will have an option to change the language of the user interface, so that visitor as well as administrator will be able to pick the language they are familiar with.

The CMS will be integrated with the CKEditor, PDW File Browser and Swift Mailer library for sending SMTP emails via our contact form.

We will create a number of objects (classes) such as:

  • Url - responsible for creating and processing static urls
  • Database - PDO wrapper class for interactions with the database
  • Paging - to allow us apply pagination to the long lists of records
  • Language - for managing all languages and populate records associated with the selected language
  • Validation - to easily perform the from validation
  • and more...

Time: 541:83 min / Price: £113.00

Buy as part of a bundle!

Sebastian Sulinski on 29th Nov 2011

PreviewAdd to the basket
Save search requests to MySQL database

Save search requests to MySQL database

In this tutorial we will have a look at the way of saving search requests submitted through the online search form into the MySQL database using PHP PDO and INSERT INTO ... ON DUPLICATE KEY UPDATE MySQL statement.

Time: 14:03 min

Sebastian Sulinski on 25th Nov 2011

Watch now!
Late Static Bindings in PHP 5.3

Late Static Bindings in PHP 5.3

Today we will have a look at the feature that came with PHP 5.3 called Late Static Bindings, which allows us to reference the calling class when using the inherited methods of the parent classes.

Sebastian Sulinski on 24th Nov 2011

Read now!
Generate xml file with PHP DOMDocument class

Generate xml file with PHP DOMDocument class

Today we will learn how to generate the xml file using an array containing some urls and PHP class called DOMDocument, which is part of the DOM extension.

Sebastian Sulinski on 3rd Nov 2011

Read now!
Timezone with PHP and MySQL

Timezone with PHP and MySQL

In this tutorial we will have a look at how we can change the timezone settings for your application within PHP and MySQL.

Sebastian Sulinski on 31st Oct 2011

Read now!
Enforce 'www.' on domain name with .htaccess

Enforce 'www.' on domain name with .htaccess

Today we will have a look at how we can enforce 'www' on the domain name. When someone types: domain.com it will automatically convert it to www.domain.com.

Sebastian Sulinski on 27th Oct 2011

Read now!
Date range with PHP DateTime, DateInterval and DatePeriod

Date range with PHP DateTime, DateInterval and DatePeriod

Today we will take a look at how we can generate an array with the range of dates using the PHP's DateTime, DateInterval and DatePeriod classes.

Sebastian Sulinski on 19th Oct 2011

DemoRead now!
Page 1 of 5