Needed some help with php and mysql... - Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more

mdp88 · 12-27-2010, 02:27 PM

Hey guys,

First all let me start by saying this is a great community here, read some threads trying to learn something. But now I am stuck and had a question, hopefully you will be able to help me.

So I am trying to create a system which does the following,

A php page that will ask a user to enter a table name and add bunch of categories for that table(all entries will be text or numbers in the table) and add it to a db. Once a user does that a php script to read back the created table and the categories.

Now once he has that table setup, what he can do is see the list of the tables that he has in that db, view content of each table, add a entry to those tables via form... and possibly in future sort the content of the viewing table.

How do I go about starting with this? Anyhelp will be much appreciated

I am a novice when it comes to php and mysql. So please bear with me and my stupid questions and if you could just point me in the right direction it would be great.

after_me · 01-12-2011, 05:17 AM

You should start by making MySQL tables:

tables
with columns:
id,
table_name

and table
categories
columns:
id,
table_id (from table tables (id)),
category_name

and table "content"
with columns
id,
category_id (from category table),
content

aokiji1 · 02-24-2011, 01:44 PM

go to your mySQL and create tables first..and column names

hilhilginger · 02-24-2011, 09:45 PM

Use form to get the details from users and add this script to creat new tables.Hope you know the code to connect to your DB.

PHP Code:


			
<?php



//  Connect to your database

//  ----------------------------------

// $conn = dbconnect();



$sql = 'DROP TABLE IF EXISTS `zones`';

mysql_query( $sql, $conn );



$sql = 'CREATE TABLE `zones` (

        `zid` TINYINT( 3 ) UNSIGNED NOT NULL AUTO_INCREMENT,

        `zdesc` VARCHAR( 150 ) NOT NULL,

        `zwidth` SMALLINT( 3 ) DEFAULT 0 NOT NULL,

        `zheight` SMALLINT( 3 ) DEFAULT 0 NOT NULL,

        `zmax` MEDIUMINT(7) unsigned NOT NULL default 12288,

        PRIMARY KEY ( `zid` )

       )';

echo 'Creating table: \'zones\'....';

mysql_query( $sql, $conn );



$sql = 'DROP TABLE IF EXISTS `bcategory`';

mysql_query( $sql, $conn );



$sql = 'CREATE TABLE `bcategory` (

         `bid` int(10) NOT NULL default 0,

         `cid` int(10) NOT NULL default 0,

         PRIMARY KEY ( `bid`, `cid` )

       )';

echo 'Creating table: \'bcategory\'....';

mysql_query( $sql, $conn );



?>