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(); }