Bedankt, maar ik kom er niet uit hoe ik een veld maak voor het uploaden van een foto die automatisch wordt gekoppeld aan de persoon
ik denk dat de volgende twee pagina's belangrijk zijn: edit.php en view.php
Edit.php:
<?
include ("include/header.inc.php");
?>
<h1>Edit / add address book entry</h1>
<?php
include("include/dbconnect.php");
if($submit)
{
$sql = "INSERT INTO $table (firstname, lastname, address, home, mobile, work, email, email2, bday, bmonth, byear) VALUES ('$firstname','$lastname','$address','$home','$mobile','$work','$email','$email2','$bday','$bmonth','$byear')";
$result = mysql_query($sql);
echo "<br><br>Information entered into address book.\n";
}
else if($update)
{
$sql = "UPDATE $table SET firstname='$firstname',lastname='$lastname',address='$address',home='$home',mobile='$mobile',work='$work',email='$email',email2='$email2',bday='$bday',bmonth='$bmonth',byear='$byear' WHERE id=$id";
$result = mysql_query($sql);
echo "<br><br>Address book updated.\n";
}
else if($id)
{
$result = mysql_query("SELECT * FROM $table WHERE id=$id",$db);
$myrow = mysql_fetch_array($result);
?>
<form method="post" action="edit.php" enctype="multipart/form-data">
<table width="380" border="0" cellspacing="1" cellpadding="1">
<tr>
<td>
<input type="hidden" name="id" value="<?php echo $myrow["id"]?>">
Firstname: </td>
<td>
<input type="Text" name="firstname" size="35" value="<?php echo $myrow["firstname"]?>">
</td>
</tr>
<tr>
<td>Lastname:</td>
<td>
<input type="Text" name="lastname" size="35" value="<?php echo $myrow["lastname"]?>">
</td>
</tr>
<tr>
<td>Address: </td>
<td>
<textarea name="address" rows="5" cols="35"><?php echo $myrow["address"]?></textarea>
</td>
</tr>
<tr>
<td>Telephone:</td>
<td> </td>
</tr>
<tr>
<td>Home:</td>
<td>
<input type="Text" name="home" value="<?php echo $myrow["home"]?>">
</td>
</tr>
<tr>
<td>Mobile:</td>
<td>
<input type="Text" name="mobile" value="<?php echo $myrow["mobile"]?>">
</td>
</tr>
<tr>
<td>Work: </td>
<td>
<input type="Text" name="work" value="<?php echo $myrow["work"]?>">
</td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Email:</td>
<td>
<input type="Text" name="email" size="35" value="<?php echo $myrow["email"]?>">
</td>
</tr>
<tr>
<td>Email2:</td>
<td>
<input type="Text" name="email2" size="35" value="<?php echo $myrow["email2"]?>">
</td>
</tr>
<tr>
<td>Birthday:</td>
<td>
<select name="bday">
<option value="<?php echo $myrow["bday"]?>" selected><?php echo $myrow["bday"]?></option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select>
<select name="bmonth">
<option value="<?php echo $myrow["bmonth"]?>" selected><?php echo $myrow["bmonth"]?></option>
<option value="January" selected>January</option>
<option value="February">February</option>
<option value="March">March</option>
<option value="April">April</option>
<option value="May">May</option>
<option value="June">June</option>
<option value="July">July</option>
<option value="August">August</option>
<option value="September">September</option>
<option value="October">October</option>
<option value="November">November</option>
<option value="December">December</option>
</select>
<input type="text" name="byear" size="4" maxlength="4" value="<?php echo $myrow["byear"]?>">
</td>
</tr>
</table>
<input type="Submit" name="update" value="Update information">
</form>
<?
}
else
{
?>
<form method="post" action="<?php echo $PHP_SELF?>">
<table width="380" border="0" cellspacing="1" cellpadding="1">
<tr>
<td>
<input type="hidden" name="id" value="<?php echo $myrow["id"]?>">
Firstname:</td>
<td>
<input type="Text" name="firstname" size="35">
</td>
</tr>
<tr>
<td>Lastname: </td>
<td>
<input type="Text" name="lastname" size="35">
</td>
</tr>
<tr>
<td>Address: </td>
<td>
<textarea name="address" rows="5" cols="35"></textarea>
</td>
</tr>
<tr>
<td>Telephone:</td>
<td> </td>
</tr>
<tr>
<td>Home:</td>
<td>
<input type="Text" name="home">
</td>
</tr>
<tr>
<td>Mobile: </td>
<td>
<input type="Text" name="mobile">
</td>
</tr>
<tr>
<td>Work:</td>
<td>
<input type="Text" name="work">
</td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Email: </td>
<td>
<input type="Text" name="email" size="35">
</td>
</tr>
<tr>
<td>Email2: </td>
<td>
<input type="Text" name="email2" size="35">
</td>
</tr>
<tr>
<td>Birthday:</td>
<td>
<select name="bday">
<option value="1" selected>1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select>
<select name="bmonth">
<option value="January" selected>January</option>
<option value="February">February</option>
<option value="March">March</option>
<option value="April">April</option>
<option value="May">May</option>
<option value="June">June</option>
<option value="July">July</option>
<option value="August">August</option>
<option value="September">September</option>
<option value="October">October</option>
<option value="November">November</option>
<option value="December">December</option>
</select>
<input type="text" name="byear" size="4" maxlength="4">
</td>
</tr>
</table>
<input type="Submit" name="submit" value="Enter information">
</form>
<?
}
include ("include/footer.inc.php");
?>
View.php:
<?php
include ("include/header.inc.php");
include ("include/dbconnect.php");
if ($id) {
$result = mysql_query("SELECT * FROM $table WHERE id=$id",$db);
$links = mysql_fetch_array($result);
$id = $links["id"];
$firstname = $links["firstname"];
$lastname = $links["lastname"];
$address = $links["address"];
$home = $links["home"];
$mobile = $links["mobile"];
$work = $links["work"];
$email = $links["email"];
$email2 = $links["email2"];
$day = $links["bday"];
$month = $links["bmonth"];
$year = $links["byear"];
echo "<b>$firstname $lastname</b>: <br>";
echo "<br>$address <br><br>";
#echo "<b>Telephone numbers:</b><br>";
echo "home: $home<br>";
echo "mobile: $mobile<br>";
echo "work: $work<br><br>";
echo "email: <a href=mailto:$email>$email</a><br>";
echo "email2: <a href=http://$email2 target=_blank>$email2</a><br><br>";
echo "birthday: $day $month, $year";
} else {
echo "You need to select an ID number of a data entry";
}
include ("include/footer.inc.php");
?>
Weet jij/jullie hoe ik het bovengenoemde goed krijg? Ik kom er niet uit :'(
