Free php mysql tutorial software for linux

PHP EMS Tools project is a software for volunteer and small paid emergency medical services (EMS) organizations that provides crew scheduling, roster maintenance and printing, rig checks, maintenance reports, and other facilities in an easy-to-use Web-based package.

PHP EMS Tool is a software package for Emergency Medical Services (EMS) agencies. It allows you to maintain a monthly crew schedule, roster, record of apparatus checks, address book, count your members monthly hours, and more. It is designed to be installed on a server on the local network at your headquarters. It *can* be installed on an internet-based host, but this is not suggested, as security is very lax in the current version - it is designed to stop members from casually doing things they shouldnt, not to protect your server from the dangers of the Internet.

The current version incorporates a feature to allow the schedule, roster, and hours count to be visible from the Internet, when configured properly.

PHP EMS Tools is totally free, and open source. It is programmed in the PHP language, which most web servers support. To run PHP EMS Tools, you will need a web server (Apache recommended), the MySQL database server, PHP, and a few other pieces of software. PHP EMS Tools *should* run under any operating system that supports these packages, but is designed to be run under Linux (which is also 100% free and open source). To install PHP EMS Tools, you will need root access to the server, or will need to get the systems administrator to create a database and users for you.

PHP/Mysql Site Builder is a PHP/Mysql tool for managing your homepage, you can create dinamyc and static version of your site.
PHPBuilder is free software, released under GNU GPL Licence version 2.0
(see COPYING file for details).
PHPBuilder is the result of many ideas, and code write by Luis Claudio
Gamboa Lopes.
For installation instructions, go and read INSTALL file, also remember
to read CREDITS file to know from where comes the things. The TODO file
is the list of features that Ill add in future versions, read it also.
Please, enjoy PHPBuilder and remember that this is free GPL software and
comes without any warranty and without technical support.
PHPBuilder isnt perfect, but your suggestions and feedback can help all
us to have a very well site builder system!
Enhancements:
- PHP 4.0 and MySQL 4.0 are now supported.

PHP MySQL Database Layer Class is a php class providing some very useful methods to work with a mySQL database.
Main features:
- connects you to a mySQL host and select a database in a single call (opposed to PHPs native functions which requires two steps)
- has a "query" method that has the same role as PHPs mysql_query but this one will tell you about the affected rows (through the "affectedRows" property) when executing an INSERT, UPDATE, DELETE query and about the found rows (through the "foundRows" property) when executing a SELECT query - the "foundRows" property tells you how many records would the query return if there was no LIMIT applied to it - very useful when creating listing so you dont have to do a query to determine how many records you have in a database and the again a query to show only the records from a page
- has an "escape_string" method that will "mysql_real_escape_string" your string weather the magic_quotes are on or not
- has a "dlookup" method that i am sure you will find VERY useful once you get to know it: it return data from a single table cell based on standard mySQL WHERE criteria - see the manual for detailed info! (yes, it acts exactly like the function with the same name from microsft access)
- provides you with a very useful debug interface which shows you each query your script is running, for how long, the total number of queries made, the total execution time of your queries, errors of your queries and what are the values of $_GET, $_POST, $_COOKIES and $_SERVER superglobal variables. The debug interface is template driven and supports localisation.
- it will notify you if a specific query is executed more than once and will advise you to optimize the script
- you can instruct it to send you an email if a query runs longer then a specified time
- the code is heavily documented so you can easily understand every aspect of it and even maybe use it as a php tutorial
Enhancements:
- the state of $_FILES and $_SESSION superglobals are now also shown in the debug window
- better integration with XTemplate (previously, there was a variable assigned to each entry in the language file now the XTemplates feature to handle arrays is used)
- properties will now have default values in PHP 4

KDE Simple Programming Tutorial is a tutorial for developing a KDE application.

With the only requirement of a little C++ knowledge, and using the latest KDE snapshots, the reader will learn how to build his/her first KDE application from a simple "Hello world" button to a Web browser with a DCOP interface that communicates with a bookmark application running in a separate process.

Theres also a spanish and a romanian version of the documentation.

php syslog viewer is a free web application written in PHP for viewing and searching system logs stored in a MySQL database.
Good system administrators review the logs from each system they administer. As the number of systems gets bigger, this becomes a more complex and time consuming task. Eventually the system administrator would like a way to combine the log messages from all of the systems into one central location, but that is not enough. Without a good search facility, finding the information the system administrator needs is like finding a needle in a haystack.
This is where php syslog viewer comes to the rescue. Using a few common Free Software tools (syslog-ng, stunnel, MySQL, apache, and php), php syslog viewer provides a total solution for centralized logging and log management. Client systems send their log files to a server which stores them in a database. php syslog viewer provides the system administrator with a view into that database. php syslog viewer also includes a tool for optimizing searches and archiving older data so that it takes up less room on the disk.
php syslog viewer is Free Software licensed under the GNU GPL (version 2 or later) as published by the Free Software Foundation.
Main features:
- Log Searching
- Real Time Log Viewer
- Automatic Log Rotation
- User Authentication Possibilities
- LDAP
- Active Directory
- Built-in Authentication
- 3rd Party Client API (outputs XML)
- OSI Certified Open Source Software
- Log Archiving

PHP mySQL Database Wrapper Class provides a set of methods for interacting with a MySQL database easily and securely. Most of the methods are extended versions of PHPs native functions, but providing a lot more functionality and powerful debugging features.
There are also new methods that greatly simplify the process of executing specific queries like returning specific rows or even single values from specific rows, SUM(), COUNT(), and MAX() queries.
Enhancements:
- The result of select queries can now be cached.
- All records returned by SELECT queries were shown in the debug window, which would crash the script if there were lots of rows.
- The "showMaxRows" allows you to restrict this number.
- A bug when working with queries using replacements and having apostrophes in the replacements was fixed.
- Due to a typographical error, no error message was shown if a database could not be selected.
- New methods were added: "delete", "truncate", "insert", and "update" which are all shorthand for performing the respective SQL tasks.

PHP Mini SQL Admin is a light, standalone script for accessing MySQL databases. PHP Mini SQL Admin is intended for Web developers and requires knowledge of SQL commands.

PHP TopSites provides a PHP/MySQL-based customizable TopList script.
PHP TopSites is a PHP/MySQL-based customizable TopList script. Main features include: Easy configuration config file; MySQL database backend; unlimited categories, Site rating on incoming votes; Special Rating from Webmaster; anti-cheating gateway; Random link; Lost password function; Webmaster Site-approval; Edit site; ProcessingTime display; Cookies Anti-Cheating; Site Reviews; Linux Cron Free; Frame Protection and much more.
Main features:
- Unlimited Number of Sites.
- Unlimited Number of Categories.
- Unlimited Number of Reviews for Each Site.
- Administrator Control Panel.
- Rating for Each Site.
- Stars Rating for Each Site.