ronaldhannink
Nieuwe gebruiker
- Lid geworden
- 13 sep 2011
- Berichten
- 1
via php array wordt javascript gevoed echter het javascript vult niet de velden aan maar laat in één van de velden de array zien. Ziet iemand van jullie wat er verkeerd gaat.
querycode is:
Formulier ziet er als volgt uit met javascript:
querycode is:
PHP:
require_once 'include/functions.php';
$postalcode = trim($_GET['postcode']);
$postalcode = strtoupper($postalcode);
$postalcode = substr_replace($postalcode, " ", 4, 0);
$query = mysql_query("SELECT code_id,street,city FROM member_postal_code WHERE code= '".$_GET['postcode']."'");
if(!$query){
echo "<br>error :".die(mysql_error());
}
$rij = mysql_fetch_array($query);
$code = $rij['street'].",".$rij['city'];
echo $code;Formulier ziet er als volgt uit met javascript:
HTML:
<html>
<body>
<script type=\"text/javascript\">
function get_info() {
http = false;
if (navigator.appName == \"Microsoft Internet Explorer\")
{
http = new ActiveXObject(\"Microsoft.XMLHTTP\");
} else {
http = new XMLHttpRequest();
}
http.onreadystatechange = function()
{
if (http.readyState == 4)
{
valueArray = http.responseText.split(',');
alert(valueArray);
if (http.length == 2)
{
document.postcode.street.value = valueArray[0];
document.postcode.city.value = valueArray[1];
}
else
{
alert(\"De door uw ingegeven postcode staat niet in de database...\");
}
}
}
http.open(\"GET\", \"./postalcode.php?postcode=\" + document.postcode.postcode.value , true);
http.send(null);
alert(valueArray);
}
</script>
<h2>Wijzigen Lid / Vrijwilliger</h2><br />";
echo '<form method="post" action="'.$_SERVER['PHP_SELF'].'" name="postcode">';
$result= mysql_query("SELECT * FROM member_member WHERE member_id < $member_id ORDER BY member_id DESC")or die(mysql_error());
$count=mysql_num_rows($result);
echo "aantal regel is: ".$count."<br><br>";
if($count != 0)
{
echo "<a href='index.php?member_change=".$member_id."&action=back' class='singlebutton'><< Vorig lid </a>\n";
}
$result= mysql_query("SELECT * FROM member_member WHERE member_id > $member_id ORDER BY member_id ASC")or die(mysql_error());
$count=mysql_num_rows($result);
//echo "aantal regel is: ".$count;
if($count != 0)
{
echo " <a href='index.php?member_change=".$member_id."&action=next' class='singlebutton'> Volgend lid >> </a><br><br>";
}
else
{
echo "<br><br>";
}
echo '<table width=\"600\">
<tr><td>Lidnummer</td><td>:</td><td>'.str_pad($record['member_id'], 5, "0", STR_PAD_LEFT).'</td></tr>
<tr>
<td>Titulatuur</td><td>:</td><td>';
$_SESSION['titleoptionselected'] = $record['member_title'];
SelectTitle();
//session_unset($_SESSION['titleoptionselected']);
echo'</td>
</tr>
<tr>
<td>Initialen</td><td>:</td><td><input type="hidden" name="member_id" value="'.$record['member_id'].'" /><input type="text" name="initials" value="'.$record['member_initials'].'" /></td>
</tr>
<tr>
<td>Voornaam</td><td>:</td><td><input type="text" name="firstname" value="'.$record['member_firstname'].'" /></td>
</tr>
<tr>
<td>Tussenvoegsel</td><td>:</td><td><input type="text" name="preposition" value="'.$record['member_preposition'].'" /></td>
</tr>
<tr>
<td>Achternaam</td><td>:</td><td><input type="text" name="lastname" value="'.$record['member_lastname'].'"/></td>
</tr>
<tr>
<td>Postcode</td><td>:</td><td><input type="text" onChange="get_info(this.value);" name="postcode" maxlength="7" value="'.$record['code'].'"/></td><td>woonplaats</td><td>: <input type="text" name="city" value="'.$record['city'].'" /></td>
</tr>
<tr>
<td>Straat</td><td>:</td><td><input type="text" name="street" value="'.$record['street'].'" /></td><td>huisnr.</td><td>: <input type="text" name="housnr" value="'.$record['member_housnr'].'" /></td>
</tr>
<tr>
<td>Wijknummer</td><td>:</td><td>';
if(isset($_POST['search_district']))
{
$_SESSION['districtoptionselected'] = $_POST['search_district'];
}else{
$_SESSION['districtoptionselected'] = $record['member_district'];
}
SelectDistrict();
//session_unset($_SESSION['districtoptionselected']);
echo '</td><td></td><td></td>
</tr>
<tr>
<td>Telefoon</td><td>:</td><td><input type="text" name="phone" value="'.$record['member_phone'].'" /></td><td>Email</td><td>: <input type="text" name="email" value="'.$record['member_email'].'"/></td>
</tr>
';
echo '<tr valign="middle">
<td>lid</td><td>:</td><td><input type="checkbox" name="member" '.$checked_member.' /><font size="1"> sinds <input type="text" id="member_date" name="member_date" size="11" value="'.$record['member_memberdate'].'" ></font>
</td><td>geb.datum</td><td>: <input type="text" id="birth_date" name="birthdate" size="11" value="'.format_date($record['member_birthdate']).'"></font></td><td></td>
</tr>
<tr valign="top">
<td>vrijwilliger</td><td>:</td><td><input type="checkbox" name="volontier" '.$checked_volontier.' /> <font size="1">sinds <input type="text" id="volontier_date" name="volontierdate" size="11" value="'.$record['member_volontierdate'].'"></td><td></td><td> </td>
</tr>
<tr>
<td>betaling</td><td>:</td><td>';
if(isset($_POST['overview_payment']))
{
$_SESSION['paymentoptionselected'] = $_POST['overview_payment'];
}else{
$_SESSION['paymentoptionselected'] = $record['payment_id'];
}
SelectPayment();
//session_unset($_SESSION['paymentoptionselected']);
echo '</td><td>Bankrek. </td><td>: <input type="text" name="banknr" maxlength="9" value="'.$record['member_banknr'].'"/></td>
</tr>
<tr>
<td valign="top">Activiteit(en)</td><td valign="top">:</td><td>';
if(isset($_POST['overview_activity']))
{
$_SESSION['member_activity'] = implode(",",$_POST['overview_activity']);
}else{
$_SESSION['member_activity'] = $record['member_activity'];
}
SelectActivity();
//session_unset($_SESSION['member_activity']);
echo'</td><td></td><td></td>
</tr>
<tr>
<td></td><td></td><td><input type="submit" name="member_change" value="wijzigen" /> <input type="submit" name="member_del" value="verwijder" /></td><td></td><td></td>
</tr>
<input type="hidden" name="code" />
</table>
</form>
</body>
</html>
Laatst bewerkt door een moderator:
