linkedin facebook linkedin facebook nod32

Data jadvalga ma’lumot qo`shish bo`limining admin panelini yaratish usuli

Muallif: Mengliyev Sh.

Qo`shilgan sana: 2016-02-10

Data jadvalga ma’lumot qo`shish bo`limining admin panelini yaratish usuli

Video darslik 

Biz biror bir ma’lumotni qayta ishlab uni axborot sifatida internetga joylashtiramiz buni quyidagi malumot_kiritish.php faylini yaratib olamiz buning uchun quyidagi kodni ko`chrib olamiz.

malumot_kiritish.php

<? include ("lock.php");  ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Darslik uchun yangi ma'lumot qo'shish</title>
<link href="style.css" rel="stylesheet" type="text/css">
<script src="ckeditor/ckeditor.js"></script>
</head>
<body>
<table width="690" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" class="main_border">
<tr>
<td class="left"> <p align=center> <b><i>Saytga ma'lumot  kiritish administrator bo`limi</i><b> </p></td>
</tr>
<tr>
<td><table width="690" border="0" cellspacing="0" cellpadding="0">
<tr>
<!--chapmenyuni include yo`rdamida chaqirib olish -->
<? include ("chapmenyu.php");  ?>     
<td valign="top">
<form name="form1" method="post" action="bazaga_malumot_yuborish.php">
<p>
<label>Cat mavzu toifa bilgini tanlang<br>
<select name="cat">
<?
$result = mysql_query("SELECT title,id FROM cat",$db);
if (!$result)
{
echo "<p>Tanlangan so'rov bazaga yuborilmadi. Adminstratorga xat yozing admin@tami.uz. <br> <strong>Kodda xato:</strong></p>";
exit(mysql_error());
}
if (mysql_num_rows($result) > 0)
{
$myrow = mysql_fetch_array($result);
do
{
printf ("<option value='%s'>%s</option>",$myrow["id"],$myrow["title"]);
}
while ($myrow = mysql_fetch_array($result));
}
else
{
echo "<p>Axborot so`rovi bazaga saqlanmadi bazada jadval yo`q.</p>";
exit();
}
?>
</select>
</label>
</p>        
<p>
<label>Matn sahifa nomini kiriting<br>
<input type="text" name="title" id="title" size="75">
</label>
</p>
<p>
<label>Matn sahifa qisqa nom kiriting<br>
<input type="text" name="meta_d" id="meta_d" size="75">
</label>
</p>
<p>
<label>Matn sahifaga kalit so'z kiriting<br>
<input type="text" name="meta_k" id="meta_k" size="75">
</label>
</p>
<p>
<label>Sanani kiriting<br>
<input name="date" type="text" id="date" value="<?php $date = date("Y-m-d"); echo $date; ?>">
</label>
</p>
<p>
<label>Ma'lumotning to'liq bayon kiriting
<textarea name="text" id="text" cols="40" rows="20"></textarea>
<script>CKEDITOR.replace( 'text' );</script>
</label>
</p>
<p>
<label>Muallif nomini kiriting<br>
<input type="text" name="author" id="author">
</label>
</p>
<p>
<label>Kichkina rasm manzili kiritish<br>
<input type="text" name="img" id="img">
</label>
</p>
<p>
<label>
<input type="submit" name="submit" id="submit" value="Sahifani bazaga kiritish">
</label>
</p>
</form>
</td>
</tr>
</table></td>
</tr>
<tr>
<td class="left"><p align=center>Saytga ma'lumot  kiritish administrator quyi bo`limi</p></td>
</tr>
</table>
</body>
</html>

Malumotni data jadvalga yuborish bo`limi bazaga_malumot_yuborish.php quyida php kodi keltirilgan.
bazaga_malumot_yuborish.php

<?php
include ("lock.php");
include ("baza.php");
if (isset($_POST['title']))      
{
$title = $_POST['title'];

if ($title == '')
{
unset($title);

}
if (isset($_POST['meta_d']))      {$meta_d = $_POST['meta_d']; if ($meta_d == '') {unset($meta_d);}}
if (isset($_POST['meta_k']))      {$meta_k = $_POST['meta_k']; if ($meta_k == '') {unset($meta_k);}}
if (isset($_POST['date']))        {$date = $_POST['date']; if ($date == '') {unset($date);}}
if (isset($_POST['text']))        {$text = $_POST['text']; if ($text == '') {unset($text);}}
if (isset($_POST['author']))      {$author = $_POST['author']; if ($author == '') {unset($author);}}
if (isset($_POST['img']))      {$img = $_POST['img']; if ($img == '') {unset($img);}}
if (isset($_POST['cat']))      {$cat = $_POST['cat']; if ($cat == '') {unset($cat);}}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Malumotni data bazaga yuborish</title>
<link href="style.css" rel="stylesheet" type="text/css">
</head>
<body>
<table width="690" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" class="main_border">
<tr>
<td class="left"> <p align=center> <b><i>Saytga ma'lumot  kiritish administrator bo`limi</i><b> </p></td>
</tr>
<tr>
<td><table width="690" border="0" cellspacing="0" cellpadding="0">
<tr>
<!--chapmenyuni include yo`rdamida chaqirib olish -->
<? include ("chapmenyu.php");  ?>    
<td valign="top">
<?php
if (isset($title) && isset($meta_d) && isset($meta_k) && isset($date) && isset($text) && isset($author) && isset($img) && isset($cat) )
{
/* Ma`lumotni data jadvalga yozish */
$result = mysql_query ("INSERT INTO data (title,meta_d,meta_k,date,text,author,mini_img,cat) VALUES ('$title', '$meta_d','$meta_k','$date','$text','$author','$img','$cat')");
if ($result == 'true') {echo "<p>Ma`lumot bazaga qo`shildi!</p>";}
else {echo "<p>Ma`lumot bazaga qo`shilmadi!</p>";}
}                
else
{
echo "<p>Axborot so`rovi bazaga saqlanmadi bazada jadval yo`q.</p>";
}
?>
</td>
</tr>
</table></td>
</tr>
<tr>
<td class="left"><p align=center>Saytga ma'lumot  kiritish administrator quyi bo`limi</p></td>
</tr>
</table>
</body>
</html>

319 marta o`qildi.

Foydalanuvchi ismi: hhhhhhhhhhh
Qo`shilgan sana: 2016-02-24

hhhhhhhhhhhh

Parol:
Eslab qolish.


Ro`yhatdan o`tish

testing

+998915878681

Siz o`z maxsulotingizni 3D reklama ko`rinishda bo`lishini xohlaysizmi? Unda xamkorlik qilamiz.

3D Reklama


Рейтинг@Mail.ru
Рейтинг@Mail.ru

Besucherzahler
счетчик посещений