This tutorial is the second
This tutorial will hopefully
This simple tutorial shows
topics covered,
- mysql
part of our PHP/MYSQL series
teach you some basics of how
how to enter a data from a
connections
- error
of articles. In this episode
to access data with your PHP
web form to mySQL database
handling
- listing
we show you setting up a
scripting to gather
using the power of PHP.
databases on a server
-
MYSQL Database through
information with in a MySQL
listing tables in a
phpmyadmin and create a PHP
database.
The first step
database
- printing mysql
Script to make tables for
you need to do is get a
table fields into table
the MYSQL database and more.
basic understanding of what
header
- printing the data
MySQL is. If your site can
into the table
handle or has access to a
automatically
why should
MySQL database you should
you look at it?
- no
try using the PHP Myadmin
specific fields mentioned,
application to help you use
just point the script at a
and access your MySQL
server, db and table and
datases fast and easy.
watch it do its thing!
-
you get to reuse the code
easily
- no functions,
includes, api's or
anything
- all 100% php +
mysql code for beginners
-
runs on php4 or php5, with
any mysql version
by
tss503
Date: Jan, 04 2006 Date: Feb, 01 2004 Date: Mar, 16 2005 Date: May, 03 2005 |
MySQL Administration
If you are the root user then
This code will count the
Alright, this is a simple
correctly administering the
it will display all the
number of entries / records
little script which I got
MySQL server, including the
databases on the server, but
in a MySQL database table
from some site a while back
manipulation the privilege
if your not the root user
and then display it using
which lets you alternate
system, and making
then it will show all the
echo.
colors in a table as rows
intelligent decisions about
databases that your user has
come in from mySQL.
the capabilities
permissions for. It's a
(permissions) given to users.
really fun to play around
with and can be expanded in
a variety of ways. It's
explained in the comments.
Date: Nov, 09 1999 Date: Jun, 11 2006 Date: Mar, 10 2004 Date: Feb, 27 2004 |