Jump to content
php.lv forumi

false

Reģistrētie lietotāji
  • Posts

    87
  • Joined

  • Last visited

Posts posted by false

  1. Nezinu ipb datubāzi, bet izvēlc šadi

    $msg = mysql_query("SELECT * FROM message WHERE lasiits = '0'");
    echo mysql_num_rows($msg);
    

    un kad izlasa vēstuli db updeitojas un lasiits paliek 1

    .

  2. <?php
    if($_POST['dzest']){
    $km2 = $_POST['clanwars'];
    mysql_query("DELETE FROM cw WHERE km2 = '".$km2."'") or die(mysql_error());
    }
    ?>
    <form method="post">
    <strong>Ko dzēst ?</strong><br>
     <select name="clanwars" size="1" >
       <option value="fnatic">1tm vs 2tm</option>
       <option value="sk">1tm vs 2tm</option>
     </select>
    <input name="dzest" type="submit">
     </form>
    

  3. Css:

    #footer {
    clear:both;
    width:948px;
    background: url(/img/footer.gif) repeat-x;
    background-position: bottom center;
    font-family: Tahoma,Arial;
    height: 22px; 
    bottom: 0;
    }

    Un mājaslapas kodā fūteris stāv šadi

    <div id="footer">© 2009 - 2010</div>

    Kas jamaina lai varētu to fūteri ielikt, taka otrajā attelā

    #1

    a7360m5niru96klww5.jpg

    #2

    5c1xvhpcwz4omuwfmyf.jpg

  4. Tatad dātubāze `foruma_nosaukumi` izskatas šadi

    `id` int(11) NOT NULL AUTO_INCREMENT,

    `nos` varchar(255) COLLATE utf8_unicode_ci NOT NULL,

    PRIMARY KEY (`id`)

    ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=11 ;

    Dātubāze `forumi` izskatas šadi

    `id` int(11) NOT NULL AUTO_INCREMENT,

    `nosaukums` varchar(255) COLLATE utf8_unicode_ci NOT NULL,

    `paskaidrojums` varchar(255) COLLATE utf8_unicode_ci NOT NULL,

    `f_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,

    PRIMARY KEY (`id`)

    ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=11 ;

     

    Kāds var palīdzet parveidot kodu lai katrs forums stāvetu zem konkrēta nosaukuma id.

     

    Pats kods

    <div id="forums">
    <?php
    $select_f = mysql_query("SELECT * FROM foruma_nosaukumi") or die(mysql_error());
    while($f = mysql_fetch_array($select_f)){
    $select_ff = mysql_query("SELECT * FROM forumi WHERE f_id = '".$f['id']."'") or die(mysql_error());
    while($ff = mysql_fetch_array($select_ff)){
    ?>
    <div class="border"><div class="title">
    <?php echo $f['nos']; ?></div><table class="ipbtable" cellspacing="1">
    <tbody><tr> 
    <td class="head" width="66%">Forumi</td>
    <td class="head" style="text-align: center;" width="7%">Temati</td>
    <td class="head" style="text-align: center;" width="7%">Atbildes</td>
    <td class="head" width="35%">Pēdējā tēma</td></tr>		
    <tr style="border-bottom: 1px solid rgb(255, 255, 255);"> 
    <td class="row2">
    <b><a href="/forum/?id=<?php echo $ff['id']; ?>"><?php echo $ff['nosaukums']; ?></a></b><br>
    <span style="color: rgb(102, 102, 102); font-size: 10px; font-family: tahoma;"><?php echo $ff['paskaidrojums']; ?></span>
    </td>
    <td class="row1" style="border-left: 1px solid rgb(255, 255, 255);" align="center">1</td>
    <td class="row1" style="border-left: 1px solid rgb(255, 255, 255);" align="center">2</td>
    <td class="row1" style="border-left: 1px solid rgb(255, 255, 255); height: 50px;" nowrap="nowrap">
    Tēma: <b><a href="">adsadsasd</a></b><br/><small>Atbildes <b>42</b> Autors <b>false</b></small></td></tr></table></div><br>
    <?php
    }}
    ?>
    <br></div>

    Problēma ir tāda kā viņš izvēlk foruma nosaukumus un zem katra nosaukuma liek pa vienam forumam, pat ja tā id nesakrīt.

    Piemēram db `forumi` ir šadi ieraksti

    id, `nosaukums`, `paskaidrojums`, `f_id`

    1, 'test', 'tralallala', '1'

    2, 'test2', 'tralallala2', '2'

    3, 'test3', 'tralallala3', '1'

     

    Viņš to test ieliek zem foruma nosaukuma ar id 1, test2 zem id 2, test3 zem id 3

  5. Pameiģini šita

    <?php
    mysql_connect("serveris","username","pass");
    mysql_select_db("db");
    $select = mysql_query("SELECT * FROM news") or die(mysql_error());
    while($row = mysql_fetch_array($select)){
    echo $row['post-content'];
    echo $row['post-title'];
    }
    ?>

    ja radis to pašu, tad tev taja dātubāzē nav tadu tabulu vai arī vispar nav tadas dātubāzes.

  6. Kods

    <?php
    mysql_connect("localhost","root","..");
    mysql_select_db("shops");
    
    ?>

    Neko nerāda un nelējuplāde.

    Kāds var pateikt kur likt to header? Vai arī kādu citu skriptu?

  7. <script language="javascript" type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js"></script>
    <script type="text/javascript">
    $(function(){
     $(".forgot-password").find("input[type=button]").click(function(){
      var $v = $(".forgot-password").find("input[type=text]").val();
      if($v.length>2){
       $(".forgot-password").append("<div id='error-console'></div>");
       $("#error-console").css({display : 'none'}).html("Uzgaidiet").fadeIn('slow',function(){
        $.get('fpw.php',{ c : 1, hdm : $(".forgot-password").find("input[type=text]").val() }, function(d){
         if(d=='0x0'){
          $("#error-console").fadeOut('slow',function(){
           $(this).text("Nav reģistrēta šāda nika vai e-pasta").fadeIn('slow',function(){
            setTimeout('$("error-console").fadeOut("slow",function(){$(this).remove();});',2500);
           });
          });
         }else if(d=='0x1'){
          $(".forgot-password").html('Uz tavu e-pastu tika nosūtīta jaunā parole');
         }else{
          $("#error-console").css({display : 'none'}).html("Koda kļūda").fadeIn('slow',function(){
           setTimeout('$("error-console").fadeOut("slow",function(){$(this).remove();});',2500);
          });
         }
        });
       });
      }
     });
    });
    </script>
    </div>
    

    Bet visu laiku rada Koda kļūda

    Kas par vainu?

     

    p.s

    tajos javascriptos nemāku neko..

  8. Kods

    $niks = mysql_real_escape_string(md5($_POST['niks']));
    $pw = mysql_real_escape_string($_POST['pw']);
    $mem_id = mysql_real_escape_string($id);
    $nauda = mysql_real_escape_string("50");
    mysql_query("INSERT INTO game_nicks(mem_id, niks, parole, nauda, kad, termins) VALUES('$mem_id', '$niks', '$pw', '$nauda', NOW(), DATE_ADD(NOW(), INTERVAL 30 DAY)") or die(mysql_error());
    

     

    errors

    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 '' at line 1

     

    Kas nepareizs insertā?

×
×
  • Create New...