Categories
PHPTips and Tutorials → Database-Related

Paging Results in PHP

Following examples teaches how to query a mySQL database and getting results in pages. Every page displays results maximum 10 results in a single page.
  • Platforms
    • Linux,
    • Windows,
    • FreeBSD,
    • Mac OSX,
    • Sun Solaris
  • Licenses
    • Freeware
DETAILS

Connecting,Inserting Data && Showing data from Mysql Databse

This is an Easy Tutorials for Beginners of PHP. With this tutorial you will learn how to Connect to Mysql Databse,Insert Data into Mysql Database and Show data from Mysql Databse.
  • Platforms
    • Windows
  • Licenses
    • Freeware
DETAILS

How to create and populate a database in your PhpMyAdmin

In some content management scripts case one needs to create a database and also populate it (insert the tables from the example .sql file). It''s the case of PhpNuke for example. You will learn here to create a new database in phpmyadmin ...
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

How to install a local server. Tutorial for PHPDEV

For those working on php and mysql a server is mandatory. But what if you cannot have a place to upload and modify or maybe you just want to develop your project privately and then install online? This is the moment a local server is needed. Yo...
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

PHP Script Tips - Working with MySQL Database

A collection of 21 tips on working with MySQL database. Clear explanations and tutorial exercises are provided on connecting and selecting MySQL database, creating and dropping tables, inserting, updating, and deleting rows, selecting and looping thr...
  • Platforms
    • Linux,
    • Windows,
    • FreeBSD,
    • Mac OSX,
    • Sun Solaris
  • Licenses
    • Commercial License,
    • Free for non-commercial use
DETAILS

Useful String Manipulation

The correct usage of PHP strings is essential when dealing with database queries submitted from User Forms, such as User Registration. Find out how to format strings before saving them in a database in this helpful tutorial.
  • Platforms
    • Linux,
    • Windows,
    • FreeBSD
  • Licenses
    • Other Free / Open Source License
DETAILS

Check Database Permissions

If you are the root user then it will display all the databases on the server, but if your not the root user then it will show all the databases that your user has permissions for. It''s a really fun to play around with and can be expanded in a ...
  • Platforms
    • Linux
  • Licenses
    • GPL
DETAILS

Basic mySQL Queries And PHP

Learn how to issue basic mySQL queries using PHP and how to properly validate SQL queries before issuing them to the database server to prevent possible attacks or unauthorized access
  • Platforms
    • Linux,
    • Windows,
    • FreeBSD
  • Licenses
    • Other Free / Open Source License
DETAILS

Alternating row colours

shows you how to generate a table with alternating row colours from a MySQL databse.
  • Platforms
    • Linux,
    • Windows,
    • FreeBSD,
    • Mac OSX,
    • Sun Solaris
  • Licenses
    • Freeware
DETAILS

SQLite Introduction

This article is intended for PHP programmers interested in learning about the SQLite extension. The article will introduce the reader to the functionality offered by the PHP SQLite extension,and overview the benefits of SQLite in relation to other da...
  • Platforms
    • Linux
  • Licenses
    • Other Free / Open Source License
DETAILS

Page:
©2003-2019 jCay.com