Domov > Programiranje > Problem v PHP adminu
stran 1 od 2 |< < 1 2 >|
Problem v PHP adminu
 
horsovski 12. okt 2007 19:10:25 Pridružen od:
4. jul 2007
24 objav
 2 0 0
#1

Lep pozdrav.



Pred kratkim so mi eni mozje sprogramiral stran in tud admin ki je v php-ju. Imam naslednji problem:



Na strani imam admin, kjer so clani strani. Na managetitan.php je liste vseh clanov(10 na stran), kjer je tudi opcija edit(edittitan.php), kjer spreminjam njihove statuse(pending,approved,declined). Problem je naslednji:

Recimo da odprem stran 5 in kliknem na clana XXX -edit(edit_titan.php?id=xxx) , kjer nastvim njegov status in kliknem "Submit". Ko je status spremenjen, me vedno po tem vrne na stran 1. Rad bi pa naredil tako da ko spremenim temu uporabniku status, da me vrze nazaj na istro stran kjer je leta bil(v tem primeru stran 5). Ce kdo ve kako se to naredi, bi bil zelo hvalezen ce lahko opise.


všeč(0) ni všeč(0) spam(0)
 
 
frisby 12. okt 2007 19:10:29 Pridružen od:
6. sep 2006
1625 objav
 7 0 0
#2

Najlažje je, da si v linku na seznamu še povsod dodajaš edit_titan.php?id=xxx&izStrani=x in potem se vrne na ta x. Samo če imaš funkcijo različnih razvrstitev seznama, moreš upoštevati še to.


všeč(0) ni všeč(0) spam(0)
 
 
horsovski 12. okt 2007 19:10:29 Pridružen od:
4. jul 2007
24 objav
 2 0 0
#3

B]manage_titan.php:


<?

ob_start();

include"header.php";



$no=1;

$sp=0;



$qpage="select *, titan.date as display_date  from titan, member

WHERE titan.member_id=member.member_id

order by titan_id";

$rs_page=mysql_query($qpage);

$cnt=mysql_num_rows($rs_page);

$totalpage=ceil($cnt/10);



if(isset($_GET['pageno']))

   $no=$_GET['pageno'];

$sp=($no*10)-10;



if(!$by) {

   $by = 'titan_id';

}

//echo $sortby;

$sql="SELECT *, titan.date as display_date, titan.status as display_status FROM titan, member

WHERE titan.member_id=member.member_id

order by $by $sort

limit $sp,10 ";



//$sql= "select * from site_user where type!='admin'order by pk_id limit $sp,10";

$result=mysql_query($sql);

?><head>

<script>

function chkDel(getId)

{

   if(confirm("Are you sure want to delete this user?"))

   {

      location.href="delete_titan.php?id="+getId;

   }

}

</script>

</head>            <table align="center" border="0" cellpadding="0" cellspacing="0" width="850">

            <tbody><tr>

               <td class="border" bgcolor="#ffffff" valign="top" width="850"><table width="100%" border="0" cellspacing="0" cellpadding="0">

                      <tr>

                        <td width="196" align="left" valign="top"><?

include"left_nav.php";

?></td>

                        <td valign="top">

                  <form name="form" action="crm_submit.php" enctype="multipart/form-data" method="post">

                          <table align="center" bgcolor="#ffffff" border="0" cellpadding="2" cellspacing="2" width="95%">

                          <tbody>

                            <tr>

                              <td valign="top" bgcolor="#666666"><table width="100%" border="0" cellspacing="0" cellpadding="0">

                                <tr>

                                  <td><span class="style3"><strong>Manage Titan Poker </strong></span></td>

                                  <td><div align="right"><a href="add_customer.php" class="menu"></a></div></td>

                                </tr>

                              </table></td>

                            </tr>

                            <tr>

                              <td valign="top" width="68%"><table width="100%"  border="0" class="buttons" align="center" cellspacing="1" bgcolor="#f5f5f5" style="border:#999999 solid 1px;">

                          <tr align="left" valign="middle">

                             <?



                     if($sort=="asc")

                     {

                        $newsort = 'desc';

                     } else {

                        $newsort ="asc";

                     }

                     ?>

                            <td width="11%" height="23" >Sl.No.</td>

                            <td width="15%" >

                                 <a href="manage_titan.php?sort=<? echo $newsort; ?>&by=titan_username">Titan User Name</a>

                            </td>

                            <td width="18%" >

                               <a href="manage_titan.php?sort=<? echo $newsort; ?>&by=titan_name">Titan Screenname</a>

                            </td>

                            <td width="16%" >

                        <a href="manage_titan.php?sort=<? echo $newsort; ?>&by=titan_email">Titan Email</a>

                     </td>

                     <td width="16%" >

                        <a href="manage_titan.php?sort=<? echo $newsort; ?>&by=titan.date">Date</a>

                     </td>

                            <td width="11%" >

                               <a href="manage_titan.php?sort=<? echo $newsort; ?>&by=member_email">Username</a>

                     </td>

                     <td width="11%" >

                        <a href="manage_titan.php?sort=<? echo $newsort; ?>&by=ip">Ip</a>

                     </td>

                     <td width="11%" >

                        <a href="manage_titan.php?sort=<? echo $newsort; ?>&by=titan.status">Status</a>

                     </td>

                            <td width="11%" >Action</td>

                          </tr>

                          <?

                    $i=0;

  while ($rs = mysql_fetch_array($result))

{

$i++;

   if($i%2 == 0)

      $bgcolor = "#f6f6f6";

   else

      $bgcolor = "#DBDBDB";

?>

                          <tr>

                            <td class="bodytext" bgcolor="<?=$bgcolor?>" height="23">

                                 <?=$i;?>.                            </td>

                            <td class="bodytext" bgcolor="<?=$bgcolor?>">

                                <?=$rs['titan_username'];?>                            </td>

                            <td class="bodytext" bgcolor="<?=$bgcolor?>">

                                      <?=$rs['titan_name'];?>                  </td>

                            <td width="16%" class="bodytext" bgcolor="<?=$bgcolor?>">

                               <a href="mailto:<?=$rs[titan_email]?>"> <?=$rs['titan_email'];?></a></td>

                       <td width="16%" class="bodytext" bgcolor="<?=$bgcolor?>">

                               <?=$rs['display_date'];?></td>



                            <td width="11%" bgcolor="<?=$bgcolor?>">

                     <?

                  //$member_id=$rs['member_id'];

                  //$sql_site="select * from member where member_id=$member_id";

                  //$result_site=mysql_query($sql_site);

                  //$rs_site=mysql_fetch_array($result_site);

                     ?><a href="view_customer.php?id=<?=$rs['member_id'];?>"><? echo $rs['member_email'];?></a></td>

                     <td width="16%" class="bodytext" bgcolor="<?=$bgcolor?>">

                               <?=$rs['ip'];?></td>

                      <td width="16%" class="bodytext" bgcolor="<?=$bgcolor?>">

                               <?

                           if($rs['display_status']==1)

                              echo "Accepted";

                           else if($rs['display_status']==2)

                              echo "Declined";

                           else

                           echo"Pending";

                        ?></td>



                            <td width="11%"  class="bodytext" bgcolor="<?=$bgcolor?>"><a class="red_small_links" href="edit_titan.php?id=<?=$rs['titan_id'];?>">Edit</a>

                              /<a class="red_small_links" href="#" onClick="chkDel('<?=$rs[titan_id]?>');">

                              Delete </a></td>

                          </tr>

                          <?

     }



?>

                        </table></td>

                            </tr>

                            <tr>

                              <td valign="top" align="center">

                         Pages

                        <?



if($totalpage > 9) {

               if(!isset($_GET['pageno'])) {

                     $_GET['pageno'] = 1;

               }

               if($_GET['pageno'] <> 1) {

                  echo" <a href='manage_titan.php?" . "sort=" . $sort . "&by=" . $by . "&pageno=" . ($_GET['pageno'] - 1) . "' class='bodytext'>Previous</a>";

                  echo" <a href='manage_titan.php?" . "sort=" . $sort . "&by=" . $by . "&pageno=1' class='bodytext'><<</a>";

               }



               if($_GET['pageno'] > 4 AND $_GET['pageno'] < $totalpage-4) {

                     for($i=$_GET['pageno']-4;$i<=$_GET['pageno']+4;$i++)

                     {

                  if($i==@$_GET['pageno'])

                  {

                      echo $_GET['pageno'];



                  }

                  else

                  {

                     echo" <a href='manage_titan.php?" . "sort=" . $sort . "&by=" . $by . "&pageno=$i' class='bodytext'>".$i."</a>";

                  }

               }

               } else if($_GET['pageno'] <= 4) {

                     for($i=1;$i<=9;$i++)

                     {

                  if($i==@$_GET['pageno'])

                  {

                      echo $_GET['pageno'];



                  }

                  else

                  {

                     echo" <a href='manage_titan.php?" . "sort=" . $sort . "&by=" . $by . "&pageno=$i' class='bodytext'>".$i."</a>";

                  }

               }

            } else if($_GET['pageno'] >= $totalpage-4) {

                     for($i=$totalpage-8;$i<=$totalpage;$i++)

                     {

                  if($i==@$_GET['pageno'])

                  {

                      echo $_GET['pageno'];



                  }

                  else

                  {

                     echo" <a href='manage_titan.php?" . "sort=" . $sort . "&by=" . $by . "&pageno=$i' class='bodytext'>".$i."</a>";



                  }

               }



               }



               if($_GET['pageno'] <> $totalpage) {

               echo" <a href='manage_titan.php?" . "sort=" . $sort . "&by=" . $by . "&pageno=" . ($totalpage) . "' class='bodytext'>>></a>";



                  echo" <a href='manage_titan.php?" . "sort=" . $sort . "&by=" . $by . "&pageno=" . ($_GET['pageno'] + 1) . "' class='bodytext'>Next</a>";

               }



} else {

///-----------------------------------
všeč(0) ni všeč(0) spam(0)
 
 
horsovski 12. okt 2007 19:10:30 Pridružen od:
4. jul 2007
24 objav
 2 0 0
#4 
for($i=1;$i<=$totalpage;$i++)

{

if($i==@$_GET['pageno'])

      {

    echo $_GET['pageno'];



      }

else

      {

      echo" <a href='manage_titan.php?" . "sort=" . $sort . "&by=" . $by . "&pageno=$i' class='bodytext'>".$i."</a>";

      }

}

///-----------------------------------

}

?></td>

                            </tr>

                          </tbody>

                        </table>

                  </form></td>

                      </tr>

                    </table></td>

               <td background="images/right.jpg" width="9"><div align="right"></div>

               </td>

            </tr>

            <tr>

               <td colspan="2"> </td>

            </tr>

         </tbody></table>



<?

include"footer.php";

?>
všeč(0) ni všeč(0) spam(0)
 
 
horsovski 12. okt 2007 19:10:35 Pridružen od:
4. jul 2007
24 objav
 2 0 0
#5

edit_titan.php:


<?

ob_start();

include"header.php";

$id=$HTTP_GET_VARS['id'];



if($id)

{

$sql="SELECT * FROM titan WHERE titan_id='$id'";

  $result=mysql_query($sql);

  $rs=mysql_fetch_array($result);

}

if($_POST['edit_usr'] == "Update")

{

   $titan_id=$_POST['titan_id'];

   $titan_username=$_POST['titan_username'];

   $titan_screenname=$_POST['titan_screenname'];

   $titan_email=$_POST['titan_email'];

   $status=$_POST['status'];

   $sql = "update titan SET  titan_username='$titan_username', titan_name='$titan_screenname', titan_email='$titan_email',status = '$status' where titan_id = '$titan_id'";

  $result=mysql_query($sql);



   $_SESSION['sess_msg'] = "User Information Updated Successfully.";

   header("Location: manage_titan.php");

   exit;

}

?>            <table align="center" border="0" cellpadding="0" cellspacing="0" width="750">

            <tbody><tr>

               <td class="border" bgcolor="#ffffff" valign="top" width="750"><table width="100%" border="0" cellspacing="0" cellpadding="0">

                      <tr>

                        <td width="25%" align="left" valign="top"><?

include"left_nav.php";

?></td>

                        <td valign="top">

                  <form name="form" action="" enctype="" method="post">

                          <table align="center" bgcolor="#ffffff" border="0" cellpadding="2" cellspacing="2" width="95%" style="border:#999999 1px solid;">

                          <tbody>

                            <tr>

                              <td valign="top" bgcolor="#666666"><span class="style3">Manage Customer </span></td>

                            </tr>

                            <tr>

                              <td valign="top" width="68%"><table width="100%" border="0" cellspacing="0" cellpadding="0">

                                <tr>

                                  <td width="25%"><div align="center"><strong>Titan User  Name:</strong></div></td>

                                  <td width="25%">

                                    <label>

                                    <input name="titan_username" type="text" id="titan_username" value="<?=$rs['titan_username'];?>" size="18" />

                           <input name="titan_id" type="hidden" value="<?=$rs['titan_id'];?>" />

                                  </label></td>

                                </tr>

                                <tr>

                                  <td><div align="center"><strong>Titan Screen Name :</strong></div></td>

                                  <td>

                                  <input name="titan_screenname" type="text" id="titan_screenname" value="<?=$rs['titan_name'];?>" size="18"/></td>

                                </tr>

                                <tr>

                                  <td><div align="center"><strong>Titan Email: </strong></div></td>

                                  <td>

                          <input name="titan_email" type="text" id="titan_email" value="<?=$rs['titan_email'];?>" size="18"/></td>

                                </tr>

                                                          <tr>

                                  <td><div align="center"><strong>Status:</strong></div></td>

                                  <td> <select name="status" class="buttons"><?

                                   if($rs[status]==1)

                                 {

                                ?>

                                              <option value="1">Approved</option>

                                              <option value="0">Pending</option>

                                   <option value="2">Declined</option>

                                              <?

                                   }

                                 else if($rs[status]==0)

                                 {

                                 ?> <option value="0">Pending</option>

                                             <option value="1">Approved</option>

                                   <option value="2">Declined</option>

                                              <?

                                 }else

                                 {

                                ?><option value="2">Declined</option>

                                   <option value="0">Pending</option>

                                             <option value="1">Approved</option>



                                   <?

                                   }

                                   ?>

                                            </select>                                </td>



                                </tr>



                                <tr>

                                  <td> </td>

                                  <td><input type="submit" name="edit_usr" value="Update" class="buttons" /></td>

                                </tr>

                              </table></td>

                            </tr>

                            <tr>

                              <td valign="top" align="center"> </td>

                            </tr>

                          </tbody>

                        </table>

                  </form></td>

                      </tr>

                    </table></td>

               <td background="images/right.jpg" width="9"><div align="right"></div>

               </td>

            </tr>

            <tr>

               <td colspan="2"> </td>

            </tr>

         </tbody></table>



<?

include"footer.php";

?>
všeč(0) ni všeč(0) spam(0)
 
 
HeXeR 12. okt 2007 19:10:47 Pridružen od:
13. dec 2006
3268 objav
 122 22 5
#6

Hmm



tole:


header("Location: manage_titan.php");

zamenjaš s:


if (isset($_GET['pageno']) && is_numeric($_GET['pageno']))

{

    header("Location: manage_titan.php?pageno=".$_GET['pageno']);

}

else

{

    header("Location: manage_titan.php");

}

nisem pa preiskusil in nevem če sem vzel prave spremenljivke ... to bo Vini z eno oko pogledal pa povedal če bo delalo :D.


<?

ob_start();

include"header.php";

$id=$HTTP_GET_VARS['id'];



if($id)

{

$sql="SELECT * FROM titan WHERE titan_id='$id'";

  $result=mysql_query($sql);

  $rs=mysql_fetch_array($result);

}

if($_POST['edit_usr'] == "Update")

{

   $titan_id=$_POST['titan_id'];

   $titan_username=$_POST['titan_username'];

   $titan_screenname=$_POST['titan_screenname'];

   $titan_email=$_POST['titan_email'];

   $status=$_POST['status'];

   $sql = "update titan SET  titan_username='$titan_username', titan_name='$titan_screenname', titan_email='$titan_email',status = '$status' where titan_id = '$titan_id'";

  $result=mysql_query($sql);



   $_SESSION['sess_msg'] = "User Information Updated Successfully.";



// TOLE MISLIM:

 header("Location: manage_titan.php");



   exit;

}

pa raje prej naredi kopijo datoeke v primeru da ne dela ...


všeč(0) ni všeč(0) spam(0)
First rule of business, protect your investment.
 
 
horsovski 13. okt 2007 00:10:05 Pridružen od:
4. jul 2007
24 objav
 2 0 0
#7

Tole sem spremenil v edit_titan.php in problem se vedno ostaja.



lp


všeč(0) ni všeč(0) spam(0)
 
 
HeXeR 13. okt 2007 00:10:17 Pridružen od:
13. dec 2006
3268 objav
 122 22 5
#8

Mah lahko puskusiš še tole dodati, vendar mi ni jasno zakaj bi spremenljivka izginila iz naslova ...



[HTML]<form name="form" action="" enctype="" method="post">[/HTML]



v


<form name="form" action="<?



if (isset($_GET['pageno']) && is_numeric($_GET['pageno']))

{

    echo "edit_titan.php?pageno=".$_GET['pageno'];

}

else

{

    echo "edit_titan.php";

}



?>" enctype="" method="post">
všeč(0) ni všeč(0) spam(0)
First rule of business, protect your investment.
 
 
horsovski 13. okt 2007 12:10:17 Pridružen od:
4. jul 2007
24 objav
 2 0 0
#9

Sem spremenil tudi to, ampak še vedno ne dela.



A to dodajam samo v edit_titan.php?



lp


všeč(0) ni všeč(0) spam(0)
 
 
HeXeR 13. okt 2007 13:10:03 Pridružen od:
13. dec 2006
3268 objav
 122 22 5
#10

Ja, sej drugih datotek nisi pokazal ...



am to v edit_titan.php je samo spreminjanje spremenljivk ali seznam sam tudi ? Potem bi moral še spremeniti v tisti datoteki, s katere prideš na to datoteko.


všeč(0) ni všeč(0) spam(0)
First rule of business, protect your investment.
 
 
Domov > Programiranje > Problem v PHP adminu
stran 1 od 2 |< < 1 2 >|
 

🔒 Za odgovor na to temo se moraš prijaviti.

Prijavi se