| عضو فعال
تاريخ الانتساب: 13-03-2008
مشاركات: 504
مستوى السمعة : 3 |  عملت صفحة تعديل بيانات بس ما بتضبط
السلام عليكم
اخواني انا عملت صفحة خاصه بتعديل البيانات وهيا كالتالي
صفحة استدعاء البيانات كود PHP: <?php /*session_start();
if($_SESSION["login"]!= "true"){
header("location:../Adminpc/index.php");
}
*/
/**
* @author Khaled A Almallahi
* @copyright 2009
*/
include("../config.php");
$tbl_name="art"; // Table name
$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);
?>
<table width="400" border="0" align="center" cellpadding="0" cellspacing="1">
<tr>
<td>
<table width="400" border="1" cellspacing="0" cellpadding="3">
<tr>
<td colspan="4"><div align="center">التعديل على مقال </div></td>
</tr>
<tr>
<td align="center"><strong>عنوان المقال </strong></td>
<td align="center"><strong>قسم المقال </strong></td>
<td align="center"><strong>Update</strong></td>
</tr>
<?php
while($rows=mysql_fetch_array($result)){
?>
<tr>
<td><? echo $rows['art_title']; ?></td>
<td><? echo $rows['catid']; ?></td>
<td align="center"><a href="update.php?id=<? echo $rows['art_id']; ?>">update</a></td>
</tr>
<?php
}
?>
</table>
</td>
</tr>
</table>
<?php
mysql_close();
?> صفحة التعديل كود PHP: <?php /* session_start();
if($_SESSION["login"]!= "true"){
header("location:../Admincp/index.php");
}
/**
* @author Khaled A Almallahi
* @copyright 2009
*/
include ('../config.php');
include ('../function.php');
$art_id=$_GET['art_id'];
$sql="SELECT * FROM art WHERE art_id='$art_id'";
$result=mysql_query($sql);
$rows=mysql_fetch_array($result);
?>
<html dir="rtl">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1256">
<title>لوحة التحكم || اضافة مقال جديد</title>
<style type="text/css">
<!--
.style1 {
color: #FFFFFF;
font-weight: bold;
font-family: Tahoma;
}
.style3 {color: #FF6600}
.style4 {font-family: Tahoma}
.style9 {color: #FF6600; font-weight: bold; font-family: Tahoma; font-size: 12px; }
.style10 {font-size: 12px}
body {
background-image: url(../images/img01.jpg);
}
-->
</style>
</head>
<body>
<form name="addinmarq" method="POST" action="update_ac.php" enctype="multipart/form-data">
<div align="center">
<p> </p>
<table width="55%" border="0" cellpadding="0" cellspacing="0" bgcolor="#F5F5F5" dir="rtl" class="mytable" id="table1">
<tr>
<td colspan="3" align="center" bordercolor="#006633" background="../images/footer.jpg" bgcolor="#EBEBEB" class="backtablemun">التعديل على المقال <span class="style1"></span></td>
<td align="center" bordercolor="#006633" class="subsub" width="0%"> </td>
</tr>
<tr>
<td width="10%" align="center" bordercolor="#006633" class="subsub"><span class="style9">
العنوان</span></td>
<td align="center" bordercolor="#006633" class="subsub" width="1%">
:</td>
<td align="center" class="submun" bordercolor="#006633" width="89%">
<input name="name" type="text" id="name" value="<? echo $rows['art_title']; ?>"></td>
</tr>
<tr>
<td width="10%" align="center" bordercolor="#006633" class="subsub style3 style4 style10"> </td>
<td align="center" class="submun" bordercolor="#006633" width="1%"> </td>
<td align="center" bordercolor="#006633" class="subsub" width="89%"> </td>
</tr>
<tr>
<td width="10%" align="center" bordercolor="#006633" class="subsub"><span class="style9">
التفاصيل</span></td>
<td align="center" bordercolor="#006633" class="subsub" width="1%">
:</td>
<td align="center" class="submun" bordercolor="#006633" width="89%">
<textarea name="message" cols="40" rows="10" class="style9" id="txtDetails" value="<? echo $rows['art_supject']; ?>"></textarea></td>
</tr>
<tr>
<td width="10%" align="center" bordercolor="#006633" class="subsub style3 style4 style10"> </td>
<td align="center" bordercolor="#006633" class="subsub" width="1%"> </td>
<td align="center" class="submun" bordercolor="#006633" width="89%"> </td>
</tr>
<tr>
<td width="10%" align="center" bordercolor="#006633" class="subsub"><span class="style9">القسم</span></td>
<td align="center" bordercolor="#006633" class="subsub" width="1%">
:</td>
<td align="center" class="submun" bordercolor="#006633" width="89%"><label>
<select name="catid" id="catid">
<?
$result=GetAllCat();
while($row=mysql_fetch_array($result)){
echo "<option value=".$row["id"].">".$row["title_cat"]."</option>";
}
?>
</select>
</label> </td>
</tr>
<tr>
<td width="10%" align="center" bordercolor="#006633" class="subsub style3 style4 style10"> </td>
<td align="center" class="submun" bordercolor="#006633" width="1%"> </td>
<td align="center" bordercolor="#006633" class="subsub" width="89%"> </td>
</tr>
<tr>
<td width="10%" align="center" bordercolor="#006633" class="subsub"><span class="style9">
الصورة</span></td>
<td align="center" bordercolor="#006633" class="subsub" width="1%">
:</td>
<td align="center" class="submun" bordercolor="#006633" width="89%">
<INPUT NAME="pic" TYPE="file" size="50"></td>
</tr>
</table>
</div>
<p align="center"><td><input name="id" type="hidden" id="id" value="<? echo $rows['art_id']; ?>"></td>
<td align="center"><input type="submit" name="Submit" value=".: تعديل :."></td>
</p>
</form>
</body>
</html> صفحة التاكيد والموافقه على التعديل كود PHP: <?php
include ('../config.php');
include ('../function.php');
$tbl_name="art"; // Table nam/e
// update data in mysql database
$sql="UPDATE `$tbl_name` SET
`art_title` = '$title',
`art_supject` = '$message',
`file_name` = '$newname',
`file_url` = '$imgurle',
`file_key` = '$uniq',
`file_tybe` = '$x',
`file_date` = '$time'
WHERE `art_id` = $art_id ;";
$result=mysql_query($sql);
// if successfully updated.
if($result){
echo "Successful";
echo "<BR>";
echo "<a href='list_records.php'>View result</a>";
}
else {
echo "ERROR";
}
?> المشكلة انو ما بيعدل حتى برضوا انو ما بيعمل استدعاء البيانات لما اضغط على كلمة تعديل
وهي الجدول الخاص كود PHP: -- phpMyAdmin SQL Dump
-- version 2.10.3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Mar 31, 2009 at 02:28 AM
-- Server version: 5.0.51
-- PHP Version: 5.2.6
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `art`
--
-- --------------------------------------------------------
--
-- Table structure for table `art`
--
CREATE TABLE `art` (
`art_id` mediumint(11) NOT NULL auto_increment,
`art_title` varchar(50) NOT NULL,
`art_supject` longtext NOT NULL,
`catid` int(100) NOT NULL,
`file_name` varchar(50) NOT NULL,
`file_url` varchar(50) NOT NULL,
`file_key` varchar(50) NOT NULL,
`file_tybe` varchar(50) NOT NULL,
`file_date` varchar(50) NOT NULL,
PRIMARY KEY (`art_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;
--
-- Dumping data for table `art`
--
INSERT INTO `art` VALUES (1, 'hhhhhh', 'hhhhhhhhhhhhhhhhhhhhhhh', 1, '33626d2388.jpg', 'uploads/33626d2388.jpg', '33626d2388', 'jpg', ' 2009 / Mar / 31');
INSERT INTO `art` VALUES (2, 'mmm', 'mmmmmmmm', 2, 'fae5f8ba4d.jpg', 'uploads/fae5f8ba4d.jpg', 'fae5f8ba4d', 'jpg', ' 2009 / Mar / 31');
INSERT INTO `art` VALUES (3, 'nnn', 'nnn', 1, '503b1ad4b0.jpg', 'uploads/503b1ad4b0.jpg', '503b1ad4b0', 'jpg', ' 2009 / Mar / 31');
INSERT INTO `art` VALUES (4, 'hhhhhhhhh', 'hhhhhhhhhhhhh', 2, '72b7e848af.jpg', 'uploads/72b7e848af.jpg', '72b7e848af', 'jpg', ' 2009 / Mar / 31');
INSERT INTO `art` VALUES (5, 'hhhhhhhhhh', 'hhhhhhhhhhhhhhhhhhhhhhhhhhhhhh', 1, '01c716a3e8.jpg', 'uploads/01c716a3e8.jpg', '01c716a3e8', 'jpg', ' 2009 / Mar / 31');
INSERT INTO `art` VALUES (6, 'mmmmmmmmm', 'mmmmmmmmmmmmmmmmmmmmmmmmmmmmmm', 1, '0fb1894068.JPG', 'uploads/0fb1894068.JPG', '0fb1894068', 'JPG', ' 2009 / Mar / 31');
INSERT INTO `art` VALUES (9, 'jjjjjjjjjjjjjjj', 'jjjjjjjjjjjjjjjjjjjjjjjjjjj', 1, '8becdb7448.JPG', 'uploads/8becdb7448.JPG', '8becdb7448', 'JPG', ' 2009 / Mar / 31');
INSERT INTO `art` VALUES (10, 'jjffffffffff', 'ffffffffffffffffffffffff', 1, '97abb9637c.JPG', 'uploads/97abb9637c.JPG', '97abb9637c', 'JPG', ' 2009 / Mar / 31');
INSERT INTO `art` VALUES (11, 'sssssssssss', 'sssssssssssssssssssssss', 1, '43a52796fd.jpg', 'uploads/43a52796fd.jpg', '43a52796fd', 'jpg', ' 2009 / Mar / 31');
اين المشكلة بتكون
|
29-03-2009, 02:30 PM
عادي
مواضيع ذات صلة 
