sql database

redhippo · 11-07-2004, 08:46 PM

just a noob question

how do i insert data to a sql database?

what parameters are required?

Peter · 11-07-2004, 09:32 PM

the easiest way to input data into a mysql database is too use phpmyadmin http://www.phpmyadmin.net/home_page/ (if you use cpanel it is already there for you in your cpanel just go to the mysql database area and at the botton there is a link)

If you are installing a package they ussually give you a .SQL file which is filled with sql queries that should be uploaded to the database (if they dont give you an installer that is) Alternatively they may provide you with the idnividual queries that can be input in the text box in the sql page of phpmyadmin

redhippo · 11-07-2004, 09:41 PM

can you help out or anybody free to do so??

CreativeLogic · 11-07-2004, 10:31 PM

You should really do some reasearch. I will tell you how but you probably won't understand most of it. Here is a simple PHP query:

mysql_query("INSERT INTO table_name (column1, column2) VALUES($value1, $value2)");

That'll work most of the time. You may need to add slashes or sometimes it's better to do something like this:
mysql_query("INSERT INTO table_name (column1, column2) VALUES(" . $value1 . ", " . $value2 . ")");

And even more. It's best to put `` around column1 and column2 but not required. The reason for this is if you put spaces in the column names which is HIGHLY frowned upon. Also if you name a column a MySQL function. I've done this before and it's given me hours of headaches. Now its the first thing I check for.

lfrias · 11-08-2004, 06:43 AM

have you tried phpMyAdmin?

if you want to insert thru php then you would do something like

mysql_query("insert into news set title='news title', author='news author' ");

you would insert a news title and a news author to a table called news and in which exist two fields: title and author.

11-07-2004, 08:46 PM	#1 (permalink)
redhippo NamePros Expert Join Date: Oct 2003 Location: ANForum Posts: 5,244 3,630.35 NP$ (Donate)	sql database just a noob question how do i insert data to a sql database? what parameters are required? __________________ \|www.vb-skins.com\|- Quality Premade Vbulletin skins for Your VB forum makeover \|www.Banjir.com\|-Free image hosting?[B]For Sale!\|AlphaScripts\|Money Generating Scripts FREE VB Skins

11-07-2004, 09:32 PM	#2 (permalink)
Peter Senior Member Join Date: Nov 2003 Location: Scotland Posts: 4,900 0.60 NP$ (Donate)	the easiest way to input data into a mysql database is too use phpmyadmin http://www.phpmyadmin.net/home_page/ (if you use cpanel it is already there for you in your cpanel just go to the mysql database area and at the botton there is a link) If you are installing a package they ussually give you a .SQL file which is filled with sql queries that should be uploaded to the database (if they dont give you an installer that is) Alternatively they may provide you with the idnividual queries that can be input in the text box in the sql page of phpmyadmin __________________ Manage your portfolio using my new Domain Portfolio Management script. Securing Your Domain Name From Theft

11-07-2004, 09:41 PM	#3 (permalink)
redhippo NamePros Expert Join Date: Oct 2003 Location: ANForum Posts: 5,244 3,630.35 NP$ (Donate)	hEEEEEEEEEEEEEEEEEElp can you help out or anybody free to do so?? __________________ \|www.vb-skins.com\|- Quality Premade Vbulletin skins for Your VB forum makeover \|www.Banjir.com\|-Free image hosting?[B]For Sale!\|AlphaScripts\|Money Generating Scripts FREE VB Skins

11-07-2004, 10:31 PM	#4 (permalink)
CreativeLogic NamePros Regular Join Date: Sep 2003 Posts: 894 138.00 NP$ (Donate)	You should really do some reasearch. I will tell you how but you probably won't understand most of it. Here is a simple PHP query: mysql_query("INSERT INTO table_name (column1, column2) VALUES($value1, $value2)"); That'll work most of the time. You may need to add slashes or sometimes it's better to do something like this: mysql_query("INSERT INTO table_name (column1, column2) VALUES(" . $value1 . ", " . $value2 . ")"); And even more. It's best to put `` around column1 and column2 but not required. The reason for this is if you put spaces in the column names which is HIGHLY frowned upon. Also if you name a column a MySQL function. I've done this before and it's given me hours of headaches. Now its the first thing I check for. __________________ Online Time Tracking :)

11-08-2004, 06:43 AM	#5 (permalink)
lfrias NamePros Member Join Date: Sep 2003 Posts: 162 90.00 NP$ (Donate)	have you tried phpMyAdmin? if you want to insert thru php then you would do something like mysql_query("insert into news set title='news title', author='news author' "); you would insert a news title and a news author to a table called news and in which exist two fields: title and author.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)