Read news from MySQL

Managing MySQL data with PHP and use them in a simple Flash MX application.

Related Tutorials

Edit a Row In mySQL
This tutorial goes along with several others that use the same news database such as Add a Row to mySQL, Displaying a Database, and Deleting a Row In mySQL.There are many reasons you might want to edit one of the rows in your mySQL database. Say for instance, you made a spelling error in one of your news posts and you want to edit it.

PHP/MySQL News with Comments
In this tutorial, you will learn the concepts behind building a news system with PHP and MySQL.

mySQL Search Engine
This tutorial will teach you how to search a mySQL table. It goes along with several others that use the same news database such as Add a Row to mySQL, Deleting a Row, and Edit a Row In mySQL.

PHP News System
Learn the basics of Mysql & Php by building a news system.

Creating a News System with PHP - Part 2
This is the part 2 of my news system, it will teach you how to make a complete news system for your site.

News Portal
Ever wanted to post news without log in to your ftp account? Now, you can!

Add, View, Edit & Delete from to MySQL database, Live Example (News System)
This tutorial will teach you how to deal with MySQL database using php, you will add, view, edit & delete data.

latest news site
In this example we will create a database to store our news items which we will be able to add via an admin form which the webmaster will enter information . we will then display this info on our page , displayed by newest items .

Building a News Management System
Create a news system for your site.

How to connect to MySQL database using PHP
Before you can get content out of your MySQL database, you must know how to establish a connection to MySQL from inside a PHP script. To perform basic queries from within MySQL is very easy. This article will show you how to get up and running.

How to create a basic news system
How to create a basic file based news system with integrated WYSIWYG editor.

Are PHP and MySQL the Perfect Couple?
This is ore of an introductory article on PHP and MySQL covering such topics as features of PHP and MySQL, and how to use PHP to interact with MySQL.

Generating Advanced Web Page Statistics using PHP
This tutorial is intended for the PHP programmer interested in gathering and analyzing Website statistics in a presentable format using mySQL and PHP.You will need a moderate understanding of PHP and a limited knowledge of mySQL, including how to create a mySQL table using the mySQL client.

Using MySQL with PHP
This tutorial describes: How to configure PHP with a MySQL server, What are the basic functions to use a MySQL server, A test script with a MySQL server.

Full News CMS system
This is a full news cms system, its good for a small site.

Data Integrity Using MySQL and PHP (Part 2)
A continuation of the series, "Data Integrity Using MySQL and PHP," this article discusses the concept of auto_increment fields in MySQL, to cause MySQL to store a unique, incrementing integer in the field of each new row.

PHP and Mysql: Part 1
Alot of people have written in saying that the Using MySQL with PHP tutorials they've found in the internet are difficult to follow. This tutorial is our attempt at solving the confusion and providing a straight-forward explanation of how you use PHP to interact with a MySQL database.

Dumping mySQL Tables to HTML
In this tutorial we are going to expose basic mySQL queries, and how they can be used to print all data from a mySQL table into an HTML table.

PHP Sessions
Have you ever seen member systems, or did you read the little introduction to MySQL with PHP tutorial on this site? If you have, then you must be wondering how all the user data is carried from page to page.

Basic mySQL Queries And PHP
This tutorial will help you get started in working with mySQL and PHP. It will assume that you have no prior experience in using mySQL with PHP before. After reading this tutorial, you should get an idea on what a database is, how to use it, and how to access it.

Creating a News System in PHP
With this tutorial creating a news system in php.

MySql Joins
This tutorial will cover the basics of joining tables in mysql. MySql joins simply takes two tables and joins them together using a common value which they both share.

Acquiring PHP MySQL
PHP and MySQL are already packaged in Linux and Mac OS X OSs. However, most PHP developer are actually using Windows when developing PHP applications. This is also true to myself. I have Mandrake Linux 10 but I'll just use it for testing purposes of my finished scripts. One reason is that Windows render an amazing web presence unlike any other OS's browsers. So this page will only cover the WAMP ( Windows, Apache, MySQL, PHP ). You will learn how to install Apache, PHP, and MySQL under Windows platform.

Making Data Dynamic
One of the main strengths of PHP is its support for a vast number of databases. Very often, PHP and MySQL are viewed as an entity. However, other databases have their strengths, toofor instance, it took MySQL a very long time to support features that are considered standard in other systems; however, MySQL is known to be very fast.

Dynamic URLS using php and mysql
To create dynamic URL with php and mysql is quite simple and this small tutorial will teach you how very easily. If you look at Chipmunk directory, board, or CMScore, you will find that they all use Dynamic URLs with PHP/Mysql.

PHP/MYSQL Snippets
This tutorial explains the following: Opening and closing PHP tags; Connecting to a MYSQL Database; Selecting a mysql database; usage of ucfirst, ucwords, strtolower and strtoupper function, Using the date function to print different aspects of the date and time, Printing Browser Info, IP Address and hostname of the ip.

Building a Database-Driven Web Site Using PHP and MySQL
This ten part series of articles will teach you everything you'll need to build a database-driven Web site from the ground up. Main topics include: Installation, Getting Started with MySQL, Getting Started with PHP, Using PHP to access a MySQL database, Relational Database Design, A Content Management System, Content Formatting and Submission, MySQL Administration, Advanced SQL, and Advanced PHP.

Using PHP to search a MySQL database and return paged results
PHP, MySQL and a Web Server capable of parsing PHP pages, like Apache or IIS. This search script does not spider all your pages by crawling the links, so the content you want to be searchable must be within the database. Knowledge of PHP and MySQL is also necessary because this script is just the bones of a working solution.

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 through data rows, searching by key words, setting auto-increment IDs.

Data Integrity using MySQL and PHP
This is an overview of relational database concepts, specifically MySQL. It illustrate each of the concepts through simple examples.

Retrieving Paginated Results with MySQL
With MySQL, you can easily retrieve a specific set of results from within a larger recordset. This can be extremely useful if you are trying to break up a large set of results into separate pages. For instance, lets say you have 2000 records you want to display, but you would prefer to break them up into four pages of 500 results. To do this with MySQL, you write your SQL query the same way you normally would, but include the LIMIT command at the end of your query.

PHP and Javascript: Dynamic update with MySQL
In this tutorial we will create a web page that extracts data from a MySQL database without having to refresh the page.

Is it possible to repair MySql Databases using PHP?
Why yes, yes it is. Here, we attempt to devise a method of storing the structure of a MySql database and it’s individual tables in PHP.

PHP and Accessing MySQL Databases
PHP can be used for many things, including grabbing your MySQL database entries.

Pagination with PHP and MySQL
Pagination, as described in the video, is the process of breaking a bunch of results, from a MySQL Query, up into specific pages, which themselves list a set number of items each.

MySQL & PHP Basics
A breif description of each way of using a mysql database with php coding.

PHP and MySQL for beginners
Very Simple tutorial to get you start using PHP with the most popular MySQL database.

Delete a Row From mySQL
Learn how to remove a row in mySQL using the power of PHP.

Read news from MySQL

View Tutorial