getting started with sql

Itryandtry

Hi!

I've done some programming in the past but never tried to build something useful for the web and I have nver used php before or other scriptlanguage.

Got from a paper I subscribe to "Abyss Web server X1" and "Dev-PHP IDE 1.9.4" and since I friend of mine asked me earlier if I could try make a simple database with html output/input for use on his site I thought I try with the tools mentioned above.

I have tried some of the codes that are downloadable from this site but so far without any success, main problem at the moment is that I have no idea where to place the db allthought I think it's in the PHP IDE folder since that's the path known to the Abyss server? I also thought using any db would work but are probably wrong since dropping a paradox db in PHP folder at least for me doesn't work.

I haven't so far been able to locate any selftuter stuff to get me going so I try ask here for some help.

Could anyone help me with a simple create table using php/mysql so that I find out where the server put the database?

I'm hoping to build a simple inputform and also a html result table and any help is apreciated.

I'm so so comfortable with sql but know nothing at all about webdatabase/servers/php.

I copy the page that the PHP IDE launches when starting a new php scribt just in case You need to know how that page look like, none of the code samples I've found look like it so I'm not sure that placeing the samples after <?php is the right thing to do.

Copy:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="Generator" content="Dev-PHP 1.9.4">
<title>Document Title</title>
</head>
<body>
<?php

?>
</body>
</html>

regards
Itryandtry

Steveo31

Simple form:

<form action="upload.php" method="POST">
<table style="font-family:arial;" cellpadding="8">
  	<tr valign="top">
		<td>Title:</td>
		<td><input type="text" name="title"></td>
	</tr>
</table>
</form>

upload.php:

<?php 

echo $_POST['title'];

?>

Then to upload it to a database you should probably use PhpMyAdmin.. easiest way in my opinion. From phpmyadmin you can make the databases and tables, and then insert it on the upload.php page like so:

$insert = mysql_query("INSERT INTO tablename (`field1`) VALUES ('value')");
if($insert){
    echo 'Insertion ok';
}else{
    echo 'Insertion failed:  '.mysql_error();
}