definition af variable
Jeg kunne godt tænke mig at få styr på at definere variable ud fra et eksempel:Fil 1 : administrator.php
<?php require mainside.php; ?>
<?php
if($txtId != "" && $selArticle == "0" ) {
doUpdate($txtId,$txtStartDate,$txtEndDate,
$txtHeader,$txtTeaser,$txtMaintext,$txtLink);
print("Database updated.");
}
?>
<html>
<head>
<title>Adminpage</title>
</head>
<body bgcolor="#FFFFFF" text="#000000">
<form action="administrator.php" method="POST">
<table width="40%" border="1" cellspacing="0" cellpadding="2">
<tr valign="top">
<td width="43%">Choose article here</td>
<td width="57%">
<select name="selArticle">
<option selected value="0">--- Choose article here ---</option>
<?php getHeaders(); ?>
</select>
<input type="hidden" name="txtId" value="<?php print(unFormatData($row[0])); ?>">
</td>
</tr>
<tr valign="top">
<td width="43%">Publish date</td>
<td width="57%">
<input type="text" name="txtStartDate" value="<?php print(unFormatData($row[1])); ?>">
</td>
</tr>
</tr>
<tr valign="top">
<td width="43%" height="23">Header</td>
<td width="57%" height="23">
<input type="text" name="txtHeader" value="<?php print(unFormatData($row[3])); ?>">
</td>
</tr>
<input type="submit" name="submit" value="Submit">
<input type="reset" name="reset" value="Reset">
</td>
</tr>
</table>
</form>
</body>
</html>
fil 2. mainside.php
<?php
function hookUpDb(){
Global $connection;
/*config connection to database*/
$host = 'localhost';
$user = 'root';
$password = '';
$db = 'tutorialdb';
/*connect to the database*/
if(mysql_connect($host,$user,$password)){
$connection = mysql_connect($host,$user,$password);
mysql_select_db($db,$connection);
return $connection;
}else{
print("<b>Sorry, cannot connect to the database.</b>");
}
}
function getHeaders(){
Global $connection;
$today = date("Ymd");
hookUpDb();
$query = "SELECT id,header
FROM content
ORDER BY start_date DESC";
$result = mysql_query($query,$connection);
while ($row = mysql_fetch_row($result)){
$id = $row[0];
$header = unFormatData($row[1]);
print("<option value=\"$id\">
$header</option>\n");
}
mysql_free_result($result);
mysql_close($connection);
}
function unFormatData($string){
$string = stripslashes($string);
return $string;
}
function doInsert($txtStartDate,$txtEndDate,$txtHeader,$txtTeaser,$txtMaintext,$txtLink){
Global $connection;
$txtStartDate = formatData($txtStartDate);
$txtEndDate = formatData($txtEndDate);
$txtHeader = formatData($txtHeader);
$txtTeaser = formatData($txtTeaser);
$txtMaintext = formatData($txtMaintext);
$txtLink = formatData($txtLink);
hookUpDb();
$query = "INSERT INTO content
----- osv.
}
function doUpdate($txtId,$txtStartDate,$txtEndDate,$txtHeader,$txtTeaser,$txtMaintext,$txtLink){
Global $connection;
$txtStartDate = formatData($txtStartDate);
$txtEndDate = formatData($txtEndDate);
$txtHeader = formatData($txtHeader);
$txtTeaser = formatData($txtTeaser);
$txtMaintext = formatData($txtMaintext);
$txtLink = formatData($txtLink);
hookUpDb();
$query = "UPDATE content SET .....osv.
når jeg definerer variabler kommer der fejmedd. som:
undefinded variable, hvis det er med POST GET el. REQUEST
-og ellers undefined index.
Koden er ikke fuldstændig men blot et udpluk.
