Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2
e2 poh ung Code q kaya lang kulang poh ng SEARCH, UPDATE, DELETE ndi q poh alam ung code ng SEARCh, UPDATE, DELETE
<form action='haizt.php' method='post'>
<pre>
<H2 align="center">CERTIFICATE OF LIVE BIRTH<H2>
<H4 align="center">Place of Birth:<input type='text' name='pob'><H4>
<H4 align="center">City Town Or Distric:<input type='text' name='ctod'><H4>
<H4 align="center">Sex:<select name='sex'><H4>
<option>Male</option>
<option>Female</option></select>
<H4 align="center">Date of Birth:<input type='text' name='dob'><H4>
<H4 align="center">Date Recorded:<input type='text' name='dr'><H4>
<H5 align="center">FATHER OF CHILD<H5>
<H4 align="center">Full Name:<input type='text' name='fn'><H4>
<H4 align="center">Race:<input type='text' name='race'><H4>
<H5 align="center">MOTHER OF CHILD<H5>
<H4 align="center">Full Name:<input type='text' name='fn2'><H4>
<H4 align="center">Race:<input type='text' name='race2'><H4>
<H4 align="center">Date:<input type='text' name='date'><H4>
<H4 align="center"><input type='Submit' value='Submit'><H4>
<form name="search" method="post" action="<?=$PHP_SELF?>">
Seach for: <input type="text" name="find" /> in
<Select NAME="field">
<Option VALUE="fname">First Name</option>
<Option VALUE="lname">Last Name</option>
<Option VALUE="info">Profile</option>
</Select>
<input type="hidden" name="searching" value="yes" />
<input type="submit" name="search" value="Search" />
</form>
</form>
<?php
mysql_connect("localhost","root","");
mysql_query("create database mydb");
mysql_select_db("mydb");
mysql_query("create table certificate(pob varchar(20),ctod varchar(20),sex varchar(20),dob varchar(20),dr varchar(20),fn varchar(10),race varchar(10),fn2 varchar(10),race2 varchar(10),date varchar(10))");
mysql_query("insert into certificate value('" . @$_POST['pob'] . "','" . @$_POST['ctod'] . "','" . @$_POST['sex'] . "','" . @$_POST['dob'] . "','" . @$_POST['dr'] . "','" . @$_POST['fn'] . "','" . @$_POST['race'] . "','" . @$_POST['fn2'] . "','" . @$_POST['race2'] . "','" . @$_POST['date'] . "')");
$query="select *from certificate";
$result=mysql_query($query);
?>
patulong poh plzzzzz......
kelangan lang poh talaga....
slamot poh
praise: