Похожие чаты

<!DOCTYPE html> <html lang="en"> <head> <title>View</title> <!-- Bootstrap core CSS--> <link

href="bootstrap/css/bootstrap.min.css" rel="stylesheet">
<!-- Custom fonts for this template-->
<link href="bootstrap/font-awesome/css/font-awesome.min.css" rel="stylesheet" type="text/css">
<!-- Custom styles for this template-->
<link href="bootstrap/css/apna.css" rel="stylesheet">
</head>

<?php include 'header.php'; ?>
<h1 align="center">DETAILS</h1>
<?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = '';

$conn = mysql_connect($dbhost, $dbuser, $dbpass);

if(! $conn ) {
die('Could not connect: ' . mysql_error());
}

$sql = 'SELECT VendorCode, ServiceProvider, AMC, ReferenceNo, ServiceFrom, ServiceTo, POAmount, POExpireIn, CurrentStatus, ResponsiblePerson, Remark, Category FROM details';
$sql2='Select role from user';
mysql_select_db('table');
$retval = mysql_query( $sql, $conn );

if(! $retval ) {
die('Could not get data: ' . mysql_error());
}
?> " <table border = '2' align="center">
<?php echo "<tr>";
echo "<th>Vendor Code</th>";
echo "<th>Service Provider</th>";
echo "<th>AMC</th>";
echo "<th>Reference No.</th>";
echo "<th>Service From</th>";
echo "<th>Service To</th>";
echo "<th>PO Amount</th>";
echo "<th>PO ExpireIn</th>";
echo "<th>Current Status</th>";
echo "<th>Responsible Person</th>";
echo "<th>Remark</th>";
echo "<th>Category</th>";
echo "<th>Action</th>";

echo "</tr>";
while($row = mysql_fetch_assoc($retval)) {
if($row['ServiceTo']>date("Y-m-d")){
echo "<tr>";
echo "<td>".$row['VendorCode']. "</td>";
echo "<td>".$row['ServiceProvider']. "</td>";
echo "<td>".$row['AMC']. "</td>";
echo "<td>".$row['ReferenceNo']. "</td>";
echo "<td>".$row['ServiceFrom']. "</td>";
echo "<td>".$row['ServiceTo']. "</td>";
echo "<td>".$row['POAmount']. "</td>";
echo "<td>".$row['POExpireIn']. "</td>";
echo "<td>".$row['CurrentStatus']. "</td>";
echo "<td>".$row['ResponsiblePerson']. "</td>";
echo "<td>".$row['Remark']. "</td>";
echo "<td>".$row['Category']. "</td>";
if($sql2=1){
echo "<td><form action='edit.php' method='POST'><input type='hidden' name='VendorCode' value='".$row["VendorCode"]."'/><input type='submit' name='submit-btn' value='Edit' /></form></td>";
}
echo "</tr>";
}
else{
echo "<tr bgcolor=\"#ff4d4d\">";
echo "<td>".$row['VendorCode']. "</td>";
echo "<td>".$row['ServiceProvider']. "</td>";
echo "<td>".$row['AMC']. "</td>";
echo "<td>".$row['ReferenceNo']. "</td>";
echo "<td>".$row['ServiceFrom']. "</td>";
echo "<td>".$row['ServiceTo']. "</td>";
echo "<td>".$row['POAmount']. "</td>";
echo "<td>".$row['POExpireIn']. "</td>";
echo "<td>".$row['CurrentStatus']. "</td>";
echo "<td>".$row['ResponsiblePerson']. "</td>";
echo "<td>".$row['Remark']. "</td>";
echo "<td>".$row['Category']. "</td>";
if($sql2=1){
echo "<td><form action='edit.php' method='POST'><input type='hidden' name='VendorCode' value='".$row["VendorCode"]."'/><input type='submit' name='submit-btn' value='Edit' /></form></td>";
}
echo "</tr>";

}
} ?>

</table>

<?php
mysql_close($conn);
?>

</html>

2 ответов

12 просмотров

😳 you are using mysql_connect() ? : https://www.php.net/manual/en/function.mysql-connect.php Warning This extension was deprecated in PHP 5.5.0, and it was removed in PHP 7.0.0. Instead, the MySQLi or PDO_MySQL extension should be used. See also MySQL: choosing an API guide and related FAQ for more information. Alternatives to this function include: mysqli_connect() PDO::__construct()

Don't write like so

Похожие вопросы

Обсуждают сегодня

30500 за редактор? )
Владимир
47
а через ESC-код ?
Alexey Kulakov
29
Anyone knows where there are some instructions or discort about failed bridge transactions ?
Jochem
21
Чёт не понял, я ж правильной функцией воспользовался чтобы вывести отладочную информацию? но что-то она не ловится
notme
18
Also, why can’t the community have a vote/ say when it comes to initiatives like buybacks. Isn’t the point of crypto decentralisation? Don’t we deserve input as long term supp...
👨🏽‍🦰
13
Привет)) уже кажется эту тему перемусолили, но вот я так и не понял. Я сейчас сижу на 27дюймов 2к мониторе. На Актуальной макоси, если я куплю 27д 4к монитор: - будет ли изобр...
Vladislav Piskunov
16
any reference of this implementation?
BitBuddha
29
Hi guys, any problem with Pulsebrige? Trying to transfer from wETH to ETH. First it tells me to connect my metamask "through mobile app" not desktop. Then I did and confirmed ...
Snowflakecrypto
13
Страшнейшая правда про списки ЦБ. С первых дней жизни P2P сферы, молодые человеки, начитавшись законодательной базы и "внутренних" документов, решили, что им противостоит сер...
Foxcool
3
У меня есть функция где происходит это: write_bit(buffer, 1); write_bit(buffer, 0); write_bit(buffer, 1); write_bit(buffer, 1); write_bit(buffer, 1); w...
~
13
Карта сайта