0

Good day! I am currently working on this code. My problem is that the delete option don't function. It gets the error "There has been a fatal error." as stated in the code, so please help me to fix this code. Thank you

<html>
<head>
<title>Buyer's Profile</title>
</head>
<body>
<?php
if (isset($_GET['delete'])){
$id = $_GET['delete'];
mysql_connect("localhost", "root", "root") or die("Could not connect to the server");
mysql_select_db("purchase") or die ("That database could not be found");
$userquery = mysql_query("SELECT * FROM property, personal, spouse WHERE id='$dbid'") or die ("The query could not be completed.");
$userquery = mysql_query("DELETE FROM property, personal, spouse WHERE id='$dbid'") or die ("The query could not be completed.");
}

if (isset($_GET['id'])){
$id = $_GET['id'];
mysql_connect("localhost", "root", "root") or die("Could not connect to the server");
mysql_select_db("purchase") or die ("That database could not be found");
$userquery = mysql_query("SELECT * FROM property JOIN personal ON property.id=personal.id JOIN spouse ON property.id=spouse.id") or die ("The query could not be completed.");

if (mysql_num_rows($userquery) != 1){
die("That id could not be found!");
}


while($row = mysql_fetch_array($userquery, MYSQL_ASSOC)){
$dbid = $row['id'];
$typepay = $row['typepay'];
$phase = $row['phase'];
$section = $row['section'];
$block = $row['block'];
$lot = $row['lot'];
$housemodel = $row['housemodel'];
$reservefee = $row['reservefee'];
$grosstotal = $row['grosstotal'];
$nettotal = $row['nettotal'];
$sourcesale = $row['sourcesale'];

$buyertype = $row['buyertype'];
$famname = $row['famname'];
$firname = $row['firname'];
$midname = $row['midname'];
$contnum = $row['contnum'];
$email = $row['email'];
$address = $row['address'];
$sex = $row['sex'];
$age = $row['age'];
$month = $row['month'];
$day = $row['day'];
$year = $row['year'];
$civstat = $row['civstat'];
$citizenship = $row['citizenship'];
$occupation = $row['occupation'];
$position = $row['position'];
$yearswork = $row['yearswork'];
$typeemp = $row['typeemp'];
$empstat = $row['empstat'];
$presentemp = $row['presentemp'];
$employer = $row['employer'];
$income = $row['income'];
$tin = $row['tin'];
$hdmf = $row['hdmf'];
$project = $row['project'];

$spfamname = $row['spfamname'];
$spfirname = $row['spfirname'];
$spmidname = $row['spmidname'];
$spemail = $row['spemail'];
$spaddress = $row['spaddress'];
$spsex = $row['spsex'];
$spage = $row['spage'];
$spmonth = $row['spmonth'];
$spday = $row['spday'];
$spyear = $row['spyear'];
$spcivstat = $row['spcivstat'];
$spcitizenship = $row['spcitizenship'];
$spoccupation = $row['spoccupation'];
$spposition = $row['spposition'];
$spyearswork = $row['spyearswork'];
$sptypeemp = $row['sptypeemp'];
$spempstat = $row['spempstat'];
$sppresentemp = $row['sppresentemp'];
$spemployer = $row['spemployer'];
$spincome = $row['spincome'];
$sptin = $row['sptin'];
$sphdmf = $row['sphdmf'];
$spproject = $row['spproject'];
}




if($id != $dbid) {
die ("There has been a fatal error.");
}

?>


<!DOCTYPE html>
<html lang="en">
<head>
    <title>Application List</title>
    <meta charset="utf-8" />
    <link rel="stylesheet" href="search.css" type="text/css" />
    <script src="agentvalidate.js"></script>
    <meta name="viewport" content="width=device-width, initial-scale=1.0">

</head>

<body class="body">
    <header class="mainHeader">
        <img src="img/about.jpg">
        <nav><ul>
            <li><a href="home.html">Home</a></li>
            <li><a href="about-us.html">About Us</a></li>
            <li><a href="project.html">Project</a>
                <ul>
                    <li><a href="purchase-app-property-info.html" class="purchase">Purchase</a></li>
                    <li><a href="house-and-lot.html" class="house&lot">House & Lot</a></li>
                </ul>
            </li>
            <li><a href="contact-us.html">Contact Us</a></li>
        </ul></nav>
    </header>

    <div class="mainContent">
        <div class="content">    
                <article class="topcontent"> 
                    <header>
                        <h2><?php echo $firname; ?><?php echo " "; ?><?php echo $famname; ?>'s Profile</h2>
                    </header>

                    <content>
                        <hr>
                        <h2>Property Information</h2><br>
                        <table>
                        <tr><td>ID No.:</td><td><?php echo $dbid; ?></td></tr>
                        <tr><td>Type of Payment:</td><td><?php echo $typeemp; ?></td></tr>
                        <tr><td>Project:</td><td><?php echo $project; ?></td></tr>
                        <tr><td>Phase/Building:</td><td><?php echo $phase; ?></td></tr>
                        <tr><td>Section/Floor/Tower:</td><td><?php echo $section; ?></td></tr>
                        <tr><td>Block:</td><td><?php echo $block; ?></td></tr>
                        <tr><td>Lot/Lot Area:</td><td><?php echo $lot; ?></td></tr>
                        <tr><td>House Model/House Model Category:</td><td><?php echo $housemodel; ?></td></tr>
                        <tr><td>Reservation Fee:</td><td><?php echo $reservefee; ?></td></tr>
                        <tr><td>Gross Total List Price:</td><td><?php echo $grosstotal; ?></td></tr>
                        <tr><td>Net Total Contract Price:</td><td><?php echo $nettotal; ?></td></tr>
                        <tr><td>Source of Sale:</td><td><?php echo $sourcesale; ?></td></tr>
                        </tr>
                        </table>
                    </content>       
            </article>

            <article class="topcontent"> 
                        <header>
                        <h2 class="info">Personal Information</a></h2><br>  
                        </header>
                        <table>
                        <tr><td>Name:</td><td><?php echo $famname; ?><?php echo ", "; ?><?php echo $firname; ?><?php echo " "; ?><?php echo $midname; ?><?php echo "."; ?></td></tr>
                        <tr><td>Contact No.:</td><td><?php echo $contnum; ?></td></tr>
                        <tr><td>Home Address:</td><td><?php echo $address; ?></td></tr>
                        <tr><td>Sex:</td><td><?php echo $sex; ?></td></tr>
                        <tr><td>Age:</td><td><?php echo $age; ?></td></tr>
                        <tr><td>Birthdate:</td><td><?php echo $month; ?><?php echo ". "; ?><?php echo $day; ?><?php echo ", "; ?><?php echo $year; ?></td></tr>
                        <tr><td>Civil Status:</td><td><?php echo $civstat; ?></td></tr>
                        <tr><td>Citizenship:</td><td><?php echo $citizenship; ?></td></tr>
                        <tr><td>Occupation:</td><td><?php echo $occupation; ?></td></tr>
                        <tr><td>Position:</td><td><?php echo $position; ?></td></tr>
                        <tr><td>Years in Current Work/Business:</td><td><?php echo $yearswork; ?></td></tr>
                        <tr><td>Employment Type:</td><td><?php echo $typeemp; ?></td></tr>
                        <tr><td>Employment Status:</td><td><?php echo $empstat; ?></td></tr>
                        <tr><td>Present Employer:</td><td><?php echo $presentemp; ?></td></tr>
                        <tr><td>Employer:</td><td><?php echo $employer; ?></td></tr>
                        <tr><td>Gross Monthly Income:</td><td><?php echo $income; ?></td></tr>
                        <tr><td>TIN:</td><td><?php echo $tin; ?></td></tr>
                        <tr><td>HDMF/SSS/GSIS No:</td><td><?php echo $hdmf; ?></td></tr>
                        </table>
                    </content>       
                        </article>


            <article class="topcontent"> 
                        <header>
                        <h2 class="info">Spouse's Personal Information</a></h2><br> 
                        </header>
                        <table>

                        <tr><td>Name:</td><td><?php echo $spfamname; ?><?php echo ", "; ?><?php echo $spfirname; ?><?php echo " "; ?><?php echo $spmidname; ?><?php echo "."; ?></td></tr>
                        <tr><td>Email:</td><td><?php echo $spemail; ?></td></tr>
                        <tr><td>Home Address:</td><td><?php echo $spaddress; ?></td></tr>
                        <tr><td>Sex:</td><td><?php echo $spsex; ?></td></tr>
                        <tr><td>Age:</td><td><?php echo $spage; ?></td></tr>
                        <tr><td>Birthdate:</td><td><?php echo $spmonth; ?><?php echo ". "; ?><?php echo $spday; ?><?php echo ", "; ?><?php echo $spyear; ?></td></tr>
                        <tr><td>Civil Status:</td><td><?php echo $spcivstat; ?></td></tr>
                        <tr><td>Citizenship:</td><td><?php echo $spcitizenship; ?></td></tr>
                        <tr><td>Occupation:</td><td><?php echo $spoccupation; ?></td></tr>
                        <tr><td>Position:</td><td><?php echo $spposition; ?></td></tr>
                        <tr><td>Years in Current Work/Business:</td><td><?php echo $spyearswork; ?></td></tr>
                        <tr><td>Employment Type:</td><td><?php echo $sptypeemp; ?></td></tr>
                        <tr><td>Employment Status:</td><td><?php echo $spempstat; ?></td></tr>
                        <tr><td>Present Employer:</td><td><?php echo $sppresentemp; ?></td></tr>
                        <tr><td>Employer:</td><td><?php echo $spemployer; ?></td></tr>
                        <tr><td>Gross Monthly Income:</td><td><?php echo $spincome; ?></td></tr>
                        <tr><td>TIN:</td><td><?php echo $sptin; ?></td></tr>
                        <tr><td>HDMF/SSS/GSIS No:</td><td><?php echo $sphdmf; ?></td></tr>
                        </table>
                    </content>       
                        </article>

        </div>
                <aside class="top-sidebar">
                    <article>
                    <img src="img/applications.png"><a href="mainapp.php">Application List</a></li><hr>
                    <img src="img/agent.png"><a href="mainagent.php">Agent's Profile</a></li><hr><br>
                    <img src="img/add.png"><a href="addagent.html">Add Agent</a></li><hr><br>
                    <img src="img/accounts.png"><a href="home.html">Manage Accounts</a></li><hr><br>
                    <img src="img/logout.png"><a href="home.html">Log Out</a></li><hr>
                    </article>
                </aside>

                <aside class="middle-sidebar">
                <article>

                        <h4>Search the list:</h4><hr>
                        <form action="searchapp.php" method="GET">
                        <table>
                        <tr><td>ID No.<input size="6" type="text" id="id" name="id"></td></tr>
                        <tr><td><input type="submit" id="submit" name="submit" value="View Profile!"></td></tr>
                        <tr><td><input type="submit" id="submit" name="submit" value="delete"></td></tr>
                        </table>
                        </form>

                </article>
                </aside>
        </div>

        <footer class="mainFooter">
            <p>Copyright &copy; Team Necktie 2014<br> A member of <a href="http://filinvest.com">Filinvest Corporation</a>. Visit us also in our <a href="http://facebook.com">Facebook</a> page.</p>
        </footer>

<?php
} else die ("You need to specify an id!");
?>
</body>
</html>

Edited by jorwill.harion

2
Contributors
1
Reply
19
Views
3 Years
Discussion Span
Last Post by hericles
1

Seeing as your select statement doesn't include a WHERE statement I'm going to assume the query is returning more than one row. You are then looping through all returned rows and setting all of your variables.
At the end of this loop your variables are equal to the LAST row returned from the database. It's pretty unlikely that this row ID will match your $id variable.
Should your query be using a WHERE to get all rows matching $id?

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.