public static function getRowCount()
{
$con = new connection();
$connection = $con->getConnection();
$query = "select * from manufacturer";
$result = $connection->query($query) or die(mysqli_error($connection));
return mysqli_num_rows($result) + 10;
}
public function uploadFile($uploadclassObj)
{
$fileid = $uploadclassObj->getFileid();
$upload_filename = $uploadclassObj->getFilename();
$con = new connection();
$connection = $con->getConnection();
$query = "insert into uploads values(null, '{$fileid}', '{$upload_filename}')";
$result = $connection->query($query) or die(mysqli_error($connection));
}
public function getUserByName($name)
{
$con = new connection();
$db = $con->getConnection();
$sql = "SELECT * FROM user WHERE name=" . $name;
foreach ($db->query($sql) as $row) {
$user[] = array('id' => $row['id'], 'name' => $row['name'], 'password' => $row['password'], 'mail' => $row['mail'], 'adresse' => $row['adresse'], 'tel' => $row['tel']);
}
}
<html> <head> <link rel="stylesheet" type="text/css" href="css/css/bootstrap.min.css"> <link rel="stylesheet" href="css/style.css" type="text/css"> </head> <body> <?php require_once "connection.php"; $con = new connection(); $connection = $con->getConnection(); $query = "select * from manufacturer where active=1"; $result = $connection->query($query) or die(mysqli_error($connection)); ?> <div class="container-fluid head" > <span class="glyphicon glyphicon-cog" aria-hidden="true"></span> RandomGenerator </div> <div class="row"> <br/><br/><br/><br/><br/><br/> <div class="col-md-2 col-md-offset-3"> <div id="nav"> <div class="active"><a href="index.php">Generate Serials</a></div> <div><a href="create.php">Create New User</a></div> <div><a href="editList.php">Add/Delete User</a></div> </div> </div> <div class="col-md-3 main">
public function __construct(connection $con)
{
$this->condb = $con->getConnection();
}
