Categories
Tags → Example For Sql

Simple csv to MySQL tool

This code will take a csv file and create or, insert or update, the data into a MySQL database. It assumes the first line contains the field names and uses that to build the SQL query for the following data lines. There''s a download button fo...
DETAILS

Syndikut - Mail Me Commercial v1

Syndikut Mail Me Commercial is an easy to edit flat file, php contact form script packed with useful features. MMC allows your visitors to contact you using a simple easy to customize form. MMC is 100% flat file so no SQL database required! When a vi...
DETAILS

MyPagina (pagination) class

The page navigation (pagination) of lists with records from a (MySQL) database is often used on a lot of dynamic websites. This class is extremely easy to use in your existing application: just use your own SQL statement and voila you get information...
DETAILS

Using SUM Function in An SQL Statement

Sum function can be used for to get the sum of a numeric expression evaluated over a set. This function must be placed in an SQL statement. Following example will return the sum of ratings in articles.
DETAILS

Formatting Date/Time value in SQL query

Learn how to use MySQL embedded function to format Date/Time field value just right in the SQL query string. For example another way is to use PHP, but it is slower and inconvenient. This tutorial will show you both examples for the same goal.
DETAILS

Appgini PHP Generator For MySQL

Appgini PHP Generator For MySQLInstantly create multi-user PHP web database interfaces that let users view, sort, search and edit data of a MySQL database easily from a single web page. You have total control over how users can interact with your data. Display database contents to...
DETAILS

Generating RSS with ASP

RSS files can be generated using Active Server Pages (ASP). It is OK for an RSS file to have a .asp suffix. In this example an RSS 0.91 file is generated, but it could easily be applied to other RSS versions. Similarly in this case the site stores it...
DETAILS

Display an Excel DB

The author writes &"For small data bits on a server where the chance for significant simultaneous traffic is not likely excel can perform many of the basic tasks that can be accomplished in Access or SQL Server, but on a much smaller scale.&...
DETAILS

Data Goes In, Data Comes Out This Time it''s Binary

This setp-by-step article explains how to create a database-driven image uploading and display system in PHP. The example database used being MySQL, it also discusses possible modifications for MS SQL and Oracle. Some of the main topics include: Crea...
DETAILS

MP3SQL

MP3SQL is an product that generates and file with SQL commands. These commands are for adding the information that have been extracted out of your MP3 files. This archive also includes some scripts to easy add several CD-Roms containing MP3s. There i...
DETAILS
©2003-2019 jCay.com