Re: im so stupid
| From: | Todd Williamsen | Date: | Mon, 11 Feb 2002 16:51:06 +0000 |
| Subject: | Re: im so stupid | ||
| References: | 1 2 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-11969@lists.php.net to get a copy of this message | ||
Afan...
First off, to make things easier and since you are calling register.php in
your form...
Just make a plain HTML page like this and name it whatever the hell you want
<html>
<head></head>
<body><form method="post" action="registrer.php">
Fornavn: <input type="text" name="fornavn"><br>
Etternavn: <input type="text" name="etternavn"><br>
<input type="Submit" name="submit"
value="Registrer"><br> </form>
</body>
</html>
Then make your registrer.php page:
$db = MSSQL_CONNECT($hostname,$username,$password);
mssql_select_db($dbname);
$sql = "insert into studenter(fornavn, etternavn) values
('$fornavn','$etternavn')";
$result = mssql_query($sql, $db);
<html>
<head>
<title>Success!</title>
<body>
<h2>You have successfully entered the following information <? echo
"$fornavn<br> $etternavn"; ?></h2>
</body>
</html>
"Afan Pasalic" <afan@sprout.net> wrote in message
news:005601c1b310$fa19ad80$311f49d1@VAIO...
Try this:
$db = MSSQL_CONNECT($hostname,$username,$password);
mssql_select_db($dbname);
$sql = "insert into studenter(fornavn, etternavn) values
('$fornavn','$etternavn')";
$result = mssql_query($sql, $db);
Afan
----- Original Message -----
From: chris
To: php-windows@lists.php.net
Sent: Monday, February 11, 2002 6:10 AM
Subject: [PHP-WIN] im so stupid
I have made a script and for some reason i dont understand it doesnt do
what
its supposed to. maybe you can tell me whats wrong. its a form where im
supposed to insert a new record in a mssql table. but when i hit submit it
just refreshes blank.
<html>
<head></head>
<body><form method="post" action="registrer.php">
Fornavn: <input type="text" name="fornavn"><br>
Etternavn: <input type="text" name="etternavn"><br>
<input type="Submit" name="submit"
value="Registrer"><br> </form>
<?
IF (isset($submit))
{
$hostname = "dbname";
$username = "chris";
$password = "*****";
$dbname = "chris";
MSSQL_CONNECT($hostname,$username,$password);
mssql_select_db($dbname);
$sql = "insert into studenter(fornavn, etternavn) values
('$fornavn','$etternavn')";
$result = mssql_query($sql);
$studentnummer = mssql_insert_id();
Print("Studenten er lagt inn!");
}
?>
</body>
</html>
hope you can help.
-Chris
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php