Jump to content


Photo

Ajuda Busca


  • Faça o login para participar
4 replies to this topic

#1 Henriquewow

Henriquewow

    Novato no fórum

  • Usuários
  • 24 posts
  • Sexo:Masculino
  • Localidade:Minas Gerais

Posted 07/08/2012, 14:31

alguem me da uma ajuda


esse e o erro

Warning: mysql_query() [function.mysql-query]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/setorcriat/public_html/test/buscar_db.php on line 43

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/setorcriat/public_html/test/buscar_db.php on line 43
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)


esse e meu codigo

<table cellspacing="0" cellspacing="0" border="1" width="500">
<tr>
<td>ID</td>
<td>Nome</td>
<td>Dia</td>
<td>Mes</td>
<td>Ano</td>
<td>Email</td>
<td>Email ALternativo</td>
</tr>
<?php
session_start();

include "functions.php";

$sqlcon = "SELECT * FROM empresas";
if($_GET['buscar'] == 'buscar'){
//buscar todos
if($_GET['buscaNome'] == " " AND $_GET['buscaEmail'] == " " AND $_GET['buscames'] == " " AND $_GET['buscaano'] == " ") {
$sqlcon = "SELECT * FROM empresas";
}
//buscar nome
else if ($_GET['buscaNome'] != " " AND $_GET['buscaEsmail'] == " " AND $_GET['buscames'] == " " AND $_GET['buscaano'] == " ") {
$sqlcon = "SELECT * FROM empresas WHERE nome LINK '%".$_GET['buscaNome']."%' ";
}
//buscar email's
else if ($_GET['buscaNome'] == " " AND $_GET['buscaEsmail'] != " " AND $_GET['buscames'] == " " AND $_GET['buscaano'] == " ") {
$sqlcon = "SELECT * FROM empresas WHERE email LINK '%".$_GET['buscaEmail']."%' AND email2 LINK '%".$_GET['buscaEmail']."%' ";
}
//buscar todos por mes
else if ($_GET['buscaNome'] == " " AND $_GET['buscaEsmail'] == " " AND $_GET['buscames'] != " " AND $_GET['buscaano'] == " ") {
$sqlcon = "SELECT * FROM empresas WHERE mes LINK '%".$_GET['buscames']."%' ";
}
//buscar por ano
else if ($_GET['buscaNome'] == " " AND $_GET['buscaEsmail'] == " " AND $_GET['buscames'] == " " AND $_GET['buscaano'] != " ") {
$sqlcon = "SELECT * FROM empresas WHERE ano LINK '%".$_GET['buscaano']."%' ";
}
//buscar por mes e ano
else if ($_GET['buscaNome'] == " " AND $_GET['buscaEsmail'] == " " AND $_GET['buscames'] != " " AND $_GET['buscaano'] != " ") {
$sqlcon = "SELECT * FROM empresas WHERE mes LINK '%".$_GET['buscames']."%' AND ano LINK '%".$_GET['buscaano']."%'";
}
}
<font color=red>$resultado_001 = mysql_query($sqlcon) or die(mysql_error());</font> Linha 43
while ($rowcon = mysql_fetch_array($resultado_001)){
?>
<tr>
<td><? echo $rowcon['id'];?> </td>
<td><? echo $rowcon['nome'];?> </td>
<td><? echo $rowcon['dia'];?> </td>
<td><? echo $rowcon['mes'];?> </td>
<td><? echo $rowcon['ano'];?> </td>
<td><? echo $rowcon['email'];?> </td>
<td><? echo $rowcon['email2'];?> </td>
</tr>
<? } ?>
</table>


galera ajuda ae com dicas um outro modo falando oque fiz de errado
porque sinceramente nao estou vendo nda errado ae

Edição feita por: Henriquewow, 07/08/2012, 08:40.


#2 silici0

silici0

    ?

  • Usuários
  • 902 posts
  • Sexo:Masculino
  • Localidade:São Paulo - SP
  • Interesses:PHP, MySQL, XHTML, CSS, AJAX, JavaScript, Objective-C, Python, Games ... #geek

Posted 07/08/2012, 17:17

Seu problema é que o script não consegue conectar na base de dados usando o socket '/var/lib/mysql/mysql.sock'

Tem que ver se existe o file, link, caso não precisa criar ... :)

Abraços
Procurando freelancer
***********************************************
Bachelor of Technology in Technology of Information, with great knowledge in Windows operating systems and Unix-Like (BSD, Ubuntu and Slackware), languages (PHP, JavaScript and MySQL), semantic (DHTML, Tableless, Ajax, MVC, OO) and analysis (manages projects based on PMI).
Developer in PHP, JAVA, Python, Objective-c MySQL, DHTML, CSS, JAVASCRIPT, JQUERY, JSON, SMARTY, MDB2, DOCTRINE, CAKEPHP. Linux desktop for work and MacOS. E-commerces, CRM and bussiness strategys
Love-me and be FREE use UniCes-Like .

#3 Henriquewow

Henriquewow

    Novato no fórum

  • Usuários
  • 24 posts
  • Sexo:Masculino
  • Localidade:Minas Gerais

Posted 08/08/2012, 08:47

muito obrigado amigo incluir no meu codigo

include "config.php";


refiz o codigo varias vezes e nao percebi isso.
muito obrigado agora estar buscando

#4 silici0

silici0

    ?

  • Usuários
  • 902 posts
  • Sexo:Masculino
  • Localidade:São Paulo - SP
  • Interesses:PHP, MySQL, XHTML, CSS, AJAX, JavaScript, Objective-C, Python, Games ... #geek

Posted 08/08/2012, 11:49

Resolvido ?

Abraços
Procurando freelancer
***********************************************
Bachelor of Technology in Technology of Information, with great knowledge in Windows operating systems and Unix-Like (BSD, Ubuntu and Slackware), languages (PHP, JavaScript and MySQL), semantic (DHTML, Tableless, Ajax, MVC, OO) and analysis (manages projects based on PMI).
Developer in PHP, JAVA, Python, Objective-c MySQL, DHTML, CSS, JAVASCRIPT, JQUERY, JSON, SMARTY, MDB2, DOCTRINE, CAKEPHP. Linux desktop for work and MacOS. E-commerces, CRM and bussiness strategys
Love-me and be FREE use UniCes-Like .

#5 Henriquewow

Henriquewow

    Novato no fórum

  • Usuários
  • 24 posts
  • Sexo:Masculino
  • Localidade:Minas Gerais

Posted 08/08/2012, 14:23

sim sim, so nao estou entendo o porque de esta passando no meu if direto




1 user(s) are reading this topic

0 membro(s), 1 visitante(s) e 0 membros anônimo(s)

IPB Skin By Virteq