Tijden veranderen
"Adressenboek"
Ik zoek een php script voor een soort adressenboek. Het is de bedoeling dat bezoekers - zonder dat ze zich hoeven te registreren - hun gegevens toe te voegen en dat ze een foto van zichzelf kunnen toevoegen.
Tevens wil ik graag dat ze op voornaam, achternaam en geboortedatum kunnen zoeken.
Tja, het is wat...maar weet iemand waar ik zo'n script kan downloaden. Ik zoek me al dagen/uren rot.
Thanx!
seb.
Suc6 met het zoeken en helpt dit niet dan heb je altijd nog google :-)
Jan: ik heb wel een scriptje gevonden dat dicht bij mijn verlangens zit, alleen kan je bij deze niet een foto uploaden. Ik heb ook geen idee hoe ik dit moet doen. heb jij een idee?
Tevens kan ik alleen op maand zoeken met dit scriptje en ik wil op dag+maand+jaar zoeken. Ook een idee hoe ik dat verander?
Thanks!
Seb.
Weet je hoe je een formuliertje kunt maken in HTML?
Wellicht kan je me helpen hoe ik de foto en zoeken kan uitbreiden.
Thanks!
Seb.
<form method="post" action="" enctype="multipart/form-data">
edit: in jouw code is dat:
<form method="post" action="/demoaddressbook/edit.php">
die moet je dus aanpassen.
Gewijzigd op 28/12/2005 15:55:00 door Jan Koehoorn
Een ander vraagje: Weet jij hoe ik naast de maand ook de dag en jaar in de zoekopdracht kan verwerken? Dus: zoeken op dag+maand+jaar (gezamelijk, niet alleen op dog of maand of jaar)
Merci!
<form method="post" action="edit.php" enctype="multipart/form-data">
Alleen hoe krijg ik nu dat de upgeloade foto aan de persoon wordt gekoppeld
Code (php)
1
<?= $_COOKIE["naam"] ?>
ik denk dat de volgende twee pagina's belangrijk zijn: edit.php en view.php
Edit.php:
<h1>Edit / add address book entry</h1>
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
<?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);
?>
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="">
Firstname: </td>
<td>
<input type="Text" name="firstname" size="35" value="">
</td>
</tr>
<tr>
<td>Lastname:</td>
<td>
<input type="Text" name="lastname" size="35" value="">
</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" value="">
</td>
</tr>
<tr>
<td>Mobile:</td>
<td>
<input type="Text" name="mobile" value="">
</td>
</tr>
<tr>
<td>Work: </td>
<td>
<input type="Text" name="work" value="">
</td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Email:</td>
<td>
<input type="Text" name="email" size="35" value="">
</td>
</tr>
<tr>
<td>Email2:</td>
<td>
<input type="Text" name="email2" size="35" value="">
</td>
</tr>
<tr>
<td>Birthday:</td>
<td>
<select name="bday">
<option value="" selected></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="" selected></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="">
</td>
</tr>
</table>
<input type="Submit" name="update" value="Update information">
</form>
<form method="post" action="">
<table width="380" border="0" cellspacing="1" cellpadding="1">
<tr>
<td>
<input type="hidden" name="id" value="">
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>
View.php:
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
<?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");
?>
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 :'(