# Insert query doesn't work

**URL:** https://forum.infinityfree.com/t/insert-query-doesnt-work/45057
**Category:** Hosting Support
**Created:** [May 14, 2021, 5:33pm UTC](https://forum.infinityfree.com/t/insert-query-doesnt-work/45057 "2021-05-14T17:33:21Z")
**Posts on this page:** 14
**Page:** 1

<div class="post-metadata">

### Author: ![anon1999020](https://forum.infinityfree.com/letter_avatar/anon1999020/32/5_5575768a8748004e209b776fc1b2916d.png) [@anon1999020](https://forum.infinityfree.com/u/anon1999020)
#### Post date: [May 14, 2021, 5:33pm UTC](https://forum.infinityfree.com/t/insert-query-doesnt-work/45057/1 "2021-05-14T17:33:21Z")

</div>

The code is this:

Tragaperras

 \<?php $conexion=[...]; if(!$conexion){ echo "Error de conexión."; } $insercion=mysqli\_query($conexion,"INSERT INTO `usuarios` VALUES ('".$\_SERVER['REMOTE\_ADDR']."','0','".random(12)."','".random(12)."')"); if(!$insercion){ $actualizar=mysqli\_query($conexion,"UPDATE `usuarios` SET carta\_anterior='".random(12)."' WHERE IP='".$\_SERVER['REMOTE\_ADDR']."'"); if(!$actualizar){ echo "Ha habido un error al actualizar la carta."; } $actualizar2=mysqli\_query($conexion,"UPDATE `usuarios` SET carta='".random(12)."' WHERE IP='".$\_SERVER['REMOTE\_ADDR']."'"); if(!$actualizar2){ echo "Ha habido un error al actualizar la carta."; } } $lectura=mysqli\_query($conexion,"SELECT \* FROM `usuarios` WHERE IP='".$\_SERVER['REMOTE\_ADDR']."'"); if($lectura){ while($row=mysqli\_fetch\_row($lectura)){ $carta\_anterior=$row[3]; $carta=$row[2]; } }else{ echo "Error de lectura"; } if($carta\_anterior=='9'){ $carta\_anterior\_traducida='J'; } if($carta\_anterior=='10'){ $carta\_anterior\_traducida='Q'; } if($carta\_anterior=='11'){ $carta\_anterior\_traducida='K'; } if($carta\_anterior=='0'){ $carta\_anterior\_traducida='A'; } if(random(2)\<1){ if(random(2)\<1){ $palo='♠'; }else{ $palo='⧫'; } }else{ if(random(2)\<1){ $palo='♡'; }else{ $palo='♧'; } } echo "
# Tu carta es: ".$carta\_anterior\_traducida."".$palo."
"; if(isset($\_POST["arriba"])){ //echo "Apostastes que la siguiente carta será superior."; if($carta\_anterior\<$carta){ $aciertos++; }else{ $aciertos=0; } } if(isset($\_POST["abajo"])){ //echo "Apostastes que la siguiente carta será inferior."; if($carta\_anterior\>$carta){ $aciertos++; }else{ $aciertos=0; } } $actualizar3=mysqli\_query($conexion,"UPDATE `usuarios` SET aciertos='".$aciertos."' WHERE IP='".$\_SERVER['REMOTE\_ADDR']."'"); if(!$actualizar3){ echo "Ha habido un error al actualizar la carta."; } $lectura2=mysqli\_query($conexion,"SELECT \* FROM `usuarios` ORDER BY aciertos DESC"); if($lectura2){ while($row=mysqli\_fetch\_row($lectura2)){ echo $row[1]; } }else{ echo "Error de lectura"; } ?\>

When I execute that code it doesnt give me any erros, but doesn’t create the row too with the IP and the user. I dont have an idea that what’s happenning. How to solve it? Thanks for helping anyway.

---

<div class="post-metadata">

### Author: ![TigerMANEK426](https://forum.infinityfree.com/user_avatar/forum.infinityfree.com/tigermanek426/32/12600_2.png) [@TigerMANEK426](https://forum.infinityfree.com/u/TigerMANEK426)
#### Post date: [May 14, 2021, 6:25pm UTC](https://forum.infinityfree.com/t/insert-query-doesnt-work/45057/2 "2021-05-14T18:25:31Z")

</div>

Please edit your post and use code blocks (``` code ```) as it is impossible to read your post.

---

<div class="post-metadata">

### Author: ![anon1999020](https://forum.infinityfree.com/letter_avatar/anon1999020/32/5_5575768a8748004e209b776fc1b2916d.png) [@anon1999020](https://forum.infinityfree.com/u/anon1999020)
#### Post date: [May 14, 2021, 6:54pm UTC](https://forum.infinityfree.com/t/insert-query-doesnt-work/45057/3 "2021-05-14T18:54:18Z")

</div>

```auto
<?php $conexion=[...]; if(!$conexion){ echo "Error de conexión."; } $insercion=mysqli_query($conexion,"INSERT INTO `usuarios` VALUES ('".$_SERVER['REMOTE_ADDR']."','0','".random(12)."','".random(12)."')"); if(!$insercion){ $actualizar=mysqli_query($conexion,"UPDATE `usuarios` SET carta_anterior='".random(12)."' WHERE IP='".$_SERVER['REMOTE_ADDR']."'"); if(!$actualizar){ echo "Ha habido un error al actualizar la carta."; } $actualizar2=mysqli_query($conexion,"UPDATE `usuarios` SET carta='".random(12)."' WHERE IP='".$_SERVER['REMOTE_ADDR']."'"); if(!$actualizar2){ echo "Ha habido un error al actualizar la carta."; } } $lectura=mysqli_query($conexion,"SELECT * FROM `usuarios` WHERE IP='".$_SERVER['REMOTE_ADDR']."'"); if($lectura){ while($row=mysqli_fetch_row($lectura)){ $carta_anterior=$row[3]; $carta=$row[2]; } }else{ echo "Error de lectura"; } if($carta_anterior=='9'){ $carta_anterior_traducida='J'; } if($carta_anterior=='10'){ $carta_anterior_traducida='Q'; } if($carta_anterior=='11'){ $carta_anterior_traducida='K'; } if($carta_anterior=='0'){ $carta_anterior_traducida='A'; } if(random(2)<1){ if(random(2)<1){ $palo='♠'; }else{ $palo='⧫'; } }else{ if(random(2)<1){ $palo='♡'; }else{ $palo='♧'; } } echo "

# Tu carta es: ".$carta_anterior_traducida."".$palo."

"; if(isset($_POST["arriba"])){ //echo "Apostastes que la siguiente carta será superior."; if($carta_anterior<$carta){ $aciertos++; }else{ $aciertos=0; } } if(isset($_POST["abajo"])){ //echo "Apostastes que la siguiente carta será inferior."; if($carta_anterior>$carta){ $aciertos++; }else{ $aciertos=0; } } $actualizar3=mysqli_query($conexion,"UPDATE `usuarios` SET aciertos='".$aciertos."' WHERE IP='".$_SERVER['REMOTE_ADDR']."'"); if(!$actualizar3){ echo "Ha habido un error al actualizar la carta."; } $lectura2=mysqli_query($conexion,"SELECT * FROM `usuarios` ORDER BY aciertos DESC"); if($lectura2){ while($row=mysqli_fetch_row($lectura2)){ echo $row[1]; } }else{ echo "Error de lectura"; } ?>

```

---

<div class="post-metadata">

### Author: ![alexvf](https://forum.infinityfree.com/user_avatar/forum.infinityfree.com/alexvf/32/14357_2.png) [@alexvf](https://forum.infinityfree.com/u/alexvf)
#### Post date: [May 14, 2021, 6:54pm UTC](https://forum.infinityfree.com/t/insert-query-doesnt-work/45057/4 "2021-05-14T18:54:50Z")

</div>

You have to paste here the `$conexion` value for us to see why the connection is failing.  
**Just don’t paste the password!**

---

<div class="post-metadata">

### Author: ![Greenreader9](https://forum.infinityfree.com/user_avatar/forum.infinityfree.com/greenreader9/32/22847_2.png) [@Greenreader9](https://forum.infinityfree.com/u/Greenreader9)
#### Post date: [May 14, 2021, 6:56pm UTC](https://forum.infinityfree.com/t/insert-query-doesnt-work/45057/5 "2021-05-14T18:56:20Z")

</div>

```auto
<?php $conexion=[...]; if(!$conexion){ echo "Error de conexión."; } $insercion=mysqli_query($conexion,"INSERT INTO `usuarios` VALUES ('".$_SERVER['REMOTE_ADDR']."','0','".random(12)."','".random(12)."')"); if(!$insercion){ $actualizar=mysqli_query($conexion,"UPDATE `usuarios` SET carta_anterior='".random(12)."' WHERE IP='".$_SERVER['REMOTE_ADDR']."'"); if(!$actualizar){ echo "Ha habido un error al actualizar la carta."; } $actualizar2=mysqli_query($conexion,"UPDATE `usuarios` SET carta='".random(12)."' WHERE IP='".$_SERVER['REMOTE_ADDR']."'"); if(!$actualizar2){ echo "Ha habido un error al actualizar la carta."; } } $lectura=mysqli_query($conexion,"SELECT * FROM `usuarios` WHERE IP='".$_SERVER['REMOTE_ADDR']."'"); if($lectura){ while($row=mysqli_fetch_row($lectura)){ $carta_anterior=$row[3]; $carta=$row[2]; } }else{ echo "Error de lectura"; } if($carta_anterior=='9'){ $carta_anterior_traducida='J'; } if($carta_anterior=='10'){ $carta_anterior_traducida='Q'; } if($carta_anterior=='11'){ $carta_anterior_traducida='K'; } if($carta_anterior=='0'){ $carta_anterior_traducida='A'; } if(random(2)<1){ if(random(2)<1){ $palo='♠'; }else{ $palo='⧫'; } }else{ if(random(2)<1){ $palo='♡'; }else{ $palo='♧'; } } echo " # Tu carta es: ".$carta_anterior_traducida."".$palo." "; if(isset($_POST["arriba"])){ //echo "Apostastes que la siguiente carta será superior."; if($carta_anterior<$carta){ $aciertos++; }else{ $aciertos=0; } } if(isset($_POST["abajo"])){ //echo "Apostastes que la siguiente carta será inferior."; if($carta_anterior>$carta){ $aciertos++; }else{ $aciertos=0; } } $actualizar3=mysqli_query($conexion,"UPDATE `usuarios` SET aciertos='".$aciertos."' WHERE IP='".$_SERVER['REMOTE_ADDR']."'"); if(!$actualizar3){ echo "Ha habido un error al actualizar la carta."; } $lectura2=mysqli_query($conexion,"SELECT * FROM `usuarios` ORDER BY aciertos DESC"); if($lectura2){ while($row=mysqli_fetch_row($lectura2)){ echo $row[1]; } }else{ echo "Error de lectura"; } ?>

```

---

<div class="post-metadata">

### Author: ![anon1999020](https://forum.infinityfree.com/letter_avatar/anon1999020/32/5_5575768a8748004e209b776fc1b2916d.png) [@anon1999020](https://forum.infinityfree.com/u/anon1999020)
#### Post date: [May 14, 2021, 6:57pm UTC](https://forum.infinityfree.com/t/insert-query-doesnt-work/45057/7 "2021-05-14T18:57:06Z")

</div>

```
<title>Tragaperras</title>
<link rel="icon" type="image/png" href="https://i.ibb.co/59gR5FP/icono-estatista-comunista.png">
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css" integrity="sha384-ggOyR0iXCbMQv3Xipma34MD+dH/1fQ784/j6cY/iJTQUOhcWr7x9JvoRxT2MZw1T" crossorigin="anonymous">
<script src="https://code.jquery.com/jquery-3.4.1.slim.min.js" integrity="sha384-J6qa4849blE2+poT4WnyKhv5vZF5SrPo0iEjwBvKU7imGFAV0wwj1yYfoRSJoZ+n" crossorigin="anonymous"></script>
<script src="https://cdn.jsdelivr.net/npm/popper.js@1.16.0/dist/umd/popper.min.js" integrity="sha384-Q6E9RHvbIyZFJoft+2mJbHaEWldlvI9IOYy5n3zV9zzTtmI3UksdQRVvoxMfooAo" crossorigin="anonymous"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.4.1/js/bootstrap.min.js" integrity="sha384-wfSDF2E50Y2D1uUdj0O3uMBJnjuUD4Ih7YwaYd1iqfktj0Uod8GCExl3Og8ifwB6" crossorigin="anonymous"></script>
<script src="https://werenverlivitz.github.io/werenverlivitz/array.js" async></script>
<link rel="icon" type="image/png" href="https://i.ibb.co/59gR5FP/icono-estatista-comunista.png">
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css" integrity="sha384-ggOyR0iXCbMQv3Xipma34MD+dH/1fQ784/j6cY/iJTQUOhcWr7x9JvoRxT2MZw1T" crossorigin="anonymous">
<div style="overflow:scroll"id="div4">
	<nav class="navbar navbar-light" style="background-color: #002244"id="nav1">
	  	<div id="LS_BANNER_1278"></div><script src="//linkslot.pro/bancode.php?id=1278" async></script>
	  	<div id="LS_BANNER_1279"></div><script src="//linkslot.pro/bancode.php?id=1279" async></script>
	</nav>
	<nav class="navbar navbar-light" style="background-color: #002244"id="nav1">
	  	<div id="LS_BANNER_1276"></div><script src="//linkslot.pro/bancode.php?id=1276" async></script>
	  	<div id="LS_BANNER_1277"></div><script src="//linkslot.pro/bancode.php?id=1277" async></script>
	</nav>
</div>
<form method="POST"action="/">
    <input type="submit"class="btn btn-primary"value="Apostar arriba."name="arriba">
</form>
<form method="POST"action="/">
    <input type="submit"class="btn btn-primary"value="Apostar abajo."name="abajo">
</form>
<form method="POST"action="/">
    <input type="submit"class="btn btn-primary"value="Abstenerse."name="abstenerse">
</form>
<h1>La carta tiene que ser al menos 2 unidades menor o mayor que la otra.</h1>
<?php
$conexion=mysqli_connect("sql301.epizy.com","epiz_28445980","[...]","epiz_28445980_freeruble");
if(!$conexion){
    echo "Error de conexión.";
}
$insercion=mysqli_query($conexion,"INSERT INTO `usuarios` VALUES ('".$_SERVER['REMOTE_ADDR']."','0','".random(12)."','".random(12)."')");
if(!$insercion){
    $actualizar=mysqli_query($conexion,"UPDATE `usuarios` SET carta_anterior='".random(12)."' WHERE IP='".$_SERVER['REMOTE_ADDR']."'");
    if(!$actualizar){
        echo "Ha habido un error al actualizar la carta.";
    }
    $actualizar2=mysqli_query($conexion,"UPDATE `usuarios` SET carta='".random(12)."' WHERE IP='".$_SERVER['REMOTE_ADDR']."'");
    if(!$actualizar2){
        echo "Ha habido un error al actualizar la carta.";
    }
}
$lectura=mysqli_query($conexion,"SELECT * FROM `usuarios` WHERE IP='".$_SERVER['REMOTE_ADDR']."'");
if($lectura){
    while($row=mysqli_fetch_row($lectura)){
        $carta_anterior=$row[3];
        $carta=$row[2];
    }
}else{
    echo "Error de lectura";
}
if($carta=='9'){
    $carta_traducida='J';
}
if($carta=='10'){
    $carta_traducida='Q';
}
if($carta=='11'){
    $carta_traducida='K';
}
if($carta=='0'){
    $carta_traducida='A';
}
if(random(2)<1){
    if(random(2)<1){
        $palo='♠';
    }else{
        $palo='⧫';
    }
}else{
    if(random(2)<1){
        $palo='♡';
    }else{
        $palo='♧';
    }   
}
if($carta_anterior=='9'){
    $carta_anterior_traducida='J';
}
if($carta_anterior=='10'){
    $carta_anterior_traducida='Q';
}
if($carta_anterior=='11'){
    $carta_anterior_traducida='K';
}
if($carta_anterior=='0'){
    $carta_anterior_traducida='A';
}
if(random(2)<1){
    if(random(2)<1){
        $palo_anterior='♠';
    }else{
        $palo_anterior='⧫';
    }
}else{
    if(random(2)<1){
        $palo_anterior='♡';
    }else{
        $palo_anterior='♧';
    }   
}
echo "<h1>Tu carta es: ".$carta_anterior_traducida."".$palo_anterior."</h1>";
if(isset($_POST["arriba"])){
    //echo "Apostastes que la siguiente carta será superior.";
    echo "<h1>Tu carta es: ".$carta_traducida."".$palo."</h1>";
    if($carta_anterior<$carta-2){
        $aciertos++;
    }else{
        $aciertos=0;
    }
}
if(isset($_POST["abajo"])){
    //echo "Apostastes que la siguiente carta será inferior.";
    echo "<h1>Tu carta es: ".$carta_traducida."".$palo."</h1>";
    if($carta_anterior>$carta+2){
        $aciertos++;
    }else{
        $aciertos=0;
    }
}
$actualizar3=mysqli_query($conexion,"UPDATE `usuarios` SET aciertos='".$aciertos."' WHERE IP='".$_SERVER['REMOTE_ADDR']."'");
if(!$actualizar3){
    echo "Ha habido un error al actualizar la carta.";
}
$lectura2=mysqli_query($conexion,"SELECT * FROM `usuarios` ORDER BY aciertos DESC");
if($lectura2){
    while($row=mysqli_fetch_row($lectura2)){
        echo $row[1];
    }
}else{
    echo "Error de lectura";
}
?>

```

---

<div class="post-metadata">

### Author: ![alexvf](https://forum.infinityfree.com/user_avatar/forum.infinityfree.com/alexvf/32/14357_2.png) [@alexvf](https://forum.infinityfree.com/u/alexvf)
#### Post date: [May 14, 2021, 6:59pm UTC](https://forum.infinityfree.com/t/insert-query-doesnt-work/45057/8 "2021-05-14T18:59:25Z")

</div>

The connection string seems correct.  
Do you have any error messages, any logs?

---

<div class="post-metadata">

### Author: ![anon1999020](https://forum.infinityfree.com/letter_avatar/anon1999020/32/5_5575768a8748004e209b776fc1b2916d.png) [@anon1999020](https://forum.infinityfree.com/u/anon1999020)
#### Post date: [May 14, 2021, 6:59pm UTC](https://forum.infinityfree.com/t/insert-query-doesnt-work/45057/9 "2021-05-14T18:59:36Z")

</div>

No

---

<div class="post-metadata">

### Author: ![TigerMANEK426](https://forum.infinityfree.com/user_avatar/forum.infinityfree.com/tigermanek426/32/12600_2.png) [@TigerMANEK426](https://forum.infinityfree.com/u/TigerMANEK426)
#### Post date: [May 14, 2021, 8:19pm UTC](https://forum.infinityfree.com/t/insert-query-doesnt-work/45057/10 "2021-05-14T20:19:17Z")

</div>

Ok can you please try this:

At the end of your file add this code:

```auto
echo $conexion->error;

```

It will reveal any errors that occurred while executing the query.

---

<div class="post-metadata">

### Author: ![anon1999020](https://forum.infinityfree.com/letter_avatar/anon1999020/32/5_5575768a8748004e209b776fc1b2916d.png) [@anon1999020](https://forum.infinityfree.com/u/anon1999020)
#### Post date: [May 14, 2021, 9:27pm UTC](https://forum.infinityfree.com/t/insert-query-doesnt-work/45057/11 "2021-05-14T21:27:42Z")

</div>

Same result…

---

<div class="post-metadata">

### Author: ![TigerMANEK426](https://forum.infinityfree.com/user_avatar/forum.infinityfree.com/tigermanek426/32/12600_2.png) [@TigerMANEK426](https://forum.infinityfree.com/u/TigerMANEK426)
#### Post date: [May 15, 2021, 6:26am UTC](https://forum.infinityfree.com/t/insert-query-doesnt-work/45057/12 "2021-05-15T06:26:04Z")

</div>

Was en error echoed out?

---

<div class="post-metadata">

### Author: ![anon1999020](https://forum.infinityfree.com/letter_avatar/anon1999020/32/5_5575768a8748004e209b776fc1b2916d.png) [@anon1999020](https://forum.infinityfree.com/u/anon1999020)
#### Post date: [May 15, 2021, 7:16am UTC](https://forum.infinityfree.com/t/insert-query-doesnt-work/45057/13 "2021-05-15T07:16:25Z")

</div>

I think nothing:

 ![image](https://forum-cdn.infinityfree.net/original/2X/0/07af94f9df55a6dad48623c9022ded2bf87e1420.png)

---

<div class="post-metadata">

### Author: ![anon1999020](https://forum.infinityfree.com/letter_avatar/anon1999020/32/5_5575768a8748004e209b776fc1b2916d.png) [@anon1999020](https://forum.infinityfree.com/u/anon1999020)
#### Post date: [May 15, 2021, 7:23am UTC](https://forum.infinityfree.com/t/insert-query-doesnt-work/45057/14 "2021-05-15T07:23:00Z")

</div>

![image](https://forum-cdn.infinityfree.net/original/2X/8/8b6bce5fcb62f4f0354a663d60e8e32439d8c6ec.png)

---

<div class="post-metadata">

### Author: ![system](https://infinityfree-forum-uploads.s3.dualstack.eu-central-1.amazonaws.com/original/3X/b/0/b024fd3fa88bae093c9576e55c2c94e33f890206.svg) [@system](https://forum.infinityfree.com/u/system)
#### Post date: [May 30, 2021, 7:23am UTC](https://forum.infinityfree.com/t/insert-query-doesnt-work/45057/15 "2021-05-30T07:23:04Z")

</div>

This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.