cucumber

i9 iphone clons

 

lets, it ka tadas pashas f-jas, ir kads saskaries varetu pastastit par + / -

1k>

kaut kada bridi, kaut kas nojuka ar encodingu, varbut pie datu glabashanas nebija set names utf-8 query un tapec saka glabat datus savadak.

rekur cik atri to viedokli sanaca izmainit (:

 

ps. proti daudziem shai foruma ir daudzu gadu pieredze attiecigaja joma, un kad kadam iesacejas pasaka ka pareizi darit, tad kas tur slikts?

Lai varetu veikt dazadus logus, manis pec, var f-ju vai vienkarshi masiva ierakstit pirms izsaukt vaicajumu.

tad metodi vajadzetu bik pielabot

 

  public function fakeQuery($qeury){
$this->qCnt[] = $qeury;
//make query
 }

diezvai ir sapratigi katru vaicajumu veidot ka jaunu objektu

 

labak klase nodefinet mainigo, kas skaita cik reizes query ir izpildits un, attieciga vieta izsaukt to metodi, kas atgriez sho attributu.

 

class cntTest{
private $qCnt;

 public function fakeQuery(){
$this->qCnt++;
//make query
 }

 public function getCnt(){
  return $this->qCnt;
 }

}


$x = new cntTest();
$x -> fakeQuery();
$x -> fakeQuery();
$x -> fakeQuery();
echo $x -> getCnt(); //3

1) ja ir divas tabulas izmanto join vai salidzinashanu

 

 

ps. esi kludijies ar sadalu

lielaka dala izmanto Cactus CMS ko igauni izstradaja + autobidders ~ 65000 + 5000 igaunu valuta

un topics tiek parverst par drazu (:

Vai ta nav labak uzlikt shita to encodingu? + varetu but, ka pashus failus ari jaglaba utf8 kodejuma + var apskatities, kada encondiga serveris datus suta atpakal

<?php
header('Content-Type: text/html; charset=utf-8');
?>

utf-8 padot, ka charsetu

while( lietotaju_skaits == i){
update set id = 'i'  where id ='old_id';
i++;
}

Ja url megina parveidot shadi it ka darbojas http://127.0.0.1/saits/111111111/22222222 -> http://127.0.0.1/saits/111111111?22222222,bet

obligats nosacijums ka jabut {PATH_INFO} un {QUERY_STRING}.

RewriteRule ^saits/(.*)/(.*)$ /saits/$1?$2 [R]

mb_substr vajag lietot, kad ar utf strada.

Ir htaccess'a shadas rindas (apache 2.2.9)

RewriteEngine on
RewriteRule ^saits/(.*)/(.*)$ /saits/%{PATH_INFO}?%{QUERY_STRING} [R]

 

Ievadot dabu http://127.0.0.1/saits/111111111/22222222 ---> http://127.0.0.1/saits//22222222

 

1) kapec %{PATH_INFO} un ? zime pazud?

2) ka atcelt redirectu noteiktai adresei http://127.0.0.1/saits/bezredirekta/*?

to: yuppio <Directory>...</Directory> ir jaraksta ieprieksheja vieta, vai varbut divi directory?

Ja pieprasijums tiek rakstits pa taisno http://127.0.0.1/cgi-bin/manaprogramma.exe, tad viss strada, ka var automatiski palaist sho programmu vai nav kas pie virtual server jaraksta?

Konfiguracijas failos, zem ScriptAlias /cgi-bin/ "C:/Program Files/Apache Software Foundation/Apache2.2/cgi-bin/" pieliku savu ScriptAlias /cgi/ "C:/Program Files/Apache Software Foundation/Apache2.2/cgi/". Tani cgi folderi stav fails ar paplashinajumu .cgi un kodu

 

\n"; print "
\n"; print "
Katalogs
\n"; print "
\n"; print substr($ENV{'PATH_INFO'},1); print "
\n"; print "
Prece
\n"; print "
"; print $ENV{'QUERY_STRING'}; print "
\n"; print "
\n"; print "\n"; print ""; 1;

 

AddHandler cgi-script .cgi .pl esmu uzlicis shadu ieksh IfModule mime_module.

Publiskaja direktorija stav tuksh index.html fails.

 

Atverot localhost, paradas balta lapa, kapec tas cgi scripts neizpildas?

Drupal, fusion?

ta var, bet gribejas iztikt ar mysql pusi.

Default engine as of MySQL 3.23 with great performance Viss skaidrs (:

SELECT * FROM tabula WHERE id IN (SELECT id FROM tabula ORDER BY id LIMIT 10) ORDER BY RND() LIMIT 4

 

Shitos variantus es jau meginaju un "kombineju" , bet neko pratigaku par #1235 - This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery' nebiju dabujis.

 

ps. Uztaisiju ta ka ar pirmo query uztaisas temp tabula un ar otro query 4 randuma no temp tabulas panem , cik labi ta ir darit?

Neverte gramatu pec vakiem!

Tur ari kada funkcionala dala pastav apaksha, gan jau ari kads admin panelis, kas to cenu padara lielaku.

Vai ir iespejams, ar mysql palidzibu no tabulas panemt 10 pedejos ierakstus un tad no tiem 10 panmetiem 4 random'a?

SELECT * FROM `table` ORDER BY `id` desc limit 10 // pedejie desmit
SELECT * FROM `table` ORDER BY RAND() limit 4 // randoms