Database Related Tutorials - LearnPHP.org
Writing data in web database applications requires different techniques than reading data. Issues of transactions and concurrency become important, and we introduce these issues and the principles of dealing with them in this tutorial...
November 19,
2007
Today Views:
1 Total Views:
286
Sometimes I see people attempting to use VARCHARS or CHARS to store dates in their MySQL database application. This is really fighting against MySQL, which has a variety of interchangeable date types.
November 7,
2007
Today Views:
1 Total Views:
315
A collection of 28 FAQs on Oracle SQL language basics. Clear answers are provided with tutorial exercises on data types, data literals, date and time values, data and time intervals, converting to dates and times, NULL values, pattern matches.
November 5,
2007
Today Views:
1 Total Views:
366
In this tutorial I will show you how to get your MySQL database description / layout in an XML format.
November 2,
2007
Today Views:
1 Total Views:
308
A result set object is a logical representation of data rows returned by odbc_exec() function on SELECT statements.
October 30,
2007
Today Views:
1 Total Views:
356
This - final part of this tutorial explains how to display links in defferent categories, create search engine and submission form.
October 29,
2007
Today Views:
1 Total Views:
359
If you insert multiple rows with a single INSERT statement, you can use the odbc_num_rows() function to find out how many rows were inserted.
October 26,
2007
Today Views:
1 Total Views:
344
Where an application requires certain values at runtime, and where these values may be changed at irregular intervals, it is common practice to hold these on a database record rather than having them hard-coded into any program.
October 26,
2007
Today Views:
2 Total Views:
286
Validation is essential to web database applications. Ensuring that data meets user and system requirements is important, but ensuring that the...
October 23,
2007
Today Views:
2 Total Views:
304
If want to insert rows into a table based on data rows from other tables, you can use a subquery inside the INSERT statement...
October 22,
2007
Today Views:
1 Total Views:
348
