· 8 years ago · Mar 13, 2018, 04:40 PM
1Uncaught ReferenceError: SetInterval is not defined
2 at (index):22
3(anonymous) @ (index):22
4(index):10 Uncaught ReferenceError: XMLHttprequest is not defined
5 at ajax ((index):10)
6 at onload ((index):26)
7
8<?php
9include"conexion.php"
10 ?>
11
12<!DOCTYPE html>
13<html lang="en">
14<head>
15 <meta charset="UTF-8">
16 <title>chat</title>
17 <link rel="stylesheet" href="css/chat.css">
18 <script type="text/javascript">
19 function ajax(){
20 var req= XMLHttprequest();
21 req.onReadyStatechange=function(){
22 if (req.readyState==4 && req.status==200) {
23 document.getElementById('chat').innerHTML=req.responseText;
24 }
25 }
26 req.open('GET','chat.php',true);
27 req.send();
28 }
29
30 //refrescar la pagina cada segundo
31
32 SetInterval(function(){ajax();}, 1000);
33 </script>
34
35</head>
36<body onLoad="ajax()">
37
38 <div id="contenedor">
39 <div id="caja-chat" class="chat">
40 <div id="chat">
41 <?php
42
43 $consulta="SELECT * FROM chat order by id ";
44 $ejecutar=$cn->query($consulta);
45 while($fila=$ejecutar->fetch_array()):
46 ?>
47 <div id="datos-chat">
48 <span style="color: #1c62c4"><?php echo $fila['nombre'] ; ?> : </span>
49 <span style="color: #848484"><?php echo $fila['mensaje']; ?></span>
50 <span style="float: right;"><?php echo formatearfecha ($fila['fecha']); ?></span>
51 </div>
52<?php endwhile; ?>
53 </div>
54 </div>
55 <form method="POST" action="index.php">
56 <input type="text" name="nombre" placeholder="ingresa tu nombre" >
57 <textarea name="mensaje" id="" placeholder="ingresa tu mensaje" cols="30" rows="10"></textarea>
58 <input type="submit" value="enviar" name="enviar">
59 </form>
60 <?php
61 if (isset($_POST['enviar'])) {
62 $nombre=$_POST['nombre'];
63 $mensaje=$_POST['mensaje'];
64
65 $consulta="INSERT INTO chat (nombre,mensaje) values('$nombre','$mensaje')";
66 $ejecutar=$cn->query($consulta);
67 if ($ejecutar) {
68 echo "<embed loop='false' src='audio/tono.mp3' hidden='true' autoplay='true'";
69 }
70 }
71
72 ?>
73 </div>
74
75</body>
76</html>
77
78<?php
79
80$cn= mysqli_connect("localhost","root","","appchat");
81
82function formatearfecha($fecha){
83 return date('g:i a',strtotime($fecha));
84}
85
86
87 ?>
88
89<?php
90include"conexion.php";
91
92 $consulta="SELECT * FROM chat order by id ";
93 $ejecutar=$cn->query($consulta);
94 while($fila=$ejecutar->fetch_array()):
95 ?>
96 <div id="datos-chat">
97 <span style="color: #1c62c4"><?php echo $fila['nombre'] ; ?> : </span>
98 <span style="color: #848484"><?php echo $fila['mensaje']; ?></span>
99 <span style="float: right;"><?php echo formatearfecha ($fila['fecha']); ?></span>
100 </div>
101<?php endwhile; ?>
102
103- phpMyAdmin SQL Dump
104-- version 4.4.12
105-- http://www.phpmyadmin.net
106--
107-- Servidor: 127.0.0.1
108-- Tiempo de generación: 12-03-2018 a las 18:31:40
109-- Versión del servidor: 5.6.25
110-- Versión de PHP: 5.5.27
111
112SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
113SET time_zone = "+00:00";
114
115
116/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
117/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
118/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
119/*!40101 SET NAMES utf8mb4 */;
120
121--
122-- Base de datos: `appchat`
123--
124
125-- --------------------------------------------------------
126
127--
128-- Estructura de tabla para la tabla `chat`
129--
130
131CREATE TABLE IF NOT EXISTS `chat` (
132 `id` int(11) NOT NULL,
133 `nombre` varchar(100) COLLATE utf8mb4_spanish_ci NOT NULL,
134 `mensaje` varchar(250) COLLATE utf8mb4_spanish_ci NOT NULL,
135 `fecha` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
136) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_spanish_ci;
137
138--
139-- Volcado de datos para la tabla `chat`
140--
141
142INSERT INTO `chat` (`id`, `nombre`, `mensaje`, `fecha`) VALUES
143(84, '', '', '2018-03-12 17:26:33'),
144(85, '', '', '2018-03-12 17:26:34'),
145(86, '', '', '2018-03-12 17:27:19'),
146(87, '', '', '2018-03-12 17:27:20'),
147(88, '', '', '2018-03-12 17:27:20'),
148(89, '', '', '2018-03-12 17:27:21'),
149(90, '', '', '2018-03-12 17:27:24'),
150(91, 'as', 'a', '2018-03-12 17:27:30'),
151(92, '', '', '2018-03-12 17:27:32'),
152(93, 'jhontana', 'asdasd', '2018-03-12 17:28:19'),
153(94, '', '', '2018-03-12 17:28:22'),
154(95, 'asdasd', 'asdasd', '2018-03-12 17:29:08'),
155(96, '', '', '2018-03-12 17:29:12'),
156(97, '', '', '2018-03-12 17:29:19'),
157(98, 'asdasdasdasda', 'asdasdasd', '2018-03-12 17:29:22'),
158(99, '', '', '2018-03-12 17:29:25'),
159(100, 'jhonatan', 'hola a todos', '2018-03-12 17:29:37'),
160(101, '', '', '2018-03-12 17:29:44');
161
162--
163-- Ãndices para tablas volcadas
164--
165
166--
167-- Indices de la tabla `chat`
168--
169ALTER TABLE `chat`
170 ADD PRIMARY KEY (`id`);
171
172--
173-- AUTO_INCREMENT de las tablas volcadas
174--
175
176--
177-- AUTO_INCREMENT de la tabla `chat`
178--
179ALTER TABLE `chat`
180 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=102;
181/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
182/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
183/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;