منتديات phpBBArabia

كود: تحديد الكل

<?php  
	include('easytemplate.php');
	$con=mysql_connect("localhost","root","=");  //SQL??????? ?? .  
	  if(!$con)  
	  {  
	   die('can not connect'.mysql_error());  
	  }  
		mysql_select_db( site , $con );  

		$result = mysql_query("select * from post");  
		$num = mysql_num_rows($result); 
		$i=0;  

  while( $i < $num )  {  
   		$post_id  = mysql_result( $result , $i , "post_id"    );  
		$title = mysql_result( $result , $i , "title" );  
		$data = mysql_result( $result , $i , "data" );  
	   ++$i;  
  }  
    
	$tmpl = new EasyTemplate('style','cache');
	print $tmpl->display('body/showpost_body.html');
	mysql_close($con);  
 ?>

كود: تحديد الكل

   <tr>
   <td width='5%'>{post_id}</td> 
   <td width='44%'>{title} </td> 
   <td width='20%'>{data}</td> 
   <td width='10%'> <a href='edit.php?id=$post_id'> [Edit] </a> </td>  
   <td width='10%'> <a href='del.php?id=$post_id'>[delete] </a> </td> 
   </tr> 
  </table>

كود: تحديد الكل

<?
for($i=0;$i<=5;$i++){
    $rows[] = array('id'=>$i,'name'=>'name'.$i);
}
?> 

كود: تحديد الكل

html
<LOOP NAME="{rows}">
{rows.id} - {rows.name}
</LOOP>
</IF> 

كود: تحديد الكل

result
1 - name1
2 - name2
3 - name3
4 - name4
5 - name5 

كود: تحديد الكل

	$post_all = "SELECT forum_id , name,img,des FROM forum WHERE forum_id= ???" ;

كود: تحديد الكل

<?php

session_start();
if(!$_SESSION['username']){ 
	echo "<font color=\"#FF0000\"><b>please log in <META HTTP-EQUIV=\"refresh\" CONTENT=\"1; URL=login.php\"></b></font>";
exit;
}
	include('easytemplate.php');
	$con=mysql_connect("localhost","root","");
	  if(!$con){  
	   die('can not connect'.mysql_error());  
	  } 
	  	mysql_select_db( site , $con ); 


if (isset($_POST['newpost'])){
if($title == "" || $img == "" || $data == ""  ) { 
 die("<b>??? ???? ???/???? ?????</b>");
    }  
	$sql="INSERT INTO post (title, img, data, forum_id) VALUES ('$_POST[title]','$_POST[img]','$_POST[data]','$_POST[forum_id]')";
		if (!mysql_query($sql,$con)) { die('Error: ' . mysql_error()); }	
	$post_id = "SELECT post_id FROM post  ORDER BY post_id DESC LIMIT 1" ;

}
 
if (isset($_POST['edit'])){

if($title == "" || $data == "" || $img_post == ""  ) { 
     die("<b>??? ???? ???/???? ?????</b>");  
   }  
   $query_post2 = "update post set title='$title', img='$img_post',data='$data' where post_id='$post_id'";
   mysql_query($query_post2);  
   
   $query_forum2 = "update forum set name='$name', des='$des', img='$img_forum' where forum_id='$forum_id'";
   mysql_query($query_forum2); 
}	
    $tmpl = new EasyTemplate('style','cache');
	print $tmpl->display('body/inserted_body.html');
	mysql_close($con);
 ?>

كود: تحديد الكل

<INCLUDE NAME="body/header_body.html">
	<table border="0" width="100%" bordercolorlight="#000000" style="border-collapse: collapse" cellpadding="4">
		<tr>
			<td>
						<IF NAME="{newpost}">
			 <p align="center">?? ????? ??????? ?????</p>
			<p align="center"><LOOP NAME="{rows}" SQL="{post_id}" LIMIT="1"><a href="showpost.php?id={rows.post_id}">???? ??? ??????? ???????</a></LOOP></p>
			</IF>
			<IF NAME="{edit}">
			<p align="center">?? ????? ??????? ?????</p><p align="center"><a href="showpost.php?id={post_id}">???? ??? ??????? ???????</a></p>
			</IF>
  		   	</td>
		</tr> 

	</table>
<INCLUDE NAME="body/footer_body.html">

 

كود: تحديد الكل

<?php

session_start();
if(!$_SESSION['username']){ 
	echo "<font color=\"#FF0000\"><b>please log in <META HTTP-EQUIV=\"refresh\" CONTENT=\"1; URL=login.php\"></b></font>";
exit;
}
 	include('../config.php');
 	include('../easytemplate.php');
	$con = mysql_connect("$hostname","$user","$pass");
	  if(!$con){  
	   die('can not connect'.mysql_error());  
	  } 
	mysql_select_db($db_name,$con);


if (isset($_POST['newpost'])){
if($title == "" || $img == "" || $data == ""  ) { 
 die("<b>??? ???? ???/???? ?????</b>");
    }  
	$sql="INSERT INTO post (title, img, small_data, data, forum_id) VALUES ('$_POST[title]','$_POST[img]','$_POST[small_data]','$_POST[data]','$_POST[forum_id]')";
		if (!mysql_query($sql,$con)) { die('Error: ' . mysql_error()); }	
	$post_id = "SELECT post_id FROM post  ORDER BY post_id DESC LIMIT 1" ;
}
 
if (isset($_POST['edit'])){

if($title == "" || $data == "" || $img == "") { 
     die("<b>??? ???? ???/???? ?????</b>");  
   }  
   $query_post2 = "update post set title='$title', small_data = '$small_data', img='$img',data='$data' ,forum_id='$forum_id' where post_id='$post_id'";
   mysql_query($query_post2);  
   
}	
    $tmpl = new EasyTemplate('style','cache');
	print $tmpl->display('body/inserted_body.html');
	mysql_close($con);
 ?>