/**
* Get the MySqli connection
* @return mysqli
*/
public static function getConnection()
{
if (self::$instance == NULL) {
self::$instance = new DBCnf();
}
return self::$instance->conn;
}
/**
* Storing new user
* returns user details
*/
public function storeUser($name, $email, $regid)
{
$con = DBCnf::getConnection();
$sql = "insert into gcm_users set name=" . "'" . $name . "',email=" . "'" . $email . "',gcm_regid=" . "'" . $regid . "',created_at=NOW()";
$result = mysqli_query($con, $sql);
if ($result) {
$id = mysqli_insert_id($con);
// last inserted id
$result = mysqli_query($con, "SELECT * FROM gcm_users WHERE id = {$id}") or die(mysql_error());
if (mysqli_num_rows($result) > 0) {
return mysqli_fetch_array($result);
} else {
return false;
}
} else {
return false;
}
}
