Need help creating this

533578 · April 10, 2020, 1:07pm

I need a survey where i can put all the houses with options. The option has to give the opportunity to rent more than one house to a person. I also need a survey where i can put all the houses, which needs two options. If the houses are rented it has to be send to the user information of sql and if the houses are not rented you need to be able to see them back in the survey. Can someone helpme out?

astonecipher · April 10, 2020, 1:13pm

Write out the functionality first.
Now under each step write out what needs to be done to accomplish that functionality

533578 · April 11, 2020, 4:25pm

Okay I will send my code that I have now. It is now just updating the sql table. I dont have any option to choose from houses. I need to write them down myself But I want to have a page where I can see all the houses. And if the house is rented I can see it on the list rented. If it is not rented I want to see it on the page not rented. I want them to insert the houses into ‘Pand’, but I also need to have the option to add multiple houses to the same people. But now I dont have any page where I put the houses in. I only have this to update the row ‘Pand’:

<html>
<head>
    <title>Pand toevoegen</title>
    <link rel="stylesheet" type="text/css" href="update.css">
</head>
<body>
<?php
    //connect with my sql
    $con = mysqli_connect("xxx");
    // Select database
    mysqli_select_db(xxx');
    //Select query
    $sql = "Select * from Info";
    //execute the query
    $records = mysqli_query($con, $sql);

?>
<table>
    <thead>
    <tr>
        <th>Naam</th>
        <th>E-mail</th>
        <th>Pand</th>
        <th>Huisnummer</th>
        <th>Deel</th>
    </tr>
    </thead>
    <tbody>
    <div class="input-group">
    <?php while ($row = mysqli_fetch_array($records))
    {
        echo "<tr><form  action='update.php' method='post' </form>";
        echo "<td><input class='input-group' type='text' name='Naam' value='".$row['Naam']."'</td>";
        echo "<td><input type='email' name='Email' value='".$row['Email']."'</td>";
        echo "<td><input type='text' name='Pand' value='".$row['Pand']."'</td>";
        echo "<td><input type='text' name='Huisnummer' value='".$row['Huisnummer']."'</td>";
        echo "<td><input type='text' name='Deel' value='".$row['Deel']."'</td>";
        echo "<td><input type='hidden' name='id' value='".$row['id']."'</td>";
        echo "<td><input type='submit' value='Opslaan'>";
        echo "</form></tr>";
    }
    ?>
    </div>
    </tbody>
</table>
</body>
</html>