help please i am a newbie

craig_thompson

i have an sql database setup and can connect to it useing php. but i am unable to add records to the data base

i understand this is a lot to ask for but does anybody have the code i need to insert into my page to allow the feilds to be inputed into the database and also the code to get the user name back onto the log in page

also how do i LOCK a page until somebody has logged in ?

i would apreciate any help anybody can give me thanks

benracer

To connect to your db you could use some thing like this...

<?php
$connection = mysql_connect("host", 
                            "username", 
                            "password");
mysql_select_db("database name", $connection);
?>

For the user login look here...
http://www.phpeasystep.com/phptu/6.html

cheese62

I use something like this

<?php

// this is the connector
$sql_server = "localhost";
$sql_username = "username";
$sql_password = "password";
$sql_database = "databasename";
global $sql_server;
global $sql_username;
global $sql_password;
global $sql_database;
$link = mysql_connect($sql_server, $sql_username, $sql_password)
or die("Could not connect : " . mysql_error());
mysql_select_db($sql_database) or die("Could not select database");

// this is the query
$query = mysql_query("SELECT * FROM 'yourtable'");

// this will make a table from your results with 3 columns

print "<table>";
print "<tr><td>column1</td><td>column1</td><td>column1</td></tr>";

// this will return rows of data until no more data is available - LIMIT x can be used to limit the number of rows returned (x is a number)

while ($row = mysql_fetch_array($query, MYSQL_NUM))

{

print "<tr><td>" . $row[0] . "</td><td>" . $row[1] . "</td><td>" . $row[2] . "</td></tr>";

}

print "</table>";
?>

bradgrafelman

@: There's several things about that code that I would question, such as why you have [man]global[/man] calls when you're already in the global scope, or why you assume a table has at least three columns, or why the first three columns should be displayed, or why "column 1" tells the user anything informative, etc. etc. Most of all... how does that code snippet help answer the OP's question?

@.thompson: You are correct in thinking that's a rather large question/series of questions. I would recommend you first take a look at some simple MySQL tutorials.

cheese62

If you say so.

Neil.