Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $Headline=$_POST["Headline"];
- $Category=$_POST["Category"];
- $Writer=$_POST["Writer"];
- $Source=$_POST["Source"];
- $Story=$_POST["Story"];
- $Daresubmitted=$_POST["Datesubmitted"];
- $host = "localhost";
- $user = "root";
- $pass = "";
- $db = "addarticle";
- $link = mysqli_connect($host, $user, $pass, $db);
- $query = "SELECT * FROM addarticle WHERE Headline LIKE '%$Headline%'";
- $result = mysqli_query($link, $query) or die(mysqli_error($link));
- $row=mysqli_fetch_array($result);
- {
- $arrnews[] = $row;
- }
- mysqli_close($link);
- echo '<table border="1" cellpadding="10">
- <tr>
- <th>Category<th>
- <th>Headline</th>
- <th>Writer</th>
- <th>Source</th>
- <th>Date</th>
- <th>Story</th>
- </tr>';
- while ($row = mysqli_fetch_array($result)) {
- echo "<tr>
- <td>" . $row['Category'] . "</td>
- <td>" . $row['Headline'] . "</td>
- <td>" . $row['Writer'] . "</td>
- <td>" . $row['Source'] . "</td>
- <td>" . $row['Datesubmitted'] . "</td>
- <td>" . $row['Story'] . "</td>
- </tr>";
- }
- echo '</table>';
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement