Autorius Tema: If'ai (Skaityti 271 kartai)

gRfd · « : 2011-03-24 18:22:52 »

Sveiki, gal atsirastu koks geras zmogus, kuris galetu sudeti if'us i scripta?

KNx · « **Atsakyti #1 :** 2011-03-24 18:53:36 »

Sveikas,
Čia daug gerų žmonių, tačiau tu parodyk scriptą ir surašyk ko tau reikia, manau atsiras tikrai kas padės

vitalikaz · « **Atsakyti #2 :** 2011-03-24 19:20:50 »

Tema verta milijono

gRfd · « **Atsakyti #3 :** 2011-03-24 22:15:30 »

<?php

require "conf.php";

// Paima IP Adresa, pakeicia i skaicius, ir talpina i duomenu baze

$ip   = sprintf('%u',ip2long($_SERVER['REMOTE_ADDR']));

// Uzklausa

$result = $mysqli->query("
   SELECT s.*, if (v.ip IS NULL,0,1) AS have_voted
   FROM suggestions AS s
   LEFT JOIN suggestions_votes AS v
   ON(
      s.id = v.suggestion_id
      AND v.day = CURRENT_DATE
      AND v.ip = $ip
   )
   ORDER BY s.rating DESC, s.id DESC
");

$str = '';

if(!$mysqli->error)
{
   // Generuoja URL Adresa

   $str = '<ul class="suggestions">';


   while($suggestion = $result->fetch_object('Suggestion')){

      $str.= $suggestion;

   }

   $str .='</ul>';
}
?>

<!DOCTYPE html>
<html>
<head>
<meta http-equiv=Content-Type content=text/html; charset=utf-8>
<title>Kokio Serverio Norite?</title>

<link rel="stylesheet" type="text/css" href="styles.css" />

</head>

<body>

<div id="page">

<div id="heading" class="rounded">
   <h1>Kokio Serverio Norite?Balsuokite, rašykite.</h1>
</div>

   <?php
      echo $str;
   ?>

<form id="suggest" action="" method="post">
<p>
<input type="text" id="suggestionText" class="rounded" maxlength="25" />
<input type="submit" value="Submit" id="submitSuggestion" />
</p>
   </form>

</div>

<center>


<?php
require "banneriai.php";
?>



<?php
require "skaitliukas.php";
?>


<script src="js.js"></script>
</body>
</html>

Man pirma reikia kad nekeistu IP adreso i skaicius, o talpintu normalu IP adresa i duombaze. Bandziau ip2long istrynt, bet nieko.

Poto parasysiu apie if'us.

html css photoshop php forumas · « **Atsakyti #3 :** 2011-03-24 22:15:30 »

ganjabest · « **Atsakyti #4 :** 2011-03-24 22:36:51 »

tai pakeisk

Kodas: [Pasirinkti]

<?php
$ip   = sprintf('%u',ip2long($_SERVER['REMOTE_ADDR']));

//I sita jei neklystu

$ip   = sprintf('%s', $_SERVER['REMOTE_ADDR']);

// O isvis gali sitaip 

$ip   = $_SERVER['REMOTE_ADDR'];
?>

gRfd · « **Atsakyti #5 :** 2011-03-24 22:38:23 »

Jau bandziau. Nieko..

gRfd · « **Atsakyti #6 :** 2011-03-24 22:42:33 »

Gal ir veiktu. Bet neleidzia rasyti naujo pranesimo. Gal del Duombazes uzklausos?

$mysqli->query("
      INSERT INTO suggestions_votes (suggestion_id,ip,day,vote)
      VALUES (
         $id,
         $ip,
         CURRENT_DATE,
         $v
      )
   ");

ganjabest · « **Atsakyti #7 :** 2011-03-24 22:59:26 »

Citata iš: gRfd on 2011-03-24 22:42:33

Gal ir veiktu. Bet neleidzia rasyti naujo pranesimo. Gal del Duombazes uzklausos?

$mysqli->query("
      INSERT INTO suggestions_votes (suggestion_id,ip,day,vote)
      VALUES (
         $id,
         $ip,
         CURRENT_DATE,
         $v
      )
   ");

tai ka raso kaip neleidzia

?

gRfd · « **Atsakyti #8 :** 2011-03-24 23:22:49 »

Neraso nieko, spaudi submit mygtuka ir nesiuncia.

Gal cia neatitinka?

SELECT s.*, if (v.ip IS NULL,0,1) AS have_voted
   FROM suggestions AS s
   LEFT JOIN suggestions_votes AS v
   ON(
      s.id = v.suggestion_id
      AND v.day = CURRENT_DATE
      AND v.ip = $ip
   )
   ORDER BY s.rating DESC, s.id DESC
");

ganjabest · « **Atsakyti #9 :** 2011-03-24 23:32:51 »

tai kad cia uzklausa ne iterpimo ..

gRfd · « **Atsakyti #10 :** 2011-03-24 23:35:55 »

Tai iterpimo jau parases. Auksciau

$mysqli->query("
INSERT INTO suggestions_votes (suggestion_id,ip,day,vote)
VALUES (
$id,
$ip,
CURRENT_DATE,
$v
)
");

gRfd · « **Atsakyti #11 :** 2011-03-27 17:52:33 »

Tai pades man kasnors?

Lukas Liesis · « **Atsakyti #12 :** 2011-03-27 19:42:29 »

Citata iš: gRfd on 2011-03-27 17:52:33

Tai pades man kasnors?

ant sql uzklausu uzde or die(mysql_error());

t.y.:

mysql_query('UZKLAUSA') or die(mysql_error());

gal isves klaidu kokiu apie sql

gRfd · « **Atsakyti #13 :** 2011-03-27 20:10:28 »

Dekui, pabandysiu

gRfd · « **Atsakyti #14 :** 2011-03-27 20:14:53 »

$result = $mysqli->query("
   SELECT s.*, if (v.ip IS NULL,0,1) AS have_voted
   FROM suggestions AS s
   LEFT JOIN suggestions_votes AS v
   ON(
      s.id = v.suggestion_id
      AND v.day = CURRENT_DATE
      AND v.ip = $ip or die(mysql_error());
   )
   ORDER BY s.rating DESC, s.id DESC
");

Gerai taip?

krekas · « **Atsakyti #15 :** 2011-03-27 20:30:20 »

Jei tu nori įterpti įrašą, tai ne SELECT turi naudot, o INSERT

gRfd · « **Atsakyti #16 :** 2011-03-27 20:53:15 »

Tai cia kaip pavizdy daviau.

Lukas Liesis · « **Atsakyti #17 :** 2011-03-27 22:04:34 »

kazkokia man neaiski sita tema, vadinas If'ai kalba apie SQL bedas ir nerodo savo kodo, o duoda kazkokius pavyzdzius. tai wtf cia vyksta?

ganjabest · « **Atsakyti #18 :** 2011-03-27 22:09:48 »

Citata iš: Lukas Liesis on 2011-03-27 22:04:34

kazkokia man neaiski sita tema, vadinas If'ai kalba apie SQL bedas ir nerodo savo kodo, o duoda kazkokius pavyzdzius. tai wtf cia vyksta?

Todel ir nebeatsakineju, nes nk nesuprantu

tema if'ai , pats pirmas postas praso del ip (atsakyta) , toliau jau neiraso pranesimo .

gRfd · « **Atsakyti #19 :** 2011-03-27 22:16:25 »

Is pradziu man reikejo ifu, o dabar reikia kad ip logintu, ir nepakeistu i skaicius.

<?php

require "config.php";

//Paima IP Adresa, pakeicia i skaicius, ir talpina i duomenu baze

$ip   = sprintf('%u',ip2long($_SERVER['REMOTE_ADDR']));

// Uzklausa

$result = $mysqli->query("
   SELECT s.*, if (v.ip IS NULL,0,1) AS have_voted
   FROM suggestions AS s
   LEFT JOIN suggestions_votes AS v
   ON(
      s.id = v.suggestion_id
      AND v.day = CURRENT_DATE
      AND v.ip = $ip
   )
   ORDER BY s.rating DESC, s.id DESC
");

$str = '';

if(!$mysqli->error)
{
   // Generuoja URL Adresa

   $str = '<ul class="suggestions">';


   while($suggestion = $result->fetch_object('Suggestion')){

      $str.= $suggestion;

   }

   $str .='</ul>';
}
?>

<!DOCTYPE html>
<html>
<head>
<meta http-equiv=Content-Type content=text/html; charset=utf-8>
<title>Kokio Serverio Norite?</title>

<link rel="stylesheet" type="text/css" href="styles.css" />

</head>

<body>

<div id="page">

<div id="heading" class="rounded">
   <h1>Kokio Serverio Norite?Balsuokite, rašykite.</h1>
</div>

   <?php
      echo $str;
   ?>

<form id="suggest" action="" method="post">
<p>
<input type="text" id="suggestionText" class="rounded" maxlength="25" />
<input type="submit" value="Submit" id="submitSuggestion" />
</p>
   </form>

</div>

<center>


<?php
require "moduliai/banneriai.php";
?>



<?php
require "moduliai/skaitliukas.php";
?>



<?php
require "moduliai/google_analytics.php";
?>


<script language="JavaScript">

var message="?";

///////////////////////////////////
function clickIE4(){
if (event.button==2){
alert(message);
return false;
}
}

function clickNS4(e){
if (document.layers||document.getElementById&&!document.all){
if (e.which==2||e.which==3){
alert(message);
return false;
}
}
}

if (document.layers){
document.captureEvents(Event.MOUSEDOWN);
document.onmousedown=clickNS4;
}
else if (document.all&&!document.getElementById){
document.onmousedown=clickIE4;
}

document.oncontextmenu=new Function("alert(message);return false")

</script>

<script src="Java.js"></script>
</body>
</html>

html css photoshop php forumas · « **Atsakyti #19 :** 2011-03-27 22:16:25 »

Naujienos:

Autorius Tema: If'ai (Skaityti 271 kartai)

html css photoshop php forumas

html css photoshop php forumas