Home » Archives
Simple Visitor Counter Using php
Written on 6 Jul, 2010 at 2:10 in Mysql, PHP, scripts | viewed This Post Has Been Viewed 64 Times. times | 0 Comments
This tutorial require 1 PHP file and 1 table of mySQL database. 1. counter.php 2. Database “mypage” and table “counter” with 1 fields: visitor(Int, 11). You need to insert a first one record with “0″. Counter.php Source Code < ?php // For using session variables put... (Continue reading)
Export MySQL to CSV (Excel) using php
Written on 6 Jul, 2010 at 2:01 in Mysql, PHP, scripts | viewed This Post Has Been Viewed 121 Times. times | 0 Comments
You can export your MySQL database to .csv file format (Microsoft Excel file) easily using php. This tutorial require 1 PHP file and 1 table of mySQL database. 1. exportcsv.php 2. The table is with 2 fields: id(auto_increment), name(varchar, 50) and put some... (Continue reading)
Import large files in mysql using PhpMyAdmin
Written on 27 Jun, 2010 at 23:17 in Mysql, PHP | viewed This Post Has Been Viewed 161 Times. times | 0 Comments
Sometimes when trying to upload some huge SQL file using PHPMYADMIN we might come across this ERROR MESSAGE Error: You probably tried to upload too large file. Please refer to documentation for ways to workaround this limit There is simple a fix for this:- Find the config.inc.php file... (Continue reading)
Fix Too many connections mysql_connect
Written on 23 Jun, 2010 at 19:13 in Mysql, PHP | viewed This Post Has Been Viewed 139 Times. times | 0 Comments
If you get a Too many connections error when you try to connect to the mysq server, then it clearly means that all available connections are in use. Too Many Connections can be caused by either a lot of simultaneous connections... (Continue reading)
Php mysql example image gallery blob storage
Written on 8 Feb, 2009 at 18:54 in Mysql, PHP | viewed This Post Has Been Viewed 4,803 Times. times | 0 Comments
abstract This is a simple example of photo-gallery script, which uses MySQL table (BLOB field) to store images. Trivial password-protection, uploading and deleting images are supported. For Apache-version of PHP there is advanced browser-caching support (using If-Modified-Since header). compatible PHP 4.3.0 or higher PHP 5 There are... (Continue reading)
Hot Topics in Mysql
- Php mysql example image gallery blob storage - 4,803 views
- Total Number Of Rows In MYSQL - 1,104 views
- How to run a SQL query in phpMyAdmin - 381 views
- Import large files in mysql using PhpMyAdmin - 161 views
- Fix Too many connections mysql_connect - 139 views
- Export MySQL to CSV (Excel) using php - 121 views
- Simple Visitor Counter Using php - 64 views
