cucumber

Ka var panakt URL parveidi www.staits.lv/manalapa.php --> www.staits.lv/manalapa it ka interneta atradu snipetu, bet vinsh neiet Options +FollowSymlinks RewriteEngine on RewriteRule ^(.*)\.htm$ $1.php [nc] ieksh htconfig'a esmu iesledzis mod_rewirte un modelis ari tads ir Varbut ko vel neesmu piekonfigurejis?

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 (:

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?

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