Problem with PHP and Mysql

Question

Problem with PHP and Mysql

Asked 9 years, 4 months ago

Viewed 175 times

0

I’m doing a chat (chat) using PHP and Mysql, and I’m having problems.

I think it has to do with the fact that php 5.5 not accept more mysql, (now you need to use mysqli) Well, I have two files:

index php.

<html>
<head>
<title>Chat Box</title>


<script>
function submitChat() {
    if(form1.uname.value == '' || form1.msg.value == '') {
      alert('ALL FIELDS ARE MANDATORY!!!');
      return;
  }
  var uname = form1.uname.value;
  var msg = form1.msg.value;
  var xmlhttp = new XMLHttpRequest();

  xmlhttp.onreadystatechange = function() {
    if(xmlhttp.readyState==4&&xmlhttp.status==200) {
      document.getElementById('chatlogs').innerHTML = xmlhttp.responseText;
    }
  }
  xmlhttp.open('GET','insert.php?uname='+uname+'&msg='+msg,true);
  xmlhttp.send();
}
</script>


</head>
<body>
<form name="form1">
Enter Your Chatname: <input type="text" name="uname"><br>
Your Message: <br>
<textarea name="msg"></textarea><br>
<a href="#" onclick="submitChat()">Send</a><br><br>
<div id="chatlogs">
LOADING CHATLOGS PLEASE WAIT...
</div>

</body>
</html>

Insert.php

<?
$uname = $_REQUEST['uname'];
$msg = $_REQUEST['msg'];

$con = mysqli_connect('XXX','XXX','XXX','XXX');

mysqli_query($con,"INSERT INTO logs ('username','msg') VALUES ('$uname','$msg')");

$result1 = mysqli_query($con,"SELECT * FROM logs ORDER by id DESC");

while($extract = mysqli_fetch_array($result1)) {
  echo "<span class='uname'>" . $extract['username'] . "</span>: <span class='msg'>" . $extract['msg'] . "</span><br>";
}
?>

I have a domain where the code is: mundozoeira.com.br

So you can go there to see the behavior.

What’s the matter? @Renan

– Wellington Avelino

2015/07/07 at 20:47
The chat just doesn’t work. I send the message and nothing happens. I mean, the phrase "LOADING CHATLOGS PLEASE WAIT..." disappears, it is replaced using innerHTML. I have no idea what it is...

– user27503

2015/07/07 at 20:51
Could be an error in mysql database?

– user27503

2015/07/07 at 21:04
Brother, after your connection put this code. if ( $con ->connect_errno )
 {
 printf("Erro na Conexão: %s\n", $con ->connect_error);
 exit();
 }

– MoisesGama

2015/07/07 at 21:10
I already did. Nothing happened.

– user27503

2015/07/07 at 21:19

1 answer

Browser other questions tagged php mysql

You are not signed in. Login or sign up in order to post.

by Guilherme Nascimento • **98,651** points · Answer 1 · 2015-07-07T22:44:56+00:00

The problem is in your query, mysql no use apostrophe (') where we make references to the columns, the correct is:

INSERT INTO logs (`username`,`msg`) VALUES ('$uname','$msg')

It might be a connection error with mysql, try editing the file for something like:

<?php
error_reporting(E_ALL|E_STRICT);

$uname = empty($_REQUEST['uname']) ? NULL : $_REQUEST['uname'];
$msg = empty($_REQUEST['msg']) ? NULL : $_REQUEST['msg'];

if (NULL === $uname || NULL === $msg) {
    echo 'Faltam dados';
    exit;
}

$con = mysqli_connect('XXX','XXX','XXX','XXX');

if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit;
}

$resultado = mysqli_query($con,"INSERT INTO logs (`username`, `msg`) VALUES ('$uname','$msg')");

if ($resultado === false) {
    printf("Error: %s\n", mysqli_error($con));
    exit;
}

$result1 = mysqli_query($con,"SELECT * FROM logs ORDER by id DESC");

if ($result1 === false) {
    printf("Error: %s\n", mysqli_error($con));
    exit;
}

while($extract = mysqli_fetch_array($result1)) {
    echo "<span class='uname'>" . $extract['username'] . "</span>: <span class='msg'>" . $extract['msg'] . "</span><br>";
}

mysqli_close($con);
?>

To use the severe accent character in mysql queries, use the key next to the number 1 and above the tab without using the Shift, as in the image:

Teclado Abnt

Problem with PHP and Mysql

1 answer

Other possible problems