Jump to content
php.lv forumi

Gacha

Reģistrētie lietotāji
 View Profile  See their activity

  • Posts

    805

  • Joined

  • Last visited

 Content Type 

Posts posted by Gacha

  1. php engine

    in PHP un PHP :)

    Posted

    :D Mega milziigs paldies par sho kodu :D

     

    Nu man itkaa vis straadaa tikai tada maza niansiite, ko man rakstiit linkaa ja gribu lai atveras basketbols.php ja tur ir shitaa 

    'basketbols'=>'basketbols.php',

  2. php engine

    in PHP un PHP :)

    Posted

    Nu labi es tos buferus likshu mieraa :rolleyes: .

    bet man liekas, ka taa ideja par to <? include ("$lapa"); ?> buutu laba.

    Vai tad tas ir jataisa ar taam klaseem? Vai nevar kaut kaa tos $lapa nodefineet ar kaut kaadiem ID

     

    Shis man atvieglotu dziivi, tad es uztaisiitu tikai lapas dizainu un parejaas lapas buutu tikai informacija kuru varetu inkluudot.

    Tiko ka uztaisitu jaunu lapu tad to tik ierakstiitu config.php :lol:

     

    Kad aizieshu maajaas, tad megginaashu uztaisiit to config.php bet diez vai sanaaks, jo ar pirmo reizi php man nekas veel nav sanaacis.

  5. php engine

    in PHP un PHP :)

    Posted

    NU es nupat izdomaaju, ka vareetu shitaa pamegginaat.

     

    Galvenaa lapaa ir includoti labaa malaa un kreisaa mala, bet pa vidu(lapas saturs)

    vareetu buut shaadi 

    <? include("$lapa");?>

    un tad vajag comfig.php bet to es nemaaku uztaisiit. Varbuut kaads zin kaa?

  8. Per page posts

    in PHP un datubāzes

    Posted

    Nu es pamegginaju tos tiger errorus, bet tad man ir veel lielaaka putra. Tos salikshu peec tam. Nu tad taa - shis ir tas mans mega sasniegums news.php , kursh straadaa normaali 

    <html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1257">
</head>

<body>
<a href="post_news.php" target="_self">Ievietot postu</a>
<?
error_reporting(E_ALL);
 include_once("../protected/mysql_config.php");
$tablename = "news";
if (!mysql_connect($hostname,$dbuser,$dbpass))
 {echo "Nevar pievienoties DB";}

//izvadu informaciju no DB
if (mysql_select_db ($dbname)) { 
        $result = mysql_query ("Select * from $tablename order by id desc");
  if (mysql_affected_rows() != 0) { 
        while ($row = mysql_fetch_array ($result)) {
   echo "<table width='300' border='1' cellpadding='0' cellspacing='0' bordercolor='#FFFFFF'>
                <tr>
                <td bgcolor='#003366'>
                <div align='center'><font color='#CCCCCC' size='-1' face='Geneva, Arial, Helvetica, sans-serif'><strong>".$row["tema"]."</strong></font></div></td>
                </tr>
                <tr>
                <td height='71' valign='top' bgcolor='#CCCCCC'>".$row["texts"]."</td>
                </tr>
                <tr>
                <td align='right' bgcolor='#003366'><font color='#CCCCCC' size='-1' face='Geneva, Arial, Helvetica, sans-serif'>".$row["datums"]."</font></td>
                </tr>
                </table>
    <a href=\"delete.php?news_id=".$row["id"]."\"> Dzēst</a>

    "; }}}
    else echo "Neizdevaas nolasiit informaciju no DB.";


?> 
</body>
</html>

    (Tur droshi vien veel pietrukst paaris error cheki, bet man pagaidaam pietiek)

    Un shis ir no viena turtoriala ar kuru vajadzetu uztaisiit Previous un next pogas. 

    if(!isset($start)) $start = 0;

$query = "SELECT * FROM $tablename LIMIT " . $start . ", 10";

$result = mysql_query($query); 

$self=$_SERVER['PHP_SELF'];
$query = "SELECT count(*) as count FROM $tablename"; 
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$numrows = $row['count'];
if($start > 0) 
  echo "<a href=\$self?start=" . ($start - 10) . 
       "\">Previous</a><BR>\n";
if($numrows > ($start + 10)) 
  echo "<a href=\$self?start=" . ($start + 10) . 
       "\">Next</a><BR>\n";

     

    Man shkjiet, ka vajadzetu nomainiit te $query pret $query1 un parejos taa pat, jo vinji pilda citas funkcijas atshkkiriibaa no taa tur aushaa kur ir taadi pashi. Vai arii taa nevajag dariit?

     

    Es taa apmeeram saprotu ko kura rindinja dara, bet ko dara shii $row = mysql_fetch_array($result); tieshi tas fech array?

     

    Un ja pielieku sho kodu zem news.php tad tas galiigi nestraadaa.

  10. Per page posts

    in PHP un datubāzes

    Posted

    Nu es papildinaaju savu news.php ar viena turtoriala palidzibu, lai varetu noteikt cik postiem raadiitos vienaa lapaa, bet man raada erroru

    Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in d:\usr\www\db\news.php on line 52

     

    Un te ir news.php

    <html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1257">
</head>

<body>
<a href="post_news.php" target="_self">Ievietot postu</a>
<?  include_once("../protected/mysql_config.php");
$tablename = "news";
if (!mysql_connect($hostname,$dbuser,$dbpass))
 {echo "Nevar pievienoties DB";}

//izvadu informaciju no DB
if (mysql_select_db ($dbname)) { 
        $result = mysql_query ("Select * from $tablename order by id desc");
  if (mysql_affected_rows() != 0) { 
        while ($row = mysql_fetch_array ($result)) {
   echo "<table width='300' border='1' cellpadding='0' cellspacing='0' bordercolor='#FFFFFF'>
                <tr>
                <td bgcolor='#003366'>
                <div align='center'><font color='#CCCCCC' size='-1' face='Geneva, Arial, Helvetica, sans-serif'><strong>".$row["tema"]."</strong></font></div></td>
                </tr>
                <tr>
                <td height='71' valign='top' bgcolor='#CCCCCC'>".$row["texts"]."</td>
                </tr>
                <tr>
                <td align='right' bgcolor='#003366'><font color='#CCCCCC' size='-1' face='Geneva, Arial, Helvetica, sans-serif'>".$row["datums"]."</font></td>
                </tr>
                </table>
    <a href=\"delete.php?news_id=".$row["id"]."\"> Dzēst</a>

    "; }}}
    else echo "Neizdevaas nolasiit informaciju no DB.";
    mysql_close();




if(!isset($start)) $start = 0;

$query = "SELECT * FROM $tablename LIMIT " . $start . ", 10";
//do database connection
$result = mysql_query($query); //you should do error checking
//display data

//this code was wrong, I did not have the second query. Thanks to Plaggy Pig.
// need another query to get the total amount of rows in our table
$self=$_SERVER['PHP_SELF'];
$query = "SELECT count(*) as count FROM $tablename"; 
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$numrows = $row['count'];
if($start > 0) 
  echo "<a href=\$self?start=" . ($start - 10) . 
       "\">Previous</a><BR>\n";
if($numrows > ($start + 10)) 
  echo "<a href=\$self?start=" . ($start + 10) . 
       "\">Next</a><BR>\n";
?> 
</body>
</html>

     

    Megginaaju visaadi, bet man nesanaak, nevaru atrast klluudu, bet man liekas, ka tur viss ir viena liela klluuda :D

  14. Delete post

    in PHP un datubāzes

    Posted

    OOO!!! :D :D :D Ir. Lai tiktu pie taadas lietas, ka var iepostot postus un tad tos izdzees es pa internetu un forumiem mekleejos dienu no dienas jau meenesi un tagad tas ir.

     

    Lielas paldies!!!

     

    Tik varetu man pateikt, ko man veel vajadzeetu tur pielikt, lai buutu droshaak pareizaak?

     

    Piemeeram add.php vajadzeetu kaadus filtrus vai arii veel kaut ko ko juus tur parasti sarakstaat vesalaam kaudzeem :D add.php

    <? include("../protected/mysql_config.php");
   $tablename = "news";
$link = mysql_connect($hostname,$dbuser,$dbpass);
mysql_select_db("$dbname");
//pievienoju informaciju DB
$ins_str = "Insert into $tablename set tema='".$HTTP_POST_VARS['tema']."', texts='".$HTTP_POST_VARS['texts']."', id='".$HTTP_POST_VARS['id']."', datums='".date("Y-m-d H:i:s")."'"; 
if (mysql_query ($ins_str, $link)) 
        {  echo "Posts ir veiksmigs!.</p>"; 
        }
  mysql_close();


?>
<a href="post_news.php" target="_self">Ievietot jaunu?</a>

  15. Delete post

    in PHP un datubāzes

    Posted

    Man delete.php saka ka 

    Notice: Undefined variable: stastaid in d:\usr\www\db\delete.php on line 9

     

    php.delete.php

    <?php
include("../protected/mysql_config.php");
$tablename = "news";
$link = mysql_connect($hostname,$dbuser,$dbpass);
mysql_select_db("$dbname");
//dzeshu informaciju DB
$del_str = "DELETE from $tablename where id=$stastaid "; 
if (mysql_query ($del_str, $link)){echo "Posts ir dzests. ";}
 else{
          echo "Neizdevaas dzest";}

 
  mysql_close();
?>
<a href="news.php">Atpakall</a>

     

    Saprotu to ka vinjsh nesaprot to $stastaid ka var to nodefineet?

     

     

    un te ir news.php bez taas submit pogas. (рпр tagad es ieraudziju to klluudu :D ) 

    <html>
<head>
<title>NEWS</title>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1257">
</head>

<body>
<a href="post_news.php" target="_self">Ievietot postu</a>
<?  include_once("../protected/mysql_config.php");
$tablename = "news";


//izvadu informaciju no DB
if (mysql_select_db ($dbname)) { 
        $result = mysql_query ("Select * from $tablename order by id desc");
  if (mysql_affected_rows() != 0) { 
        while ($row = mysql_fetch_array ($result)) {
    echo "<table width='300' border='1' cellpadding='0' cellspacing='0' bordercolor='#FFFFFF'>
                <tr>
                <td bgcolor='#003366'>
                <div align='center'><font color='#CCCCCC' size='-1' face='Geneva, Arial, Helvetica, sans-serif'><strong>".$row["tema"]."</strong></font></div></td>
                </tr>
                <tr>
                <td height='71' valign='top' bgcolor='#CCCCCC'>".$row["texts"]."</td>
                </tr>
                <tr>
                <td align='right' bgcolor='#003366'><font color='#CCCCCC' size='-1' face='Geneva, Arial, Helvetica, sans-serif'>".$row["datums"]."</font></td>
                </tr>
                </table>
    <a href=\"delete.php?stastaid=".$row["id"]."\"> Dzēst</a>

    "; }}}
    else echo "Neizdevaas";
    mysql_close();
	 

?>
</body>
</html>

     

    PS. Es daru taa, ja gribu html kodu ielikt php tad uztaisu to uz html ielieku php un visur kur ir " partaisu par ' un lieta darita. Ja to drukaa uz php tad taksh iisti nevar zinaat kaa tas izskatiisies!

  16. Delete post

    in PHP un datubāzes

    Posted

    nu man news.php ir shitaa: 

    <form name='delete' method='post' action='delete.php'>
<input name='id' type='hidden' value='".$row["id"]."'>
<input type='submit' name='submit' value='Delete'>
<form/>

     

    Nu forma tur aiztaisaas. Veel es noliku pie katra posta lai vinjsh uzrada ID un tur vinjsh to arii uzraada pareizi, bet kad posto to uz delete.php tad tas sanjem pirmaa posta ID

     

    delete.php 

    <?php
include("../protected/mysql_config.php");
$tablename = "news";
$link = mysql_connect($hostname,$dbuser,$dbpass);
mysql_select_db("$dbname");
//dzeshu informaciju DB
$del_str = "DELETE from $tablename where id='".$HTTP_POST_VARS['id']."'"; 
if (mysql_query ($del_str, $link)){echo "Posts ".$HTTP_POST_VARS['id']." ir dzests. ";}
 else{
          echo "Neizdevaas dzest";}

 
  mysql_close();
?>
<a href="news.php">Atpakall</a>

     

    Klluda ir kaut kur news.php ar to delete podzinju.

     

    Itkaa ir veel viens variants ar kaut kaut kaadu if action.... Taa ir?

  17. Delete post

    in PHP un datubāzes

    Posted

    Es panjemo un delete.php lapaa prosta uztaisiju 

    echo ("Posts ".$HTTP_POST_VARS['id']." ir dzests");

    Un vinjsh man uzradija peedeejaa posta nummuru.

     

    Tad tomeer vaina ir tai news.php

     

    Nomainiju to id , bet nav nekaada atshkjiriba. Tur ir kaut kaada cita problema. <_<

  18. Delete post

    in PHP un datubāzes

    Posted

    Es uz taisiju shitaa: news.php

    <?  include_once("../protected/mysql_config.php");
$tablename = "news";


//izvadu informaciju no DB
if (mysql_select_db ($dbname)) { 
        $result = mysql_query ("Select * from $tablename order by id desc");
  if (mysql_affected_rows() != 0) { 
        while ($row = mysql_fetch_array ($result)) {
    echo "<table width='300' border='1' cellpadding='0' cellspacing='0' bordercolor='#FFFFFF'>
                <tr>
                <td bgcolor='#003366'>
                <div align='center'><font color='#CCCCCC' size='-1' face='Geneva, Arial, Helvetica, sans-serif'><strong>".$row["tema"]."</strong></font></div></td>
                </tr>
                <tr>
                <td height='71' valign='top' bgcolor='#CCCCCC'>".$row["texts"]."</td>
                </tr>
                <tr>
                <td align='right' bgcolor='#003366'><font color='#CCCCCC' size='-1' face='Geneva, Arial, Helvetica, sans-serif'>".$row["datums"]."</font></td>
                </tr>
                </table>
    <form name='delete' method='post' action='delete.php'>
<input name='id' type='hidden' value='".$row["id"]."'>
<input type='submit' name='submit' value='Delete'>
<form/>
    "; }}}
    else echo "Neizdevaas";
    mysql_close();
	 

?>

    un delete.php ir shitaads

    <?php
include("../protected/mysql_config.php");
$tablename = "news";
$link = mysql_connect($hostname,$dbuser,$dbpass);
mysql_select_db("$dbname");
//dzeshu informaciju DB
$del_str = "DELETE from $tablename where id='".$HTTP_POST_VARS['id']."'"; 
if (mysql_query ($del_str, $link)) 
        {  echo "Posts dzests!.</p>"; 
        }
  mysql_close();
?>

     

    Nu tagad vinjsh dzesh ierakstus, bet ir taada problema, ka vinjsh dzeesh ne to pie kura pogu nospiesta bet vienkaarshshi dzeesh saakot ar pirmo postu.

     

    Kaut kas nav kartiibaa ar to news.php cik saprotu tad vinjsh aizsuuta ID=1 nevis ID=.$row["id"]. kapeec taa?

  20. Delete post

    in PHP un datubāzes

    Posted

    Nu te ir news.php 

    <?  include_once("../protected/mysql_config.php");
$tablename = "news";


//izvadu informaciju no DB
if (mysql_select_db ($dbname)) { 
        $result = mysql_query ("Select * from $tablename order by id desc");
  if (mysql_affected_rows() != 0) { 
        while ($row = mysql_fetch_array ($result)) {
    echo "<table width='300' border='1' cellpadding='0' cellspacing='0' bordercolor='#FFFFFF'>
                <tr>
                <td bgcolor='#003366'>
                <div align='center'><font color='#CCCCCC' size='-1' face='Geneva, Arial, Helvetica, sans-serif'><strong>".$row["tema"]."</strong></font></div></td>
                </tr>
                <tr>
                <td height='71' valign='top' bgcolor='#CCCCCC'>".$row["texts"]."</td>
                </tr>
                <tr>
                <td align='right' bgcolor='#003366'><font color='#CCCCCC' size='-1' face='Geneva, Arial, Helvetica, sans-serif'>".$row["datums"]."</font></td>
                </tr>
                </table>
    <form name='delete' method='post' action='delete.php'>
<input name='' type='hidden' value=".$row["id"].">
<input type='submit' name='id' value='Delete'>
<form/>
    "; }}}
    else echo "Neizdevaas";
    mysql_close();
	 

?>

    Nu kad tas paraadaas tad zem katra postinja paraadaas submit podzinja, kura suuta attieciiga posta ID uz lapu delete.php 

    <?php
include("../protected/mysql_config.php");
$link = mysql_connect($hostname,$dbuser,$dbpass);
mysql_select_db("$dbname");
mysql_query("delete from news where id = ".$HTTP_POST_VARS['id']."");



mysql_close();
?>

    Cik sapratu tad no news.php vinjsh visu smuki aisuuta, bet problema varetu buut delete.php

    Nu un veel dereetu taas abas lapinjas nedaudz izpushkjot, varbuut var kaads kaut ko paliidzeet?

     

    PS. Problema ir taa ka nospiezh pogu delete tad aiziet uz lapu delete.php bet nekas nenotiek, pat errorus nemet araa.

  22. Domain name

    in PHP hostings

    Posted

    Nu man viena lapinja staav pie choma uz serveri un es izmantoju www.no-ip.com

    Tur var piereggistreet DNS par velti piem: tavalapa.sytes.net un ir veel citi. Labi ir tas, ka uz tavu lapu var aiziet arii tie, kuriem nav pieejamas aarzemes.

     

    Bet gribu zinaat vai latvijaa kaut kur arii var dabuut DNS bezmaksas?

  23. php engine

    in PHP un PHP :)

    Posted

    Nu sho palasot es apm kaut ko sapratu, bet pielietot nemaceetu. Varbut kaut kur ir kaads mazinjsh turtorialis no A-Z.

     

    Ar to class man asoaciejas CSS class izmantoshana, bet php es nezinu kaa tos lietot.

     

    Un ar to output buffering - Vai vienkarshi es varu lapas augshaa starp php tagiem ierakstiit ob_start(); un lapas apakshaa starp tiem tagiem ob_end_flush();

     

    Un tad vinjsh pa priekshu ielades visu lapu un tad tik to paraadiis?

×
×
  • Create New...