PHP Tutorials : Rename a mysql table
Jul 15, 2009 Php & MySQL
If you want to rename a mysql table via php you just need an extremely simple query like the following one:
<?php
//include db credentials
mysql_query(“rename table TheOldName to TheNewName”);
?>
Read PHP Tutorials : Rename a mysql table »
Tags: mysql rename table, php rename mysql table, rename database table, rename mysql table, rename table
PHP Tutorial : Mysql Dump
May 8, 2009 Php & MySQL
Did you see this expression and doubt what it means? Mysql Dumps are files in different extensions/formats like .sql, .txt etc. which are used to store databases informations, table structures, mysql tables creations, table datas/entries and more. The mysql dumps are usually used to make a backup, transfer a website database when switching hosts for…………….
Read PHP Tutorial : Mysql Dump »
Tags: mysql dump, mysql dumps, mysqldump
PHP Tutorial : Extracting rows from mysql
May 8, 2009 Php & MySQL
Helllooooooo,
In latest two posts I have shown you how to connect to a mysql database via PHP, and in another one I teach you how to select rows from a mysql database table. In this one I will show you how to extract that rows from mysql and print them out into a page. Let’s…………….
Read PHP Tutorial : Extracting rows from mysql »
Tags: extracting rows, Extracting rows from mysql, mysql, mysql extract, mysql fields, mysql loop, mysql print, mysql print rows fields, mysql rows, rows
PHP Tutorial : Building a MySQL query
May 3, 2009 Php & MySQL
In a recent tutorial I was showing you how to build a connection to MySQL database via PHP. In this one I will show you how to create a query to interogate a table of the database. Look below :
<?php
$query = mysql_query(“select * from table_Name”);
?>
* – sign means all, so by using this query, you…………….
Read PHP Tutorial : Building a MySQL query »
Tags: mysql, mysql interogate, mysql select, mysql select table fields, mysql table, mysql_query, query
PHP Tutorial : Connecting to MySQL database via PHP
Apr 30, 2009 Php & MySQL
In this tutorial I will speak first time about php programming language and MySQL database engine togheter. I will show and explain how simple is to connect to a mysql server via php using a simple functio called mysql_connect().
mysql_connect(‘localhost’, ‘mysql_database_user’, ‘mysql_db_password’) or die(“not connected to db”);
