Jump to content
php.lv forumi

RaaapuLis

Reģistrētie lietotāji
  • Posts

    51
  • Joined

  • Last visited

Posts posted by RaaapuLis

  1. kr4 vleos lai ir nevis Komentari, bet Komentari (skaits)

     

    Kā lai "komentāru_skaits" vietā dabūnu skaitli kas skaita komentārus noteiktā tabulā, kuram raksta_id = ". $raksta_id ."

     

    Konekcijā viss kārtībā konektējas klāt un viss notiek.

    Kods:

    <?php
    
    
    
    
    	$result=mysql_query("SELECT id, virsraksts, raksts, laiks FROM jaunumi ORDER BY laiks DESC LIMIT 4");
    
    	while($row = mysql_fetch_array($result, MYSQL_NUM))
    
    		{
    
    		echo "<h3 class='news_title'>$row[1] </h3><br /> $row[2]<br /><br><strong>Pievienots: </strong>".date("d", $row[3])."/".date("m", $row[3])."/".date("Y", $row[3])." | <a href='komentaari.php?raksta_id=$row[0]'><strong>Komentāri (komentāru_skaits)</strong></a> <br /><br><br /><br><br>";
    
    		}
    ?>

  2. kr4 man piem. ir gars komentārs, un kā lai es to komentāru samazinu nu teiksim līdz 30 pirmajiem simboliem un tad 3 daudz punktes

     

     

     

    Lai butu nevis

     

    asdskdhsajkdbagfasdl\msdkykvnhalmvdf

     

    Bet gan

     

    asdskdhsa...

  3. Tātad ir kods:

     

    quote {
    background: #ffffcc;
    border-bottom: 1px dashed grey;
    border-top: 1px dashed grey;
    color: red;
    display: block;
    font-size: 1em;
    margin-bottom: 1em;
    padding: 6px 12px;
    text-transform: lowercase;
    }
    
    quote p {padding: 3px 0;}

     

    Caur Operu rāda kā vajag, bet caur mozillu, vai msie nerada gandriz neko, izņemot Tekstu, ka izlabot?

  4. [Fri Jul 25 09:29:14 2008] [notice] Apache/2.2.4 (Win32) PHP/5.2.1 configured -- resuming normal operations
    [Fri Jul 25 09:29:14 2008] [notice] Server built: Jan  9 2007 23:17:20
    [Fri Jul 25 09:29:14 2008] [notice] Parent: Created child process 512
    [Fri Jul 25 09:29:14 2008] [notice] Child 512: Child process is running
    [Fri Jul 25 09:29:14 2008] [notice] Child 512: Acquired the start mutex.
    [Fri Jul 25 09:29:14 2008] [notice] Child 512: Starting 64 worker threads.
    [Fri Jul 25 09:29:14 2008] [notice] Child 512: Starting thread to listen on port 80.
    [Fri Jul 25 09:29:44 2008] [notice] Parent: Received shutdown signal -- Shutting down the server.
    [Fri Jul 25 09:29:44 2008] [notice] Child 512: Exit event signaled. Child process is ending.
    [Fri Jul 25 09:29:45 2008] [notice] Child 512: Released the start mutex
    [Fri Jul 25 09:29:46 2008] [notice] Child 512: Waiting for 64 worker threads to exit.
    [Fri Jul 25 09:29:46 2008] [notice] Child 512: All worker threads have exited.
    [Fri Jul 25 09:29:46 2008] [notice] Child 512: Child process is exiting
    [Fri Jul 25 09:29:46 2008] [notice] Parent: Child process exited successfully.
    [Fri Jul 25 09:29:57 2008] [notice] Apache/2.2.4 (Win32) PHP/5.2.1 configured -- resuming normal operations
    [Fri Jul 25 09:29:57 2008] [notice] Server built: Jan  9 2007 23:17:20
    [Fri Jul 25 09:29:57 2008] [notice] Parent: Created child process 492
    [Fri Jul 25 09:29:57 2008] [notice] Child 492: Child process is running
    [Fri Jul 25 09:29:57 2008] [notice] Child 492: Acquired the start mutex.
    [Fri Jul 25 09:29:57 2008] [notice] Child 492: Starting 64 worker threads.
    [Fri Jul 25 09:29:57 2008] [notice] Child 492: Starting thread to listen on port 80.
    [Fri Jul 25 09:30:31 2008] [notice] Parent: Received shutdown signal -- Shutting down the server.
    [Fri Jul 25 09:30:31 2008] [notice] Child 492: Exit event signaled. Child process is ending.
    [Fri Jul 25 09:30:32 2008] [notice] Child 492: Released the start mutex
    [Fri Jul 25 09:30:33 2008] [notice] Child 492: Waiting for 64 worker threads to exit.
    [Fri Jul 25 09:30:33 2008] [notice] Child 492: All worker threads have exited.
    [Fri Jul 25 09:30:33 2008] [notice] Child 492: Child process is exiting
    [Fri Jul 25 09:30:33 2008] [notice] Parent: Child process exited successfully.
    [Fri Jul 25 09:35:42 2008] [notice] Apache/2.2.4 (Win32) PHP/5.2.1 configured -- resuming normal operations
    [Fri Jul 25 09:35:42 2008] [notice] Server built: Jan  9 2007 23:17:20
    [Fri Jul 25 09:35:42 2008] [notice] Parent: Created child process 2248
    [Fri Jul 25 09:35:42 2008] [notice] Child 2248: Child process is running
    [Fri Jul 25 09:35:42 2008] [notice] Child 2248: Acquired the start mutex.
    [Fri Jul 25 09:35:42 2008] [notice] Child 2248: Starting 64 worker threads.
    [Fri Jul 25 09:35:42 2008] [notice] Child 2248: Starting thread to listen on port 80.
    [Fri Jul 25 09:35:45 2008] [notice] Parent: Received shutdown signal -- Shutting down the server.
    [Fri Jul 25 09:35:45 2008] [notice] Child 2248: Exit event signaled. Child process is ending.
    [Fri Jul 25 09:35:46 2008] [notice] Child 2248: Released the start mutex
    [Fri Jul 25 09:35:47 2008] [notice] Child 2248: Waiting for 64 worker threads to exit.
    [Fri Jul 25 09:35:47 2008] [notice] Child 2248: All worker threads have exited.
    [Fri Jul 25 09:35:47 2008] [notice] Child 2248: Child process is exiting
    [Fri Jul 25 09:35:47 2008] [notice] Parent: Child process exited successfully.
    [Fri Jul 25 09:35:51 2008] [notice] Apache/2.2.4 (Win32) PHP/5.2.1 configured -- resuming normal operations
    [Fri Jul 25 09:35:51 2008] [notice] Server built: Jan  9 2007 23:17:20
    [Fri Jul 25 09:35:51 2008] [notice] Parent: Created child process 2076
    [Fri Jul 25 09:35:51 2008] [notice] Child 2076: Child process is running
    [Fri Jul 25 09:35:51 2008] [notice] Child 2076: Acquired the start mutex.
    [Fri Jul 25 09:35:51 2008] [notice] Child 2076: Starting 64 worker threads.
    [Fri Jul 25 09:35:51 2008] [notice] Child 2076: Starting thread to listen on port 80.
    [Fri Jul 25 09:35:56 2008] [notice] Parent: Received shutdown signal -- Shutting down the server.
    [Fri Jul 25 09:35:56 2008] [notice] Child 2076: Exit event signaled. Child process is ending.
    [Fri Jul 25 09:35:57 2008] [notice] Child 2076: Released the start mutex
    [Fri Jul 25 09:35:58 2008] [notice] Child 2076: Waiting for 64 worker threads to exit.
    [Fri Jul 25 09:35:58 2008] [notice] Child 2076: All worker threads have exited.
    [Fri Jul 25 09:35:58 2008] [notice] Child 2076: Child process is exiting
    [Fri Jul 25 09:35:58 2008] [notice] Parent: Child process exited successfully.

  5. erroru logs:

     

    [Thu Jul 24 23:34:10 2008] [alert] [client 127.0.0.1] C:/AppServ/www/.htaccess: Invalid command 'RewriteEngine', perhaps misspelled or defined by a module not included in the server configuration

     

    .htaccess

     

    RewriteEngine On
    RewriteRule ^lv?(.*)$ lv.php [L]

  6. Internal Server Error
    
    The server encountered an internal error or misconfiguration and was unable to complete your request.
    
    Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error.
    
    More information about this error may be available in the server error log.
    Apache/2.2.4 (Win32) PHP/5.2.1 Server at localhost Port 80

     

    kas tas ir par erroru, un kā viņu atrisināt?

    Man ir Win Vista

     

    p.s. errors parādās tiak cms`iem vai lietām, kurās ir .htaccess faili. Ja fails tukš iet, kā ierkasta RewriteEngine On/Off neiet

  7. Sveiki ! Es gribēju uzzināt kā var pie member tool pievienot search.

    Man ir

    Logged in as: RaaapuLis ( Log Out )																	 My Controls · View New Posts · My Assistant · My Friends · 0 New Messages

     

     

    Bet man vajag

    Logged in as: RaaapuLis ( Log Out )																	 My Controls · View New Posts · My Assistant · My Friends · 0 New Messages · Search · Members

     

     

    Zinu linku uz searchu, man vaig tikai pateikt kur to izdarīt. IPB versija v2.2.2

    Ja ir kāda minūtīte laiks, uzraksti ;]

  8. peec } ieliec semikolu (laikam taa)

     

    $title = 'nokluseetaais title';

    if ($page=='index.php'){

    $title='index';

    };

    elseif ($page='galerija.php'){

    $title='galerija';

    };

     

     

     

     

     

     

    Iet vai neiet?

  9. Aizmirsu pateikt ka esmu galigs n00bs mysql, tapec nezinu ko darit. Neesiet bargi :/

     

    1. a ka nomainit? :(

    2. Jap, tabulas neizveidojas, errors te ->

    SQL vaicājums: 
    
    CREATE TABLE `keys` (
    `user_id` int( 11 ) NOT NULL AUTO_INCREMENT ,
    `key` varchar( 32 ) NOT NULL DEFAULT '',
    PRIMARY KEY ( `user_id` ) 
    ) ENGINE = MYISAM DEFAULT CHARSET = latin1 
    
    CREATE TABLE `messages` (
    `id` int( 11 ) NOT NULL AUTO_INCREMENT ,
    `from` varchar( 255 ) NOT NULL DEFAULT '0',
    `to` varchar( 255 ) NOT NULL DEFAULT '0',
    `message` longtext NOT NULL ,
    `title` varchar( 255 ) NOT NULL DEFAULT '',
    `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ,
    `read` int( 1 ) NOT NULL DEFAULT '0',
    PRIMARY KEY ( `id` ) 
    ) ENGINE = MYISAM DEFAULT CHARSET = latin1 
    
    CREATE TABLE `users` (
    `id` int( 11 ) NOT NULL AUTO_INCREMENT ,
    `username` varchar( 255 ) NOT NULL DEFAULT '',
    `password` varchar( 32 ) NOT NULL DEFAULT '',
    `name` varchar( 255 ) NOT NULL DEFAULT '',
    `email` varchar( 255 ) NOT NULL DEFAULT '',
    `ip` varchar( 255 ) NOT NULL DEFAULT '',
    `admin` int( 1 ) NOT NULL DEFAULT '0',
    PRIMARY KEY ( `id` ) 
    ) ENGINE = MYISAM DEFAULT CHARSET = latin1 
    
    MySQL teica:  
    #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE `messages` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `from` varchar' at line 7

×
×
  • Create New...