also i recommend specifying the form action
<form action="index.php" method="post">
<?php
$q=$_POST['q'];
foreach ($q as $k=>$v) {
$q[$k]=htmlspecialchars($v);
}
echo '
<h4>Search</h4>
<form method="post" action="test.php">
<input type="text" name="q[first_name]" size="15" value="'.$q['first_name'].'" /> First Name<br />
<input type="text" name="q[last_name]" size="15" value="'.$q['last_name'].'" /> Last Name<br />
<input type="submit" name="awfea" value="Submit" />
</form>
';
?>
<h4>Search by language pair:</h4>
<form>
<input type=text name=slang size=10 value="source language"></input>
<input type=text name=tlang size=10 value="target language"></input>
<input type="hidden" name="lact" value="post"></input>
<input type=submit name="lsubmit" value="Submit"></input>
</form>
<?php
$lact = $_POST['lact'];
if($lact == "post") {
$slang = $_POST['slang'];
$tlang = $_POST['tlang'];
mysql_connect("$dbhost", "$dbuser", "$dbpass") or die(mysql_error());
mysql_select_db("$dbname") or die (mysql_error());
$lquery="SELECT * FROM providers WHERE srclangs = \"$slang\" and natlang=\"$tlang\"";
$lresult = mysql_query($lquery);
if(mysql_num_rows($lresult)==0) {
echo "<h4>Search Results:</h4><p>no such provider...sorry</p>";
mysql_close();
} else {
echo "<h4>Search Results:</h4><ul>";
while($row = mysql_fetch_assoc($lresult))
{
$id = $row['id'];
$name = $row['name'];
$country = $row['country'];
$email = $row['email'];
$website = $row['website'];
$natlang = $row['natlang'];
$srclangs = $row['srclangs'];
echo "<li>$name, $country, $srclangs to $natlang, <a href=\"mailto:$email\">$email</a>, <a href=\"$website\">$website</a>, <a href=\"editprov.php?name=$name\">edit $name</a>, <a href=\"listproj.php?name=$name\">list $name projects</a></li>";
}
echo "</ul>";
mysql_close();
}
}
// Deal with POSTed data first:
if ($_POST) {
// A user posted data -> check data, and update mysql
// BTW, you may want to verify data and escape it too.
}
// Now simply get the data from the DB
$query = "SELECT * FROM clients where name = \"$name\"";
$result = mysql_query($query);
while($row = mysql_fetch_assoc($result)) {
// You get the picture
}
// Display it using html
echo "<h4>Client Links:</h4>;
// etc etc
// Display a form using the same variables that the user may want to edit/update
// stop php and swithc to mostly html
?>
<form action="editclient.php" method="post">
<input type="text" name="name" value="<? echo $name; ?>" />
<!-- etc etc --!>
<input type="text" name="name" value="<? echo $name; ?>" />
while($row = mysql_fetch_assoc($result))
{
$id = $row['id'];
$name = $row['name'];
$street = $row['street'];
$city = $row['city'];
$country = $row['country'];
$zip = $row['zip'];
$email = $row['email'];
$website = $row['website'];
$provsys = $row['provsys'];
$notes = $row['notes'];
$state = $row['state'];
}
<?php
$act = $_POST['act'];
if($act == "post") {
$name = $_POST['name'];
$street = $_POST['street'];
$city = $_POST['city'];
$zip = $_POST['zip'];
$state = $_POST['state'];
$country = $_POST['country'];
$website = $_POST['website'];
$email = $_POST['email'];
$provsys = $_POST['provsys'];
$notes = $_POST['notes'];
mysql_connect("$dbhost", "$dbuser", "$dbpass") or die(mysql_error());
mysql_select_db("$dbname") or die(mysql_error());
$query="UPDATE clients SET name='$name', street='$street', city='$city', country='$country', zip='$zip', email='$email', website='$website', provsys='$provsys', notes='$notes', state='$state' WHERE id = '$id'";
mysql_query($query) or die('Error, insert query failed');
mysql_close();
}
?>
<?php
// this name var is set in the url, coming to page from link set on another page
// like $url/editclient.php?name=$name. that much works
$name = isset($_GET['name']) ? htmlentities($_GET['name']) : false;
mysql_connect("$dbhost", "$dbuser", "$dbpass") or die(mysql_error());
mysql_select_db("$dbname") or die(mysql_error());
if (isset($name)) {
$query = "SELECT * FROM clients where name = \"$name\"";
$result = mysql_query($query);
while($row = mysql_fetch_assoc($result))
{
$name = $row['name'];
$street = $row['street'];
$city = $row['city'];
$country = $row['country'];
$zip = $row['zip'];
$email = $row['email'];
$website = $row['website'];
$provsys = $row['provsys'];
$notes = $row['notes'];
$state = $row['state'];
}
// here, I'm getting the links I want, so I know I'm getting the data from the db
echo "<h4>Client Links:</h4>
<ul><li>website: <a href=\"$website\">$website</a></li>
<li>provider portal: <a href=\"$provsys\">$provsys</a></li>
<li>projects: <a href=\"$url/projects/clist.php?name=$name\">$name projects</a></li>
</ul>";
mysql_close();
} else {
echo "<p>You have not made a valid query.</p>";
echo "<p>return to <a href=\"$url\">home</a> or <a href=\"$url/clients/\">clients</a></p>";
}
?>
<!-- but the variables do not appear in the form...why? --!>
<h4>Edit Client:</h4>
<form action="editclient.php" method="post">
<input type=text name=name value="client name"></input>
<input type=text name=street value="street name"></input>
<input type=text name=city value="city"></input>
<input type=text name=state value="state or province"></input>
<input type=text name=country value="country"></input>
<input type=text name=zip value="zip or postal code"></input>
<input type=text name=website value="website"></input>
<input type=text name=email value="email"></input>
<input type=text name=provsys value="provider portal"></input>
<input type=text name=notes size=100 value="notes"></input>
<input type="hidden" name="act" value="post"></input>
<input type=submit name="submit" value="Submit"></input>
</form>
In NRW reichte es für Rot-Grün zur gemeinsame Mehrheit - aber klappt das auch bei der Bundestagswahl? Bei den Grünen sorgt diese Frage für heftige Differenzen: Realo-Kopf Palmer greift Parteichefin Roth an, weil sie die Grünen im Bündnis mit der SPD einmauern würde.
preg_match('/"site_id":(\d+)/', $result, $matches); $siteid = $matches[0];