B
blogers
Pi
SEO
no se debe cumplir la consulta sql... ponela en phpmyadmin antes a ver que te dice... yo te lo puse como tendria que ir... por ahi search no tiene esa columna...
<?php
$cone = new mysqli('localhost','root','', 'botsearch');
if ($cone->connect_errno)
{
echo "Fallo al conectar a MySQL: (" . $cone->connect_errno . ") " . $cone->connect_error;
}else{
$sql = $cone->mysqli_query("select keyword, count(1) cantidad from search group by keyword having count(1) > 1");
while($rows = $sql->fetch_assoc())
{
$cone->mysqli_query("insert into search2 values(0, '". $rows['keyword'] ."', ". $rows['cantidad'] .")");
}
}
?>
insert into search2 values(0, '". $rows['keyword'] ."', ". $rows['cantidad'] .")
<?php
$cone = new mysqli('localhost','root','', 'botsearch');
if ($cone->connect_errno)
{
echo "Fallo al conectar a MySQL: (" . $cone->connect_errno . ") " . $cone->connect_error;
}else{
$sql = $cone->mysqli_query("select keyword, count(1) cantidad from search group by keyword having count(1) > 1");
while($rows = $sql->fetch_assoc())
{
$cone->mysqli_query("insert into search2 values(0, '". $rows['keyword'] ."', ". $rows['keyword_counts'] .", ". $rows['location'] .", ". $rows['results_count'] .", ". $rows['hits_count'] .", ". $rows['country'] .", ". $rows['date'] .", ". $rows['session'] .")");
}
}
?>
el insert into no funcionara bien porque no cumple con la cantidad de campos...PHP:<?php $cone = new mysqli('localhost','root','', 'botsearch'); if ($cone->connect_errno) { echo "Fallo al conectar a MySQL: (" . $cone->connect_errno . ") " . $cone->connect_error; }else{ $sql = $cone->mysqli_query("select keyword, count(1) cantidad from search group by keyword having count(1) > 1"); while($rows = $sql->fetch_assoc()) { $cone->mysqli_query("insert into search2 values(0, '". $rows['keyword'] ."', ". $rows['cantidad'] .")"); } } ?>
Ves vos tenes mas campos...entonces tenes que editar elpara que cumpla con la cantidad de campos de search2... sino jamas insertara nadaPHP:insert into search2 values(0, '". $rows['keyword'] ."', ". $rows['cantidad'] .")
Ya lo puse asi
PHP:<?php $cone = new mysqli('localhost','root','', 'botsearch'); if ($cone->connect_errno) { echo "Fallo al conectar a MySQL: (" . $cone->connect_errno . ") " . $cone->connect_error; }else{ $sql = $cone->mysqli_query("select keyword, count(1) cantidad from search group by keyword having count(1) > 1"); while($rows = $sql->fetch_assoc()) { $cone->mysqli_query("insert into search2 values(0, '". $rows['keyword'] ."', ". $rows['keyword_counts'] .", ". $rows['location'] .", ". $rows['results_count'] .", ". $rows['hits_count'] .", ". $rows['country'] .", ". $rows['date'] .", ". $rows['session'] .")"); } } ?>
Pero sige ese error y no inserta nada
<?php
$cone = new mysqli('localhost','root','', 'botsearch');
if ($cone->connect_errno)
{
echo "Fallo al conectar a MySQL: (" . $cone->connect_errno . ") " . $cone->connect_error;
}else{
$sql = $cone->query("select keyword, count(1) cantidad from search group by keyword having count(1) > 1");
while($rows = $sql->fetch_assoc())
{
$cone->query("insert into search2 values(0, '". $rows['keyword'] ."', ". $rows['keyword_counts'] .", ". $rows['location'] .", ". $rows['results_count'] .", ". $rows['hits_count'] .", ". $rows['country'] .", ". $rows['date'] .", ". $rows['session'] .")");
}
}
?>
copie el code viejo... es query no mysqli_query
ASI
PHP:<?php $cone = new mysqli('localhost','root','', 'botsearch'); if ($cone->connect_errno) { echo "Fallo al conectar a MySQL: (" . $cone->connect_errno . ") " . $cone->connect_error; }else{ $sql = $cone->query("select keyword, count(1) cantidad from search group by keyword having count(1) > 1"); while($rows = $sql->fetch_assoc()) { $cone->query("insert into search2 values(0, '". $rows['keyword'] ."', ". $rows['keyword_counts'] .", ". $rows['location'] .", ". $rows['results_count'] .", ". $rows['hits_count'] .", ". $rows['country'] .", ". $rows['date'] .", ". $rows['session'] .")"); } } ?>
Pues nada no pasa nada jejejeje
<?php
$cone = new mysqli('localhost','root','', 'botsearch');
if ($cone->connect_errno)
{
echo "Fallo al conectar a MySQL: (" . $cone->connect_errno . ") " . $cone->connect_error;
}else{
$sql = $cone->query("select keyword, count(1) cantidad from search group by keyword having count(1) > 1");
while($rows = $sql->fetch_assoc())
{
$cone->query("insert into search2 values(0, '". $rows['keyword'] ."', ". $rows['keyword_counts'] .", ". $rows['location'] .", ". $rows['results_count'] .", ". $rows['hits_count'] .", ". $rows['country'] .", ". $rows['date'] .", ". $rows['session'] .")");
echo "insert into search2 values(0, '". $rows['keyword'] ."', ". $rows['keyword_counts'] .", ". $rows['location'] .", ". $rows['results_count'] .", ". $rows['hits_count'] .", ". $rows['country'] .", ". $rows['date'] .", ". $rows['session'] .")<br/>";
}
}
?>
<?php
$cone = new mysqli('localhost','root','', 'botsearch');
if ($cone->connect_errno)
{
echo "Fallo al conectar a MySQL: (" . $cone->connect_errno . ") " . $cone->connect_error;
}else{
$sql = $cone->query("select keyword, count(1) from search group by keyword having count(1) > 1");
while($rows = $sql->fetch_assoc())
{
$cone->query("insert into search2 values(0, '". $rows['keyword'] ."', ". $rows['keyword_counts'] .", ". $rows['location'] .", ". $rows['results_count'] .", ". $rows['hits_count'] .", ". $rows['country'] .", ". $rows['date'] .", ". $rows['session'] .")");
echo "insert into search2 values(0, '". $rows['keyword'] ."', ". $rows['keyword_counts'] .", ". $rows['location'] .", ". $rows['results_count'] .", ". $rows['hits_count'] .", ". $rows['country'] .", ". $rows['date'] .", ". $rows['session'] .")<br/>";
}
}
?>
y cantidad para que lo necesitas sino lo vas a usar... vos querias guardar la cantidad de veces que se repite...ahi en ves de usar hits_count tienes que meterle cantidad... pero igual ve si esta entrando al while asi:
Si entro copia esa consulta y metela en el phpmyadmin a ver si no le has errado en algo... es todo prueba y error...PHP:<?php $cone = new mysqli('localhost','root','', 'botsearch'); if ($cone->connect_errno) { echo "Fallo al conectar a MySQL: (" . $cone->connect_errno . ") " . $cone->connect_error; }else{ $sql = $cone->query("select keyword, count(1) cantidad from search group by keyword having count(1) > 1"); while($rows = $sql->fetch_assoc()) { $cone->query("insert into search2 values(0, '". $rows['keyword'] ."', ". $rows['keyword_counts'] .", ". $rows['location'] .", ". $rows['results_count'] .", ". $rows['hits_count'] .", ". $rows['country'] .", ". $rows['date'] .", ". $rows['session'] .")"); echo "insert into search2 values(0, '". $rows['keyword'] ."', ". $rows['keyword_counts'] .", ". $rows['location'] .", ". $rows['results_count'] .", ". $rows['hits_count'] .", ". $rows['country'] .", ". $rows['date'] .", ". $rows['session'] .")<br/>"; } } ?>
...
:s
$cone->query("insert into search2 values('', '". $rows['keyword'] ."', ". $rows['keyword_counts'] .", ". $rows['location'] .", ". $rows['results_count'] .", ". $rows['cantidad'] .", ". $rows['country'] .", ". $rows['date'] .", ". $rows['session'] .")");
<?php
$cone = new mysqli('localhost','root','', 'botsearch');
if ($cone->connect_errno)
{
echo "Fallo al conectar a MySQL: (" . $cone->connect_errno . ") " . $cone->connect_error;
}else{
$sql = $cone->query("select keyword, count(1) from search group by keyword having count(1) > 1");
while($rows = $sql->fetch_assoc())
{
$cone->query("insert into search2 values('', '". $rows['keyword'] ."', ". $rows['keyword_counts'] .", ". $rows['location'] .", ". $rows['results_count'] .", ". $rows['cantidad'] .", ". $rows['country'] .", ". $rows['date'] .", ". $rows['session'] .")");
echo "insert into search2 values('', '". $rows['keyword'] ."', ". $rows['keyword_counts'] .", ". $rows['location'] .", ". $rows['results_count'] .", ". $rows['hits_count'] .", ". $rows['country'] .", ". $rows['date'] .", ". $rows['session'] .")<br/>";
}
}
?>
si mienstras estaba en el baño me di cuenta del error... vos tenes como ID autoincrement... y le estas pasando 0 siempre... tiene que ser ''
PHP:$cone->query("insert into search2 values('', '". $rows['keyword'] ."', ". $rows['keyword_counts'] .", ". $rows['location'] .", ". $rows['results_count'] .", ". $rows['cantidad'] .", ". $rows['country'] .", ". $rows['date'] .", ". $rows['session'] .")");
Y te dije que copies esa consulta que te mostro en pantalla y la metas en el phpmyadmin... asi te abrias dado cuenta del error...
Tsss no quiere no quiere ya puse asi el code...
insert into search2 values('', 'Restaurant jobs All sites Full time All types Internship Employer sites Job site', , , , , , , )
lo que te muestra en pantalla metelo en el phpmyadmin -.-' eso lo entendes?... lo vengo diciendo hace 3 post atras... XD
1- ejecutas el php
2- en pantalla apareceran las consultas de insert
3- copias una de ellas y la metes en el phpmyadmin
4- ves el error que te da y lo arreglas...
Mira esto me arrojo
PHP:insert into search2 values('', 'Restaurant jobs All sites Full time All types Internship Employer sites Job site', , , , , , , )
<?php
$cone = new mysqli('localhost','root','', 'botsearch');
if ($cone->connect_errno)
{
echo "Fallo al conectar a MySQL: (" . $cone->connect_errno . ") " . $cone->connect_error;
}else{
$sql = $cone->query("select *, count(1) from search group by keyword having count(1) > 1");
while($rows = $sql->fetch_assoc())
{
$cone->query("insert into search2 values('', '". $rows['keyword'] ."', ". $rows['keyword_counts'] .", ". $rows['location'] .", ". $rows['results_count'] .", ". $rows['cantidad'] .", ". $rows['country'] .", ". $rows['date'] .", ". $rows['session'] .")");
echo "insert into search2 values('', '". $rows['keyword'] ."', ". $rows['keyword_counts'] .", ". $rows['location'] .", ". $rows['results_count'] .", ". $rows['hits_count'] .", ". $rows['country'] .", ". $rows['date'] .", ". $rows['session'] .")<br/>";
}
}
?>
ahi tenes tu error XD... no tenes los demas campos... en el select solo seleccionas keyword... no los demas... por eso no existen... usa select *,...... en ves de select keyword,......
Ya imprimio lo valores correspondientes
". $rows['location'] .",
en la imagen tenes tu error...
Es la tercera creoPHP:". $rows['location'] .",
Tengo que borrar el campo =?
<?php
$cone = new mysqli('localhost','root','', 'botsearch');
if ($cone->connect_errno)
{
echo "Fallo al conectar a MySQL: (" . $cone->connect_errno . ") " . $cone->connect_error;
}else{
$sql = $cone->query("select *, count(1) from search group by keyword having count(1) > 1");
while($rows = $sql->fetch_assoc())
{
$cone->query("insert into search2 values('', '". $rows['keyword'] ."', ". $rows['keyword_counts'] .", '". $rows['location'] ."', ". $rows['results_count'] .", ". $rows['cantidad'] .", '". $rows['country'] ."', ". $rows['date'] .", '". $rows['session'] ."')");
echo "insert into search2 values('', '". $rows['keyword'] ."', ". $rows['keyword_counts'] .", '". $rows['location'] ."', ". $rows['results_count'] .", ". $rows['cantidad'] .", '". $rows['country'] ."', ". $rows['date'] .", '". $rows['session'] ."')<br/>";
}
}
?>
Ultima...
PHP:<?php $cone = new mysqli('localhost','root','', 'botsearch'); if ($cone->connect_errno) { echo "Fallo al conectar a MySQL: (" . $cone->connect_errno . ") " . $cone->connect_error; }else{ $sql = $cone->query("select *, count(1) from search group by keyword having count(1) > 1"); while($rows = $sql->fetch_assoc()) { $cone->query("insert into search2 values('', '". $rows['keyword'] ."', ". $rows['keyword_counts'] .", '". $rows['location'] ."', ". $rows['results_count'] .", ". $rows['cantidad'] .", '". $rows['country'] ."', ". $rows['date'] .", '". $rows['session'] ."')"); echo "insert into search2 values('', '". $rows['keyword'] ."', ". $rows['keyword_counts'] .", '". $rows['location'] ."', ". $rows['results_count'] .", ". $rows['cantidad'] .", '". $rows['country'] ."', ". $rows['date'] .", '". $rows['session'] ."')<br/>"; } } ?>
si location esta vacio en search...pues no pasara a search2 porque al ponerlos sin las comillas no pasas nada... lo mismo si algun otro valor... por eso ahora le puse las ' en los campos de textos...
tsss que asi de dificilon es php cuando uno se inicia jejeje
vos ves a cantidad aca?
select *, count(1) from search group by keyword having count(1) > 1
XD... en algun momento la eliminaste... 😛
Toing ya me perdi ya puse todo al pie de la letra ya le puse comillas a todos los campos tambien, por ejemplo la tabla de search cada sabado voy enviar una nueva tabla que empezara de cero recolectando pero esos duplicados si existen tenfdran que sumar en hits_count pero si no existen se tendran que insertar por eso te digo ya me perdi con lo que me comentas
Utilizamos cookies y tecnologías similares para los siguientes fines:
¿Aceptas las cookies y estas tecnologías?
Utilizamos cookies y tecnologías similares para los siguientes fines:
¿Aceptas las cookies y estas tecnologías?