Re: im so stupid
| From: | Afan Pasalic | Date: | Mon, 11 Feb 2002 17:24:09 +0000 |
| Subject: | Re: im so stupid | ||
| References: | 1 2 3 4 5 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-11976@lists.php.net to get a copy of this message | ||
No, I just thought with IF - ELSE statement to keep a whole code in one file. You think it's
bad? I'm new in PHP and I thought it's correct way?
Afan
----- Original Message -----
From: Todd Williamsen
To: php-windows@lists.php.net
Sent: Monday, February 11, 2002 12:09 PM
Subject: Re: [PHP-WIN] im so stupid
There is no need for the If and Else statement. Are you doing validation
checking?
"Afan Pasalic" <afan@sprout.net> wrote in message
news:009d01c1b31f$be771d80$311f49d1@VAIO...
Yes Todd, you're right. It looks now much better, but I just pointed to
Chris what could solve the problem...
Actually, I would rather do that everything in one file:
<html>
<head></head>
<body>
<?php
if($submit)
{
$db = MSSQL_CONNECT($hostname,$username,$password);
mssql_select_db($dbname);
$sql = "insert into studenter(fornavn, etternavn) values
('$fornavn','$etternavn')";
$result = mssql_query($sql, $db);
echo"<h2>You have successfully entered the following information
$fornavn<br> $etternavn</h2>";
}
else
{
?>
<form method="post" action="<?php echo $PATH_INFO ?>">
Fornavn: <input type="text" name="fornavn"><br>
Etternavn: <input type="text" name="etternavn"><br>
<input type="Submit" name="submit"
value="Registrer"><br>
</form>
<?php } ?>
</body>
</html>
Right?
Afan
----- Original Message -----
From: Todd Williamsen
To: php-windows@lists.php.net
Sent: Monday, February 11, 2002 11:51 AM
Subject: Re: [PHP-WIN] im so stupid
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>
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php