Jump to content
php.lv forumi

Val

Reģistrētie lietotāji
  • Posts

    1,115
  • Joined

Posts posted by Val

  1. Lai pašam būtu vienkāršāk, tad bildes liec visas vienā mapē ar unikāliem failu nosaukumiem. Galerijas nosaukumus pieglabā datubāzē, tāpat arī faila (attēla) nosaukumu, galerijas id utt.

  2. echo mysql_error() pēc kverija un izlasi, kas pa vainu. Es liktu uz to, ka jāpieraksta trūkstošie tabulu nosaukumi pirms id, members_blablbla, mgroup, avatar_location utt. Mysql nav kristāla lode, kura parāda no kuras tabulas konkrētos kolonnu nosaukumus vēlies izvilkt, salīdzināt.

  3. iz php manuāļa komentāriem.

    Note the manual entry for PHP_SELF states the following:

     

    "The filename of the currently executing script, relative to the document root. For instance, $_SERVER['PHP_SELF'] in a script at the address http://example.com/test.php/foo.bar would be /test.php/foo.bar."

     

    However I did some vigorous testing on three different machines and this note is not always true. The results are given below:

     

    Given a URL of http://www.example.com/Info.php/Page/Home

     

    Apache 2.2.4/Win32/PHP 5.2.2/Apache 2.0 Handler

    ----> PHP_SELF = Info.php/Page/Home

     

    Apache 1.3.37/Unix/PHP 5.2.2/CGI

    ----> PHP_SELF = Info.php

     

    Apache 1.3.33/Unix/5.1.4/FastCGI

    ----> PHP_SELF = Info.php

  4. Ta liecies mierā un ļauj cilvēkam pašam izvēlēties paroles saturu. Tāpat tu datubāzē glabāsi ne jau paroli plaintekstā, bet kko hashsumveidīgu ar ierobežotu max garumu. Ja lietotājs var atcerēties 200 simbolu garu paroli ar nez kādiem ķinķēziņiem, tad p.viņuzirgs, lai izmanto :>

  5. SELECT epasts FROM lietotaji WHERE epasts='$epasts' and lietotajs<>'$liet'

    Man domāt, ka lietotāju no pārbaudes var ņemt arī ārā un pārbaudīt, vai konkrētais epasts ir unikāls visā tabulā bez lietotāja filtra. Pat ja jaunais epasts ir tāds pat kā esošais lietotāja epasts, tad nekādu update nafig nevajag, jo dati tāpat nemainās.

  6. Daļēji šis viss izskaidro kāpēc iesācēji dažreiz slinko un negrib apgūt pašus pamatus, ne reti php.lv forumos pieredzējuši programmētāji brauc virsū iesācējiem kad tie slinko un paši nemeklē literatūrā atbildes. Bet priekš kam meklēt?

    Jo otrā veida cilvēkiem, viņuprāt, ir paredzēti pirmie, kas sameklēs/uzrakstīs info viņu vietā un iebērs visu ar karotīti dir... tfu, mutē.

  7. kautkā tā. nākamreiz izlasi, ko tev mēģina paskaidrot, nevis krāmē pēdiņas pa labi un pa kreisi.

    echo $q = sprintf("INSERT INTO `users` (%s) VALUES ('%s')", implode(', ', array_map('mysql_escape_string', array_keys($SQL))), implode("', '",array_map('mysql_escape_string', $SQL)));

  8. vēl viens SEO title veids

    function seo_string($string, $len = 10, $seperator = '-') {
    $string = str_replace(array("ş", "Ş", "Ţ", "ţ", "ă", "î", "â"), array("s", "s", "t", "t", "a", "i", "a"), $string);  //RO translit
    $string = str_replace(array("ā","č", "ē", "ģ", "ķ", "ļ", "ī", "ū", "š", "ņ", "ž"), array("a", "c", "e", "g", "k", "l", "i", "u", "s", "n", "z"), $string); //LV translit
    $string = str_replace(array("Ā","Č", "Ē", "Ģ", "Ķ", "Ļ", "Ī", "Ū", "Š", "Ņ", "Ž"), array("A", "C", "E", "G", "K", "L", "I", "U", "S", "N", "Z"), $string); //LV translit CAPS LOCK
    $string = str_replace(array("Ё","Ж","Ч","Ш","Щ","Э","Ю","Я","ё","ж","ч","ш","щ","э","ю","я","А","Б","В","Г","Д","Е","З","И","Й","К","Л","М","Н","О","П","Р","С","Т","У","Ф","Х","Ц","Ы","а","б","в","г","д","е","з","и","й","к","л","м","н","о","п","р","с","т","у","ф","х","ц","ь","ы"),array("JO","ZH","CH","SH","SCH","JE","JY","JA","jo","zh","ch","sh","sch","je","jy","ja","A","B","V","G","D","E","Z","I","J","K","L","M","N","O","P","R","S","T","U","F","H","C","Y","a","b","v","g","d","e","z","i","j","k","l","m","n","o","p","r","s","t","u","f","h","c","'","y"), $string); //RU translit
    $string = strtolower($string);
    $string = trim($string);
    $string = trim(@ereg_replace("[^ A-Za-z0-9_]", " ", $string));
    #$string = ereg_replace("[ tnr]+", "-", $string);
    $string = str_replace(" ", $seperator, $string);
    $string = @ereg_replace("[ -]+", "-", $string);
    
    $t = explode($seperator, $string);
    if(count($t)>$len) {
    	$out = array_slice($t, 0, $len);
    	$string = implode($seperator, $out);
    };
    return $string;
    };
    

×
×
  • Create New...