Results 1 to 19 of 19

Thread: php

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    _
    Join Date: Apr:2006
    Location: _
    Posts: 1,128

    php

    php.

    mysql while($row = mysql_fetch_array($result)) pagination . :

    1. . 1

    2 <select name="" <option value=></option>...
    pagination - -

  2. #2
    ! vbTheKing's Avatar
    Join Date: Sep:2003
    Location:
    Posts: 4,138
    .
    ''? * *
    - !
    ...

  3. #3
    _
    Join Date: Apr:2006
    Location: _
    Posts: 1,128
    ( )

    Code:
    <html>
    
     <head>
    
      <title> <?php echo "Control Panel"; ?> </title>
       <script type="text/javascript" src="jquery.js"></script>
        <link rel="shortcut icon" href="lo7.png" type="image/x-icon">
    
        <style type="text/css">
    <!--Clients window-->
    	.b1f, .b2f, .b3f, .b4f{font-size:1px; overflow:hidden; display:block;}
    	.b1f {height:1px; background:black; margin:0 5px;}
    	.b2f {height:1px; background:black; margin:0 3px;}
    	.b3f {height:1px; background:black; margin:0 2px;}
    	.b4f {height:2px; background:black; margin:0 1px;}
    	.contentf {background-image:url('backa.png'); width:100%; height:100%;}
    <!--Quick links-->
          .b1fx, .b2fx, .b3fx, .b4fx{font-size:1px; overflow:hidden; display:block;}
    	.b1fx {height:1px; background:black; margin:0 5px;}
    	.b2fx {height:1px; background:black; margin:0 3px;}
    	.b3fx {height:1px; background:black; margin:0 2px;}
    	.b4fx {height:2px; background:black; margin:0 1px;}
    	.contentfx {background-image:url('backa.png'); width:100%; height:100%;}
    <!--Buttons bottom-->
    	.b1fz, .b2fz, .b3fz, .b4fz, .b5fz, .b6fz, .b7fz, .b8fz, .b9fz{font-size:1px; overflow:hidden; display:block;}
    	.b1fz {height:1px; background:black; margin:0 245px;}
    	.b2fz {height:1px; background:black; margin:0 244px;}
    	.b3fz {height:1px; background:black; margin:0 243px;}
    	.b4fz {height:2px; background:black; margin:0 242px;}
    	.b5fz {height:2px; background:black; margin:0 241px;}
    	.b6fz {height:2px; background:black; margin:0 240px;}
    	.b7fz {height:2px; background:black; margin:0 239px;}
    	.b8fz {height:2px; background:black; margin:0 238px;}
    	.b9fz {height:2px; background:black; margin:0 237px;}
    <!--Pagination style-->
    	div.pagination {
    		padding: 3px;
    		margin: 3px;
    	}
    
    	div.pagination a {
    		padding: 2px 2px 2px 2px;
    		margin: 0px;
    		border: 0px solid white;
    	
    		text-decoration: none; /* no underline */
    		color: white;
    	}
    	div.pagination a:hover, div.pagination a:active {
    		border: 1px solid white;
    
    		color: #666666;
    	}
    	div.pagination span.current {
    		padding: 3px 1px 3px 1px;
    		margin: 0px;
    			border: 1px solid white;
    		
    			font-weight: bold;
    			background-color:  ;
    			color: #FFF;
    		}
    		div.pagination span.disabled {
    			padding: 2px 5px 2px 5px;
    			margin: 5px;
    			border: 0px solid #EEE;
    	
    			color: #DDD;
    		}
         </style>
    	 
    
      </head>
    
    
    
    <body bgcolor='#E5E5E5'> <center>
    	<div id="layer1" style="background-color:black; width:100%; height:29px; position:absolute; left:0px; top:0px; z-index:9;">
    		
    <?php include ("Data/Includes/Functions/Date_Func.php"); ?> 
    
            </div>
    
    
    	<div id="layer2" style="background-image:url('Data/Images/Im1.png'); width:100%; height:112px; position:absolute; left:0px; top:29px; z-index:1;">
    
    	    <div id="layer7" style="text-align:center; background-image:url('Data/Images/Logo_CRP.png'); background-repeat:no-repeat; margin-left:0; width:284px; height:60px; position:absolute; left:37%; top:35px; z-index:1;">
    
    	    </div>
    
    	</div>
    
    <? include("Buttons.php"); ?>		
    
    			<div id="layer4" style="background-color:rgb(229,229,229); background-image:url('Data/Images/BackGR_1.gif'); background-repeat:repeat-x; width:100%; height:843px; position:absolute; left:0px; top:167px; z-index:1;">
    
    			
    				<b class="b9fz"></b><b class="b8fz"></b><b class="b7fz"></b><b class="b6fz"></b><b class="b5fz"></b><b class="b4fz"></b><b class="b3fz"></b><b class="b2fz"></b><b class="b1fz"></b>
    
    <!--Main workspace-->
    
    
    <!--quick links-->
    <?php
    include ("Quick_Links.php");
    ?> 	
    
    <!--end of quick links-->
    
    
    <!--show users table-->
    
     <script>
    
    $(function(){
    
    $("table# tr").hover( function(){
    
    $(this).children('td').css( { 'background' : 'url(http://localhost/ICMSS27/Web_pages/fon.png)', 'background-color' : '' } );
    
    }, function(){
    
    $(this).children('td').css( { 'background' : 'url()' } );
    
    });
    
    }
    
    ); 
    
     </script>
    
    
    
    				<div id="layer1z" style="width:77%; height:626px; position:absolute; left:263px; top:32px; z-index:1;">
    					<b class="b1f"></b><b class="b2f"></b><b class="b3f"></b><b class="b4f"></b>
        					<div class="contentf">
    
    
    	
    
    
    					
    
    					    <div id="layer2z" style="background-image:url('Mosaic-Header_01.jpg'); width:947px; height:54px; position:absolute; left:14px; top:13px; z-index:1;">
    
    						  <div id="layer3z" style="background-image:url('logo clients.png'); background-repeat:no-repeat; width:200px; height:31px; position:absolute; left:400px; top:18px; z-index:1;">
    
    				
    
    						  </div>
    
    		
    
    					    </div>
    
    
    
    <?php
    	
    		
    		$link = mysql_connect("localhost", "root", "qwerty");
    		mysql_select_db("ICMSS27", $link);
    		
    		$result = mysql_query('SELECT ClientNumber, IPAddress, ClientLogin, SkypeName, ICQNumber, EMail, Phonumber, created FROM Users', $link);
    ?>
    
    
    					    <div id="layer4z" style="width:615px; height:594px; position:absolute; left:14px; top:76px; z-index:1;">
    
    
    
    						  <table bgcolor="#333333" width="945" style="background-color:black; font-size:11; border-color:black; border-collapse:collapse;" bordercolordark="black" bordercolorlight="black" cellspacing="0">
    
    							<tr bordercolordark="black" bordercolorlight="black" style="color:white; background-color:black; border-color:black;" bgcolor="black">
    
    							    <td width="40" style="color:white; background-color:black; border-width:1; border-color:rgb(21,16,16); border-style:groove;" bgcolor="black"><center>ID</td>
    
    							    <td width="127" style="color:white; background-color:black; border-width:1; border-color:rgb(21,16,16); border-style:groove;" bgcolor="black"><center>Client Number</td>
    
    							    <td width="127" style="color:white; background-color:black; border-width:1; border-color:rgb(21,16,16); border-style:groove;" bgcolor="black"><center>IP Address</td>
    
    							    <td width="127" style="color:white; background-color:black; border-width:1; border-color:rgb(21,16,16); border-style:groove;" bgcolor="black"><center>Client Login</td>
    
    							    <td width="127" style="color:white; background-color:black; border-width:1; border-color:rgb(21,16,16); border-style:groove;" bgcolor="black"><center>Skype</td>
    
    							    <td width="154" style="color:white; background-color:black; border-width:1; border-color:rgb(21,16,16); border-style:groove;" bgcolor="black"><center>ICQ</td>
    							    <td width="154" style="color:white; background-color:black; border-width:1; border-color:rgb(21,16,16); border-style:groove;" bgcolor="black"><center>EMail</td>
    							    <td width="154" style="color:white; background-color:black; border-width:1; border-color:rgb(21,16,16); border-style:groove;" bgcolor="black"><center>Phone</td>
    						            <td width="154" style="color:white; background-color:black; border-width:1; border-color:rgb(21,16,16); border-style:groove;" bgcolor="black"><center>Created</td>
    							    <td width="154" style="color:white; background-color:black; border-width:1; border-color:rgb(21,16,16); border-style:groove;" bgcolor="black"><center>Action</td>
    
    
    							</tr>
    <!--Pagination-->
    <?php	
    /////////////////
    	$limit = 30; //how many items to show per page
    	$targetpage = "Show_Users.php";//the name of this file
    /////////////////
    
    	$link = mysql_connect("localhost", "root", "qwerty");
    		mysql_select_db("ICMSS27", $link);
    		
    	
    	$tbl_name="Users";		
    	// How many adjacent pages should be shown on each side?
    	$adjacents = 10;
    	
    	/* 
    	   First get total number of rows in data table. 
    	   If you have a WHERE clause in your query, make sure you mirror it here.
    	*/
    	$query = "SELECT COUNT(*) as num FROM Users";
    	$total_pages = mysql_fetch_array(mysql_query($query));
    	$total_pages = $total_pages[num];
    	
    	/* Setup vars for query. */
    	
    	 								
    	$page = $_GET['page'];
    	if($page) 
    		$start = ($page - 1) * $limit; 			//first item to display on this page
    	else
    		$start = 0;								//if no page var is given, set start to 0
    	
    	/* Get data. */
    	$sql = "SELECT * FROM Users LIMIT $start, $limit";
    	$result = mysql_query($sql);
    	
    	/* Setup page vars for display. */
    	if ($page == 0) $page = 1;					//if no page var is given, default to 1.
    	$prev = $page - 1;							//previous page is page - 1
    	$next = $page + 1;							//next page is page + 1
    	$lastpage = ceil($total_pages/$limit);		//lastpage is = total pages / items per page, rounded up.
    	$lpm1 = $lastpage - 1;						//last page minus 1
    	
    	/* 
    		Now we apply our rules and draw the pagination object. 
    		We're actually saving the code to a variable in case we want to draw it more than once.
    	*/
    	$pagination = "";
    	if($lastpage > 1)
    	{	
    		$pagination .= "<div class=\"pagination\">";
    		//previous button
    		if ($page > 1) 
    			$pagination.= "<a href=\"$targetpage?page=$prev\"> << Previous</a>";
    		else
    			$pagination.= "<span class=\"disabled\"> << Previous</span>";	
    		
    		//pages	
    		if ($lastpage < 7 + ($adjacents * 2))	//not enough pages to bother breaking it up
    		{	
    			for ($counter = 1; $counter <= $lastpage; $counter++)
    			{
    				if ($counter == $page)
    					$pagination.= "<span class=\"current\">$counter</span>";
    				else
    					$pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";					
    			}
    		}
    		elseif($lastpage > 5 + ($adjacents * 2))	//enough pages to hide some
    		{
    			//close to beginning; only hide later pages
    			if($page < 1 + ($adjacents * 2))		
    			{
    				for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++)
    				{
    					if ($counter == $page)
    						$pagination.= "<span class=\"current\">$counter</span>";
    					else
    						$pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";					
    				}
    				$pagination.= "...";
    				$pagination.= "<a href=\"$targetpage?page=$lpm1\">$lpm1</a>";
    				$pagination.= "<a href=\"$targetpage?page=$lastpage\">$lastpage</a>";		
    			}
    			//in middle; hide some front and some back
    			elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2))
    			{
    				$pagination.= "<a href=\"$targetpage?page=1\">1</a>";
    				$pagination.= "<a href=\"$targetpage?page=2\">2</a>";
    				$pagination.= "...";
    				for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++)
    				{
    					if ($counter == $page)
    						$pagination.= "<span class=\"current\">$counter</span>";
    					else
    						$pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";					
    				}
    				$pagination.= "...";
    				$pagination.= "<a href=\"$targetpage?page=$lpm1\">$lpm1</a>";
    				$pagination.= "<a href=\"$targetpage?page=$lastpage\">$lastpage</a>";		
    			}
    			//close to end; only hide early pages
    			else
    			{
    				$pagination.= "<a href=\"$targetpage?page=1\">1</a>";
    				$pagination.= "<a href=\"$targetpage?page=2\">2</a>";
    				$pagination.= "...";
    				for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++)
    				{
    					if ($counter == $page)
    						$pagination.= "<span class=\"current\">$counter</span>";
    					else
    						$pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";					
    				}
    			}
    		}
    		
    		//next button
    		if ($page < $counter - 1) 
    			$pagination.= "<a href=\"$targetpage?page=$next\"> Next >></a>";
    		else
    			$pagination.= "<span class=\"disabled\"> Next >></span>";
    		$pagination.= "</div>\n";		
    	}   
    ?>
    
    <!--End of Pagination-->
    
    <?php  
    
    		   while($row = mysql_fetch_array($result))	{  ?> 
    
    
    							<tr bordercolordark="black" bordercolorlight="black" style="color:white; background-color:black; border-color:black;" bgcolor="black">
    	   						    <td width="40" style="color:white; background-color:black; border-width:1; border-color:rgb(21,16,16); border-style:groove;" bgcolor="black"><center>
    
    <?php 
    
    
    $ics++;
    echo $ics;
    
    ?> </td>  
    
    							    <td width="127" style="color:white; background-color:black; border-width:1; border-color:rgb(21,16,16); border-style:groove;" bgcolor="black"><center><?php echo $row['ClientNumber']; ?></td>
    
    							    <td width="127" style="color:white; background-color:black; border-width:1; border-color:rgb(21,16,16); border-style:groove;" bgcolor="black"><center><?php echo $row['IPAddress']; ?></td>
    
    							    <td width="127" style="color:white; background-color:black; border-width:1; border-color:rgb(21,16,16); border-style:groove;" bgcolor="black"><center><?php echo $row['ClientLogin']; ?></td>
    
    							    <td width="127" style="color:white; background-color:black; border-width:1; border-color:rgb(21,16,16); border-style:groove;" bgcolor="black"><center><?php echo $row['SkypeName']; ?></td>
    							    <td width="127" style="color:white; background-color:black; border-width:1; border-color:rgb(21,16,16); border-style:groove;" bgcolor="black"><center><?php echo $row['ICQNumber']; ?></td>
    							    <td width="127" style="color:white; background-color:black; border-width:1; border-color:rgb(21,16,16); border-style:groove;" bgcolor="black"><center><?php echo $row['EMail']; ?></td>
    							    <td width="127" style="color:white; background-color:black; border-width:1; border-color:rgb(21,16,16); border-style:groove;" bgcolor="black"><center><?php echo $row['Phonumber']; ?></td>
    							    <td width="127" style="color:white; background-color:black; font-size:10; border-width:1; border-color:rgb(21,16,16); border-style:groove;" bgcolor="black"><center><?php echo $row['created']; ?></td>
    
    
    							    <td width="154" style="color:white; background-color:black; border-width:1; border-color:rgb(21,16,16); border-style:groove;" bgcolor="black"><center>  <a href=Edit_User.php?id=<?php echo $row['ClientNumber']; ?>><font style='background:black; font-size:10; color:white;'><b>Edit</b></font></a>&nbsp<a href=Delete_User.php?cl=<?php echo $row['ClientNumber']; ?>><font style='background:black; font-size:10; color:white;'><b>Delete</b></font></a></td>
    
    							</tr>
    	
    <?php } ?>
    						  </table>
    
    						     </div>
    
    
    
    
    </table><div id="layerpagi" style="background-color:transparent; width:100%; height:29px; font-size:12; position:absolute; left:0px; top:610px; z-index:9;">
    <center><?=$pagination?>
    	</div>
    	
    	<?php  mysql_close($link);  ?>
    
    
    					   
    
    					</div>
    
    
          
       					 
    
    				<b class="b4f"></b><b class="b3f"></b><b class="b2f"></b><b class="b1f"></b>
    					 </div>
    <!--End of show users-->
    
    
    <!--End of workspace-->
    
    
    
    			    <div id="layer6" style="background-color:black; width:100%; height:30px; position:absolute; left:0px; bottom:0%; z-index:1;">
    
    			    </div>
    
    			</div>
    
    					
    
    
       </body>
    
      </html>

  4. #4
    Registered User tedych's Avatar
    Join Date: Nov:2003
    Location:
    Posts: 17,654
    !
    . .
    Red_Leader, , PHP .
    , " "?
    2 pagination?
    , - .
    -, <option> , $REQUEST $limit -. .
    , , .. -, - .
    . .

  5. #5
    _
    Join Date: Apr:2006
    Location: _
    Posts: 1,128
    a, .

    pagination
    17 10 pagindtion 11 17 while 10


    Code:
    
    <!--Pagination-->
    <?php	
    /////////////////
    	$limit = 30; //how many items to show per page
    	$targetpage = "Show_Users.php";//the name of this file
    /////////////////
    
    	$link = mysql_connect("localhost", "root", "qwerty");
    		mysql_select_db("ICMSS27", $link);
    		
    	
    	$tbl_name="Users";		
    	// How many adjacent pages should be shown on each side?
    	$adjacents = 10;
    	
    	/* 
    	   First get total number of rows in data table. 
    	   If you have a WHERE clause in your query, make sure you mirror it here.
    	*/
    	$query = "SELECT COUNT(*) as num FROM Users";
    	$total_pages = mysql_fetch_array(mysql_query($query));
    	$total_pages = $total_pages[num];
    	
    	/* Setup vars for query. */
    	
    	 								
    	$page = $_GET['page'];
    	if($page) 
    		$start = ($page - 1) * $limit; 			//first item to display on this page
    	else
    		$start = 0;								//if no page var is given, set start to 0
    	
    	/* Get data. */
    	$sql = "SELECT * FROM Users LIMIT $start, $limit";
    	$result = mysql_query($sql);
    	
    	/* Setup page vars for display. */
    	if ($page == 0) $page = 1;					//if no page var is given, default to 1.
    	$prev = $page - 1;							//previous page is page - 1
    	$next = $page + 1;							//next page is page + 1
    	$lastpage = ceil($total_pages/$limit);		//lastpage is = total pages / items per page, rounded up.
    	$lpm1 = $lastpage - 1;						//last page minus 1
    	
    	/* 
    		Now we apply our rules and draw the pagination object. 
    		We're actually saving the code to a variable in case we want to draw it more than once.
    	*/
    	$pagination = "";
    	if($lastpage > 1)
    	{	
    		$pagination .= "<div class=\"pagination\">";
    		//previous button
    		if ($page > 1) 
    			$pagination.= "<a href=\"$targetpage?page=$prev\"> << Previous</a>";
    		else
    			$pagination.= "<span class=\"disabled\"> << Previous</span>";	
    		
    		//pages	
    		if ($lastpage < 7 + ($adjacents * 2))	//not enough pages to bother breaking it up
    		{	
    			for ($counter = 1; $counter <= $lastpage; $counter++)
    			{
    				if ($counter == $page)
    					$pagination.= "<span class=\"current\">$counter</span>";
    				else
    					$pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";					
    			}
    		}
    		elseif($lastpage > 5 + ($adjacents * 2))	//enough pages to hide some
    		{
    			//close to beginning; only hide later pages
    			if($page < 1 + ($adjacents * 2))		
    			{
    				for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++)
    				{
    					if ($counter == $page)
    						$pagination.= "<span class=\"current\">$counter</span>";
    					else
    						$pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";					
    				}
    				$pagination.= "...";
    				$pagination.= "<a href=\"$targetpage?page=$lpm1\">$lpm1</a>";
    				$pagination.= "<a href=\"$targetpage?page=$lastpage\">$lastpage</a>";		
    			}
    			//in middle; hide some front and some back
    			elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2))
    			{
    				$pagination.= "<a href=\"$targetpage?page=1\">1</a>";
    				$pagination.= "<a href=\"$targetpage?page=2\">2</a>";
    				$pagination.= "...";
    				for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++)
    				{
    					if ($counter == $page)
    						$pagination.= "<span class=\"current\">$counter</span>";
    					else
    						$pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";					
    				}
    				$pagination.= "...";
    				$pagination.= "<a href=\"$targetpage?page=$lpm1\">$lpm1</a>";
    				$pagination.= "<a href=\"$targetpage?page=$lastpage\">$lastpage</a>";		
    			}
    			//close to end; only hide early pages
    			else
    			{
    				$pagination.= "<a href=\"$targetpage?page=1\">1</a>";
    				$pagination.= "<a href=\"$targetpage?page=2\">2</a>";
    				$pagination.= "...";
    				for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++)
    				{
    					if ($counter == $page)
    						$pagination.= "<span class=\"current\">$counter</span>";
    					else
    						$pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";					
    				}
    			}
    		}
    		
    		//next button
    		if ($page < $counter - 1) 
    			$pagination.= "<a href=\"$targetpage?page=$next\"> Next >></a>";
    		else
    			$pagination.= "<span class=\"disabled\"> Next >></span>";
    		$pagination.= "</div>\n";		
    	}   
    ?>
    
    <!--End of Pagination-->
    
    <?php  
    
    		   while($row = mysql_fetch_array($result))	{  ?> 
    
    
    							<tr bordercolordark="black" bordercolorlight="black" style="color:white; background-color:black; border-color:black;" bgcolor="black">
    	   						    <td width="40" style="color:white; background-color:black; border-width:1; border-color:rgb(21,16,16); border-style:groove;" bgcolor="black"><center><?php  
    
                
                       switch case          case
    
      
    $az=0;
    while($a < rows){
        
                       while ($row = mysql_fetch_array($result)) {
                                   echo "redove";     $az++;   echo  $az;   }  }
               
    
          ?> </td>  
    
    							    <td width="127" style="color:white; background-color:black; border-width:1; border-color:rgb(21,16,16); border-style:groove;" bgcolor="black"><center><?php echo $row['ClientNumber']; ?></td>
    
    							    <td width="127" style="color:white; background-color:black; border-width:1; border-color:rgb(21,16,16); border-style:groove;" bgcolor="black"><center><?php echo $row['IPAddress']; ?></td>
    
    							    <td width="127" style="color:white; background-color:black; border-width:1; border-color:rgb(21,16,16); border-style:groove;" bgcolor="black"><center><?php echo $row['ClientLogin']; ?></td>
    
    							    <td width="127" style="color:white; background-color:black; border-width:1; border-color:rgb(21,16,16); border-style:groove;" bgcolor="black"><center><?php echo $row['SkypeName']; ?></td>
    							    <td width="127" style="color:white; background-color:black; border-width:1; border-color:rgb(21,16,16); border-style:groove;" bgcolor="black"><center><?php echo $row['ICQNumber']; ?></td>
    							    <td width="127" style="color:white; background-color:black; border-width:1; border-color:rgb(21,16,16); border-style:groove;" bgcolor="black"><center><?php echo $row['EMail']; ?></td>
    							    <td width="127" style="color:white; background-color:black; border-width:1; border-color:rgb(21,16,16); border-style:groove;" bgcolor="black"><center><?php echo $row['Phonumber']; ?></td>
    							    <td width="127" style="color:white; background-color:black; font-size:10; border-width:1; border-color:rgb(21,16,16); border-style:groove;" bgcolor="black"><center><?php echo $row['created']; ?></td>
    
    
    							    <td width="154" style="color:white; background-color:black; border-width:1; border-color:rgb(21,16,16); border-style:groove;" bgcolor="black"><center>  <a href=Edit_User.php?id=<?php echo $row['ClientNumber']; ?>><font style='background:black; font-size:10; color:white;'><b>Edit</b></font></a>&nbsp<a href=Delete_User.php?cl=<?php echo $row['ClientNumber']; ?>><font style='background:black; font-size:10; color:white;'><b>Delete</b></font></a></td>
    
    							</tr>
    	
    <?php } ?>
    						  </table>
    
    						     </div>
    
    
    
    
    </table><div id="layerpagi" style="background-color:transparent; width:100%; height:29px; font-size:12; position:absolute; left:0px; top:610px; z-index:9;">
    <center><?=$pagination?>
    	</div>
    	
    	<?php  mysql_close($link);  ?>
    
    
    					   
    
    					</div>
    
    
          
       					 
    
    				<b class="b4f"></b><b class="b3f"></b><b class="b2f"></b><b class="b1f"></b>
    					 </div>
    <!--End of show users-->

    security - - 1
    Last edited by Red_Leader; 21st August 2009 at 00:19.

  6. #6
    ! vbTheKing's Avatar
    Join Date: Sep:2003
    Location:
    Posts: 4,138
    , while-a $i , while-a if ($i <= $page*$limit) { continue; }
    $page , , GET , $limit ( 10).

    , - , $page*$page_limit , if-a.
    ''? * *
    - !
    ...

  7. #7
    Registered User fly's Avatar
    Join Date: Jun:2005
    Location:
    Posts: 803

  8. #8
    hmm BornToDrink's Avatar
    Join Date: Aug:2005
    Location: .
    Posts: 11,573
    , .
    - dockera.com
    Hey, mother, I come bearing a gift. I'll give you a hint. It's in my diaper and it's not a toaster.
    .

  9. #9
    Bombera's Avatar
    Join Date: Jul:2001
    Location: 4EVA
    Posts: 13,833
    LIMIT MySQL .
    Code:
    SELECT * FROM `tablicata_ti` LIMIT x, y
    -, , . X ((_ -1) * _), Y _.
    EVGA X299 FTW K|i9-7960X@4.7|4x8 Patriot Viper Steel 4000|GTX 1660 Ti|970 EVO 1 TB|Seasonic Focus GX-1000|Xigmatek Elysium|
    Rampage IV Extreme BE|E5-1680v2@4.7|4x4 HyperX 1866|Cougar Aqua 240|GTX 1050 Ti|970 EVO 1/4 TB|CM 850 SilentPro|HAF-X|

  10. #10
    _
    Join Date: Apr:2006
    Location: _
    Posts: 1,128

    - id

    id name
    1 ime
    2 ime
    3 ime
    4 ime



    id name
    1 ime
    3 ime
    4 ime



    mysql

    id


  11. #11
    hmm BornToDrink's Avatar
    Join Date: Aug:2005
    Location: .
    Posts: 11,573
    - .
    Hey, mother, I come bearing a gift. I'll give you a hint. It's in my diaper and it's not a toaster.
    .

  12. #12
    Bombera's Avatar
    Join Date: Jul:2001
    Location: 4EVA
    Posts: 13,833
    ? , , , .
    , .

    .. , LIMIT. , . $start $limit. -, .
    Last edited by Bombera; 21st August 2009 at 13:35.
    EVGA X299 FTW K|i9-7960X@4.7|4x8 Patriot Viper Steel 4000|GTX 1660 Ti|970 EVO 1 TB|Seasonic Focus GX-1000|Xigmatek Elysium|
    Rampage IV Extreme BE|E5-1680v2@4.7|4x4 HyperX 1866|Cougar Aqua 240|GTX 1050 Ti|970 EVO 1/4 TB|CM 850 SilentPro|HAF-X|

  13. #13
    _
    Join Date: Apr:2006
    Location: _
    Posts: 1,128




    Code:
    <?php 	$ics = $start;
    
    		   while($row = mysql_fetch_array($result))	{  ?> 
    
    
    							<tr bordercolordark="black" bordercolorlight="black" style="color:white; background-color:black; border-color:black;" bgcolor="black">
    	   						    <td width="40" style="color:white; background-color:black; border-width:1; border-color:rgb(21,16,16); border-style:groove;" bgcolor="black"><center>
    
    <?php 
    $ics++;
    echo $ics;
    
    
    ?> </td>  
    
    							    <td width="127" style="color:white; background-color:black; border-width:1; border-color:rgb(21,16,16); border-style:groove;" bgcolor="black"><center><?php echo $row['ClientNumber']; ?></td>
    
    							    <td width="127" style="color:white; background-color:black; border-width:1; border-color:rgb(21,16,16); border-style:groove;" bgcolor="black"><center><?php echo $row['IPAddress']; ?></td>
    
    							    <td width="127" style="color:white; background-color:black; border-width:1; border-color:rgb(21,16,16); border-style:groove;" bgcolor="black"><center><?php echo $row['ClientLogin']; ?></td>
    
    							    <td width="127" style="color:white; background-color:black; border-width:1; border-color:rgb(21,16,16); border-style:groove;" bgcolor="black"><center><?php echo $row['SkypeName']; ?></td>
    							    <td width="127" style="color:white; background-color:black; border-width:1; border-color:rgb(21,16,16); border-style:groove;" bgcolor="black"><center><?php echo $row['ICQNumber']; ?></td>
    							    <td width="127" style="color:white; background-color:black; border-width:1; border-color:rgb(21,16,16); border-style:groove;" bgcolor="black"><center><?php echo $row['EMail']; ?></td>
    							    <td width="127" style="color:white; background-color:black; border-width:1; border-color:rgb(21,16,16); border-style:groove;" bgcolor="black"><center><?php echo $row['Phonumber']; ?></td>
    							    <td width="127" style="color:white; background-color:black; font-size:10; border-width:1; border-color:rgb(21,16,16); border-style:groove;" bgcolor="black"><center><?php echo $row['created']; ?></td>
    
    
    							    <td width="154" style="color:white; background-color:black; border-width:1; border-color:rgb(21,16,16); border-style:groove;" bgcolor="black"><center>  <a href=Edit_User.php?id=<?php echo $row['ClientNumber']; ?>><font style='background:black; font-size:10; color:white;'><b>Edit</b></font></a>&nbsp<a href=Delete_User.php?cl=<?php echo $row['ClientNumber']; ?>><font style='background:black; font-size:10; color:white;'><b>Delete</b></font></a></td>
    
    							</tr>
    	
    <?php } ?>

    $start mysql
    while

    ---------- 13:55 ---------- 13:47 ----------





    ---------- 23:36 ---------- 13:55 ----------

    ,

  14. #14
    TEKIL4O's Avatar
    Join Date: Feb:2007
    Location: Rousse/Sofia
    Posts: 341
    Code:
    <a href="link_to_page" target="_blank">  </a>
    <anchor>(<a>)

    P.S. . -
    EP 9NPA+ U (HR-05/IFX)| 4200+X2@2.8GHz (IFX-14) | 2x1GB KINGSTON (DDR430 3-4-3-6-1T@2.7V) | GB 8800GT (512MB) | WD6401AALS | CFT-750-14CS

  15. #15
    _
    Join Date: Apr:2006
    Location: _
    Posts: 1,128


    - javascript css
    Last edited by Red_Leader; 22nd August 2009 at 00:10.

  16. #16
    TEKIL4O's Avatar
    Join Date: Feb:2007
    Location: Rousse/Sofia
    Posts: 341
    CSS , . , . , , , ... onClick "self.location.href = 'link';" "window.open('...');"
    EP 9NPA+ U (HR-05/IFX)| 4200+X2@2.8GHz (IFX-14) | 2x1GB KINGSTON (DDR430 3-4-3-6-1T@2.7V) | GB 8800GT (512MB) | WD6401AALS | CFT-750-14CS

  17. #17
    _
    Join Date: Apr:2006
    Location: _
    Posts: 1,128


    php mysql

    1 ,


  18. #18
    a.k.a. Bibi Flower's Avatar
    Join Date: Aug:2006
    Location: Sofia, Bulgaria
    Posts: 562
    onclick <tr>.

  19. #19
    _
    Join Date: Apr:2006
    Location: _
    Posts: 1,128

    onclick="location=www.link.com"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 . .
iskamPC.com | mobility.BG | Bloody's Techblog | | 3D Vision Blog |