Php İle Ziyaretci Defteri

GraFiCoDeR Salı 03 Haz. 2008, 22:48

Merhaba Arkadaslar,

MySQL dan ziyaretci_defteri adında Bir Database Açalım.

Kod:: [color=Black][color=#0000bb]CREATE TABLE ziyaretci_defteri [/color][color=#007700]( [/color][color=#0000bb]numara smallint[/color][color=#007700]([/color][color=#0000bb]6[/color][color=#007700]) [/color][color=#0000bb]NOT NULL auto_increment[/color][color=#007700], [/color][color=#0000bb]isim text NOT NULL[/color][color=#007700], [/color][color=#0000bb]email text NOT NULL[/color][color=#007700], [/color][color=#0000bb]ulke text NOT NULL[/color][color=#007700], [/color][color=#0000bb]gorus longtext NOT NULL[/color][color=#007700], [/color][color=#0000bb]tarih datetime NOT NULL [/color][color=#007700]default [/color][color=#dd0000]'0000-00-00 00:00:00'[/color][color=#007700], [/color][color=#0000bb]PRIMARY KEY [/color][color=#007700]([/color][color=#0000bb]numara[/color][color=#007700]), [/color][color=#0000bb]UNIQUE KEY numara [/color][color=#007700]([/color][color=#0000bb]numara[/color][color=#007700]) ) [/color][color=#0000bb]TYPE[/color][color=#007700]=[/color][color=#0000bb]MyISAM[/color][color=#007700]; [/color][/color]

e-mail , gorus v.s olusturduk İşlevini Göstertelim.
Aşağıda vereceğim Kodları yaz.php adında Kaydediniz.

Kod:: [color=#007700]<[/color][color=#0000bb]html[/color][color=#007700]> <[/color][color=#0000bb]head[/color][color=#007700]><[/color][color=#0000bb]title[/color][color=#007700]> Jackal[/color][color=#007700]- [/color][color=#0000bb]Ziyaretci Defteri [/color][color=#007700]- [/color][color=#0000bb]Gorusunuzu Yaziniz [/color][color=#007700]([[/color][color=#0000bb]b[/color][color=#007700]][/color][color=#0000bb]yaz[/color][color=#007700].[/color][color=#0000bb]php[/color][color=#007700][/[/color][color=#0000bb]b[/color][color=#007700]])</[/color][color=#0000bb]title[/color][color=#007700]><[/color][color=#0000bb]head[/color][color=#007700]> <[/color][color=#0000bb]body[/color][color=#007700]> <[/color][color=#0000bb]form method[/color][color=#007700]=[/color][color=#dd0000]"post" [/color][color=#0000bb]action[/color][color=#007700]=[/color][color=#dd0000]"gonder.php"[/color][color=#007700]> [/color][color=#0000bb]Isminiz [/color][color=#007700]: <[/color][color=#0000bb]input type[/color][color=#007700]=[/color][color=#dd0000]"text" [/color][color=#0000bb]name[/color][color=#007700]=[/color][color=#dd0000]"isim"[/color][color=#007700]><[/color][color=#0000bb]br[/color][color=#007700]> [/color][color=#0000bb]Email [/color][color=#007700]: <[/color][color=#0000bb]input type[/color][color=#007700]=[/color][color=#dd0000]"text" [/color][color=#0000bb]name[/color][color=#007700]=[/color][color=#dd0000]"email"[/color][color=#007700]><[/color][color=#0000bb]br[/color][color=#007700]> [/color][color=#0000bb]Ulkeniz [/color][color=#007700]: <[/color][color=#0000bb]input type[/color][color=#007700]=[/color][color=#dd0000]"text" [/color][color=#0000bb]name[/color][color=#007700]=[/color][color=#dd0000]"ulke"[/color][color=#007700]><[/color][color=#0000bb]br[/color][color=#007700]> [/color][color=#0000bb]Gorusleriniz [/color][color=#007700]: <[/color][color=#0000bb]textarea name[/color][color=#007700]=[/color][color=#dd0000]"gorus"[/color][color=#007700]></[/color][color=#0000bb]textarea[/color][color=#007700]><[/color][color=#0000bb]br[/color][color=#007700]> <[/color][color=#0000bb]br[/color][color=#007700]><[/color][color=#0000bb]br[/color][color=#007700]> <[/color][color=#0000bb]input type[/color][color=#007700]=[/color][color=#dd0000]"submit" [/color][color=#0000bb]name[/color][color=#007700]=[/color][color=#dd0000]"valider" [/color][color=#0000bb]value[/color][color=#007700]=[/color][color=#dd0000]"Gonder"[/color][color=#007700]> </[/color][color=#0000bb]form[/color][color=#007700]> </[/color][color=#0000bb]body[/color][color=#007700]> </[/color][color=#0000bb]html[/color][color=#007700]> [/color]

Post Metodu ile gonder.php ye çekeceğiz.

Kod:: [color=#007700]<[/color][color=#0000bb]html[/color][color=#007700]> <[/color][color=#0000bb]head[/color][color=#007700]><[/color][color=#0000bb]title[/color][color=#007700]>[/color][color=#0000bb]Jackal[/color][color=#007700]- [/color][color=#0000bb]Ziyaretci Defteri [/color][color=#007700]- [/color][color=#0000bb]Gorus Onayi [/color][b][color=#007700]([/color][color=#0000bb]gonder[/color][color=#007700].[/color][color=#0000bb]php[/color][color=#007700]) [/color][/b][color=#007700]</[/color][color=#0000bb]title[/color][color=#007700]><[/color][color=#0000bb]head[/color][color=#007700]> <[/color][color=#0000bb]body[/color][color=#007700]> <?[/color][color=#0000bb]php $db [/color][color=#007700]= [/color][color=#0000bb]mysql_connect[/color][color=#007700](); [/color][color=#ff8000] //Database Bağlantı Ağı [/color][color=#0000bb]$continu[/color][color=#007700]=[/color][color=#0000bb]1[/color][color=#007700]; if ([/color][color=#0000bb]$isim [/color][color=#007700]== [/color][color=#dd0000]""[/color][color=#007700]) { echo([/color][color=#dd0000]"Lutfen Isim bolumunu tam olarak doldurunuz!<br>"[/color][color=#007700]); [/color][color=#ff8000]//İsim olmadığında Çıkacak Olan hata [/color][color=#0000bb]$continu[/color][color=#007700]=[/color][color=#0000bb]0[/color][color=#007700]; } if ([/color][color=#0000bb]$continu [/color][color=#007700]== [/color][color=#0000bb]1[/color][color=#007700]) { [/color][color=#0000bb]$date[/color][color=#007700]=[/color][color=#0000bb]date[/color][color=#007700]([/color][color=#dd0000]"Y-m-d"[/color][color=#007700]); [/color][color=#0000bb]$sql[/color][color=#007700]=[/color][color=#dd0000]"INSERT INTO ziyaretci_defteri (isim, email, ulke, gorus, tarih) VALUES ('$isim', '$email', '$ulke', '$gorus', NOW())"[/color][color=#007700]; [/color][color=#0000bb]mysql_query[/color][color=#007700]([/color][color=#0000bb]$sql[/color][color=#007700], [/color][color=#0000bb]$db[/color][color=#007700]); echo([/color][color=#dd0000]"Gorusleriniz Icin Tesekkurler !"[/color][color=#007700]) ;[/color][color=#007700]} else { echo([/color][color=#dd0000]"<a href=yaz.php>Geri</a>"[/color][color=#007700]); } [/color][color=#0000bb]?>[/color] <br>[color=#0000bb]<?php echo[/color][color=#007700]([/color][color=#dd0000]"<a href=oku.php>Defteri Oku</a>"[/color][color=#007700]); [/color][color=#0000bb]?>[/color] </body> </html>[/color]

İşlem Tamam.

Aşağıda Verilenleri oku.php adına Kaydedelim

Kod:: [color=#007700]<[/color][color=#0000bb]html[/color][color=#007700]> <[/color][color=#0000bb]head[/color][color=#007700]><[/color][color=#0000bb]title[/color][color=#007700]>[/color][color=#0000bb]Jackal[/color][color=#007700]- [/color][color=#0000bb]Ziyaretci Defteri [/color][color=#007700]- [/color][color=#0000bb]Gorusleri Oku [/color][b][color=#007700]([/color][color=#0000bb]oku[/color][color=#007700].[/color][color=#0000bb]php[/color][color=#007700]) [/color][/b][color=#007700]</[/color][color=#0000bb]title[/color][color=#007700]><[/color][color=#0000bb]head[/color][color=#007700]> <[/color][color=#0000bb]body[/color][color=#007700]> <[/color][color=#0000bb]table align[/color][color=#007700]=[/color][color=#dd0000]"center" [/color][color=#0000bb]cellspacing[/color][color=#007700]=[/color][color=#dd0000]"0" [/color][color=#0000bb]cellpadding[/color][color=#007700]=[/color][color=#dd0000]"0" [/color][color=#0000bb]border[/color][color=#007700]=[/color][color=#dd0000]"1" [/color][color=#0000bb]width[/color][color=#007700]=[/color][color=#dd0000]"80%"[/color][color=#007700]> <[/color][color=#0000bb]tr[/color][color=#007700]> <[/color][color=#0000bb]td bgcolor[/color][color=#007700]=[/color][color=#dd0000]"black"[/color][color=#007700]><[/color][color=#0000bb]font color[/color][color=#007700]=[/color][color=#dd0000]"white"[/color][color=#007700]>[/color][color=#0000bb]Isim[/color][color=#007700]</[/color][color=#0000bb]td[/color][color=#007700]> <[/color][color=#0000bb]td bgcolor[/color][color=#007700]=[/color][color=#dd0000]"black"[/color][color=#007700]><[/color][color=#0000bb]font color[/color][color=#007700]=[/color][color=#dd0000]"white"[/color][color=#007700]>[/color][color=#0000bb]Email[/color][color=#007700]</[/color][color=#0000bb]td[/color][color=#007700]> <[/color][color=#0000bb]td bgcolor[/color][color=#007700]=[/color][color=#dd0000]"black"[/color][color=#007700]><[/color][color=#0000bb]font color[/color][color=#007700]=[/color][color=#dd0000]"white"[/color][color=#007700]>[/color][color=#0000bb]Ulke[/color][color=#007700]</[/color][color=#0000bb]td[/color][color=#007700]> <[/color][color=#0000bb]td bgcolor[/color][color=#007700]=[/color][color=#dd0000]"black"[/color][color=#007700]><[/color][color=#0000bb]font color[/color][color=#007700]=[/color][color=#dd0000]"white"[/color][color=#007700]>[/color][color=#0000bb]Gorusler[/color][color=#007700]</[/color][color=#0000bb]td[/color][color=#007700]> <[/color][color=#0000bb]td bgcolor[/color][color=#007700]=[/color][color=#dd0000]"black"[/color][color=#007700]><[/color][color=#0000bb]font color[/color][color=#007700]=[/color][color=#dd0000]"white"[/color][color=#007700]>[/color][color=#0000bb]Tarih[/color][color=#007700]</[/color][color=#0000bb]td[/color][color=#007700]> </[/color][color=#0000bb]tr[/color][color=#007700]> <?[/color][color=#0000bb]php $db [/color][color=#007700]= [/color][color=#0000bb]mysql_connect[/color][color=#007700](); [/color][color=#0000bb]$sql[/color][color=#007700]=[/color][color=#dd0000]"SELECT * FROM ziyaretci_defteri BY Jackal"[/color][color=#007700]; [/color][color=#0000bb]$res[/color][color=#007700]=[/color][color=#0000bb]mysql_query[/color][color=#007700]([/color][color=#0000bb]$sql[/color][color=#007700], [/color][color=#0000bb]$db[/color][color=#007700]); while ([/color][color=#0000bb]$ligne [/color][color=#007700]= [/color][color=#0000bb]mysql_fetch_object [/color][color=#007700]([/color][color=#0000bb]$res[/color][color=#007700])) { [/color][color=#0000bb]echo[/color][color=#dd0000]"<tr>"[/color][color=#007700]; [/color][color=#0000bb]echo[/color][color=#dd0000]"<td>$ligne->isim</td>"[/color][color=#007700]; [/color][color=#0000bb]echo[/color][color=#dd0000]"<td>$ligne->email</td>"[/color][color=#007700]; [/color][color=#0000bb]echo[/color][color=#dd0000]"<td>$ligne->ulke</td>"[/color][color=#007700]; [/color][color=#0000bb]echo[/color][color=#dd0000]"<td>$ligne->gorus</td>"[/color][color=#007700]; [/color][color=#0000bb]echo[/color][color=#dd0000]"<td>$ligne->tarih</td>"[/color][color=#007700]; [/color][color=#0000bb]echo[/color][color=#dd0000]"</tr>"[/color][color=#007700]; } [/color][color=#0000bb]mysql_free_result [/color][color=#007700]([/color][color=#0000bb]$res[/color][color=#007700]); [/color][color=#0000bb]?>[/color] </table> <br>[color=#0000bb]<?php echo[/color][color=#007700]([/color][color=#dd0000]"<a href=yaz.php>Deftere Yaz</a>"[/color][color=#007700]); [/color][color=#0000bb]?>[/color] </body> </html>

Küçük Çapta Bir konuk ve ya Ziyaretci Defteri Diyelim Yazmış bulunduk.

Anlatım : GrafiCoder

boronzox Salı 03 Haz. 2008, 22:49

Saol talha :kahve-:

haziran Çarş. 04 Haz. 2008, 00:14

PHP konusunda en ufak bir bilgim yok ama öğrenmek istediğim bir alandır php, çünkü hrml den daha kapsamlı ve kullanışlı olduğunu az çok biliyorum ama paylaşım için çok teşekkürler bir çoğumunun işine yarayacaktır :Çakk--:

Php İle Ziyaretci Defteri

Php İle Ziyaretci Defteri

Geri: Php İle Ziyaretci Defteri

Geri: Php İle Ziyaretci Defteri