Jump to content
php.lv forumi

sorehead

Reģistrētie lietotāji
  • Posts

    33
  • Joined

  • Last visited

Posts posted by sorehead

  1. sveiki, taads neliels jautaajums CSS ekspertiem. Nepieciesams izveidot lapu, kuras konteinera DIV buutu 100% gan plats, gan augsts.

     

     

    HTML ir saliidzinosi vienkarss:

     

    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN"
    "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="lv">
    <head>
    <title>Title</title>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    </head>
    <body>
    <div id="#container">
      
    </div>
    </body>
    </html>

     

    Kaadaa veidaa man aprakstiit DIV konteinera informaaciju CSS liidzekliem, lai tas butu 100% izpleeties pa lapu?

     

    Meeginaaju kaut kaa sitaa, bet nepaliidz:

     

    /*------------------------------CSS-------------------------------------------*/
    html, body
    {
    height:100%;
    margin:0px;
    padding:0px;
    }
    
    /*------------------------------main container--------------------------------*/
    
    #container
    {
    width:100%;
    height:100%;
    }

     

    Any ideas?

  2. labi, karoche taa..

     

    <?

    $rs = mysql_query("SELECT id, text FROM tabula WHERE text like '%$veriba%'");

    $amount = mysql_num_rows($rs);

     

    // izveidojam masiivu

     

    $rd_array = array();

    while ($row = mysql_fetch_array($rs))

    {

    $rd_array[] = $row['id'].";".$row['text'];

    }

    mysql_free_result($rs);

     

    // izvadam uz random vienu

     

    echo $rd_array[rand (0, $amount-1) ];

     

    ?>

     

    vajadzeetu straadaat, kaut arii es netesteeju..

     

    p.s. nosaucu cilveeciigi visus mainiigos, liidz ar to, njem kopee visu skriptu un pec tam testee.

  3. ja vajag pirmo izvadiit, tad sita..

     

    <?

    $max = mysql_query("SELECT * FROM tabula WHERE text like '%$veriba%'");

    $cik_atrod = mysql_num_rows($max);

     

    $i=0;

    while ($atb = mysql_fetch_array($max) || $i < 1)

    {

    echo $atb['text']." id=".$atb['id']." !! <br>";

    $i++;

    }

    mysql_free_result($max);

    ?>

     

    straadaa?

  4. ir noveerots, ka mysql ir tiexme izpildiit vaicaajumu, lai cik tas liels un sarezgiits butu. parasti izbeidzas 30 sekundes php scriptam.

     

    meklee probleemas savos php failos. vai arii izkopee to *sarezgiito* SQL vaicaajumu un iepastee kaadaa no mysql clientiem un pasties vai taa kljuuda paraadaas. ja nee, tad :) tu jau pats saprati.

  5. es nezinu, kads ir OS kuraa tu veido, bet ja *N*X (unix,linux) veidigs, tad komanda ir sekojosa.

     

    fails, kura tu gribi rakstiit:

     

    chown www:useris fails.txt (vajag ROOT tiesiibas)

    chmod 660 fails.txt

  6. neliels buxfix :)

     

    mysql> SELECT DATE_FORMAT(datums,'%Y-%m-%d') as laix, count(*) as amount FROM laix group by laix;

    +------------+--------+

    | laix | amount |

    +------------+--------+

    | 2003-12-12 | 3 |

    | 2003-12-13 | 3 |

    | 2003-12-14 | 1 |

    | 2003-12-18 | 2 |

    +------------+--------+

    4 rows in set (0.01 sec)

  7. Protams var but ir cits risinajums, bet es dariitu sekojosi:

     

    TABULA:

    -------------------------------------------------

    mysql> desc laix;

    +--------+----------+------+-----+---------+-------+

    | Field | Type | Null | Key | Default | Extra |

    +--------+----------+------+-----+---------+-------+

    | datums | datetime | YES | | NULL | |

    +--------+----------+------+-----+---------+-------+

    1 row in set (0.09 sec)

     

    DATI:

    -------------------------------------------------

    mysql> select * from laix;

    +---------------------+

    | datums |

    +---------------------+

    | 2003-12-12 14:14:14 |

    | 2003-12-12 14:14:13 |

    | 2003-12-12 14:14:12 |

    | 2003-12-13 14:14:14 |

    | 2003-12-13 14:14:14 |

    | 2003-12-13 15:14:14 |

    | 2003-12-14 14:14:14 |

    | 2003-12-18 14:14:14 |

    | 2003-12-18 13:13:12 |

    +---------------------+

    9 rows in set (0.00 sec)

     

    VAICAJUMS:

    -------------------------------------------------

     

    mysql> SELECT DATE_FORMAT(datums,'%Y-%e-%d') as laix, count(*) as amount FROM laix group by laix;

    +------------+--------+

    | laix | amount |

    +------------+--------+

    | 2003-12-12 | 3 |

    | 2003-13-13 | 3 |

    | 2003-14-14 | 1 |

    | 2003-18-18 | 2 |

    +------------+--------+

    4 rows in set (0.01 sec)

×
×
  • Create New...