I recently uploaded my site from my pc to ubuntu with ssh.
Before I uploaded it worked fine with xampp.
Now everything else is working but mysql insert query.
Connect is working and mysql update. Nothing in mysql error.log
.
Select is working too.
This is not working
$user_query = $db->prepare("INSERT INTO users (id, userid, name) VALUES (:id, :userid, :name)");
if($url_query->execute(array(":id" => "", ":userid" => $userid, ":name" => $name))){
header("location: /");
}
This is working
$user_query = $db->prepare("UPDATE users SET name=:name WHERE userid =:userid");
if($user_query->execute(array(":name" => $name, ":userid" => $userid))){
header("location: /");
}
I don't see any difference between these two querys.
Table
+----------+---------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+---------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| userid | text | NO | | NULL | |
| name | text | NO | | NULL | |
+----------+---------+------+-----+---------+----------------+
My host is from digitalocean and I used this when I installed my apache and mysql
$user_query = $db->prepare("SELECT id FROM users WHERE userid=:userid");
if($user_query->execute(array(":userid" => $userid))){
if($user_query->rowCount()){
$user_query = $db->prepare("UPDATE users SET name=:name WHERE userid =:userid");
if($user_query->execute(array(":name" => $name, ":userid" => $userid))){
header("location: /");
}
} else {
$user_query= $db->prepare("INSERT INTO users (id, userid, name) VALUES (:id, :userid, :name)");
if($user_query->execute(array(":id" => "", ":userid" => $userid, ":name" => $name))){
header("location: /");
}
}
}