FUDforum: comp.lang.php » php include, function, ...

Home » Imported messages » comp.lang.php » php include, function, ...

Show: Today's Messages :: Polls :: Message Navigator

php include, function, ... [message #177733]

Wed, 18 April 2012 20:03

hipa
Messages: 5
Registered: March 2012

Karma:

Junior Member

Hi there

I have a litle page with a form, which inserts an article in a postgres
db with php.
The php code is in the html page. Can someone tell me what the best way
is to exclude the php code from this page. And then just calling it true
a function or something?

<body>
<?php
if(isset($_POST['insertarticle']) && $_POST['insertarticle']){
$dbh = pg_connect("host=..... dbname=..... user=.....
password=.....");
if (!$dbh) {
die("Error in connection: " . pg_last_error());
}

if(isset($_POST['article'])){
$article = pg_escape_string($_POST['article']);
$sql = "INSERT INTO tblarticle values ((select max(idarticle) + 1 from
tblarticle), '{$article}')";
$result = pg_query($dbh, $sql);
}
{die(pg_last_error());}

if (!$result) {
die("Error in SQL query: " . pg_last_error());
}
pg_free_result($result);
pg_close($dbh);
}
?>

<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<input type="submit" name="insertarticle" value="Insert Article">
<label>Article:</label> <input id="article" name="article" type="text">
</form>
</body>

Report message to a moderator

[Message index]

		php include, function, ... By: hipa on Wed, 18 April 2012 20:03
		Re: php include, function, ... By: Redcat on Wed, 18 April 2012 20:08
		Re: php include, function, ... By: hipa on Sat, 21 April 2012 06:40
		Re: php include, function, ... By: Arno Welzel on Wed, 18 April 2012 20:12
		Re: php include, function, ... By: Thomas 'PointedEars' on Thu, 19 April 2012 00:55
		Re: php include, function, ... By: hipa on Sat, 21 April 2012 06:46
		Re: php include, function, ... By: IRC on Thu, 19 April 2012 10:55
		Re: php include, function, ... By: IRC on Thu, 19 April 2012 10:51

Previous Topic:	Weird behaviour when adding values to associative arrays
Next Topic:	Date/Time warning

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 07 13:36:01 GMT 2024

Total time taken to generate the page: 0.04457 seconds