Teknoloji Haberleri
Bu konudaki kullanıcılar: 1 misafir
2
Cevap 1025
Tıklama 0
Öne Çıkarma
Cevap 1025
Tıklama 0
Öne Çıkarma
1. sayfa
-
ürün ekle.php sorun
1. sayfa
DH Mobil uygulaması ile devam edin.
Mobil tarayıcınız ile mümkün olanların yanı sıra, birçok yeni ve faydalı özelliğe erişin.
Gizle ve güncelleme çıkana kadar tekrar gösterme.
<?php require_once('../Connections/baglan.php'); ?>
<?php
//initialize the session
if (!isset($_SESSION)) {
session_start();
}
// ** Logout the current user. **
$logoutAction = $_SERVER['PHP_SELF']."?doLogout=true";
if ((isset($_SERVER['QUERY_STRING'])) && ($_SERVER['QUERY_STRING'] != "")){
$logoutAction .="&". htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_GET['doLogout'])) &&($_GET['doLogout']=="true")){
//to fully log out a visitor we need to clear the session varialbles
$_SESSION['MM_Username'] = NULL;
$_SESSION['MM_UserGroup'] = NULL;
$_SESSION['PrevUrl'] = NULL;
unset($_SESSION['MM_Username']);
unset($_SESSION['MM_UserGroup']);
unset($_SESSION['PrevUrl']);
$logoutGoTo = "index.php";
if ($logoutGoTo) {
header("Location: $logoutGoTo");
exit;
}
}
?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
function method2($str,$debug=false){
#$str = (utf8_decode(utf8_encode($str)));
$str = addslashes($str);
$str = htmlspecialchars($str);
#$str = htmlentities($str);
return ($str);
}
$editFormAction = $_SERVER['PHP_SELF'];
if(isset($_POST["MM_insert"])) {
include('perma.php');
$baslik = method2($_POST['baslik']);
$icerik = method2($_POST['icerik']);
$kat_id = method2($_POST['kat_id']);
$baslik_seo = permayap($baslik);
$SORGUSU = "INSERT INTO urunler (baslik,baslik_seo,icerik,kat_id) VALUES ('".$baslik."','".$baslik_seo."','".$icerik."','".$kat_id."')";
$sorgu = mysql_query($SORGUSU) or die($SORGUSU);
}
if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1")) {
$updateSQL = sprintf("UPDATE kategoriler SET baslik=%s, baslik_seo=%s WHERE id=%s",
GetSQLValueString($_POST['baslik'], "text"),
GetSQLValueString($_POST['baslik_seo'], "text"),
GetSQLValueString($_POST['id'], "int"));
mysql_select_db($database_baglan, $baglan);
$sorgu = mysql_query($updateSQL, $baglan) or die(mysql_error());
$updateGoTo = "kategori_duzenle.php";
if (isset($_SERVER['QUERY_STRING'])) {
$updateGoTo .= (strpos($updateGoTo, '?')) ? "&" : "?";
$updateGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $updateGoTo));
}
mysql_select_db($database_baglan, $baglan);
$query_ayarlar = "SELECT * FROM ayarlar ORDER BY id ASC";
$ayarlar = mysql_query($query_ayarlar, $baglan) or die(mysql_error());
$row_ayarlar = mysql_fetch_assoc($ayarlar);
$totalRows_ayarlar = mysql_num_rows($ayarlar);
mysql_select_db($database_baglan, $baglan);
$query_kategori = "SELECT * FROM kategoriler ORDER BY id ASC";
$kategori = mysql_query($query_kategori, $baglan) or die(mysql_error());
$row_kategori = mysql_fetch_assoc($kategori);
$totalRows_kategori = mysql_num_rows($kategori);
?>
<?php
if ( isset($_POST['form1']) ){
// 1. form işlemleri..
}
else if ( isset($_POST['form2']) ){
// 2. form işlemleri..
}
?>
<!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">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>YSM Bilişim Firma Sitesi</title>
<!-- CSS -->
<!-- Reset Stylesheet -->
<link rel="stylesheet" href="resources/css/reset.css" type="text/css" media="screen" />
<!-- Main Stylesheet -->
<link rel="stylesheet" href="resources/css/style.css" type="text/css" media="screen" />
<!-- Invalid Stylesheet. This makes stuff look pretty. Remove it if you want the CSS completely valid -->
<link rel="stylesheet" href="resources/css/invalid.css" type="text/css" media="screen" />
<!-- Colour Schemes
Default colour scheme is green. Uncomment prefered stylesheet to use it.
<link rel="stylesheet" href="resources/css/blue.css" type="text/css" media="screen" />
<link rel="stylesheet" href="resources/css/red.css" type="text/css" media="screen" />
-->
<!-- Internet Explorer Fixes Stylesheet -->
<!--[if lte IE 7]>
<link rel="stylesheet" href="resources/css/ie.css" type="text/css" media="screen" />
<![endif]-->
<!-- Javascripts -->
<!-- jQuery -->
<script type="text/javascript" src="resources/scripts/jquery-1.3.2.min.js"></script>
<!-- jQuery Configuration -->
<script type="text/javascript" src="resources/scripts/simpla.jquery.configuration.js"></script>
<!-- Facebox jQuery Plugin -->
<script type="text/javascript" src="resources/scripts/facebox.js"></script>
<!-- jQuery WYSIWYG Plugin -->
<script type="text/javascript" src="resources/scripts/jquery.wysiwyg.js"></script>
<!-- Internet Explorer .png-fix -->
<!--[if IE 6]>
<script type="text/javascript" src="resources/scripts/DD_belatedPNG_0.0.7a.js"></script>
<script type="text/javascript">
DD_belatedPNG.fix('.png_bg, img, li');
</script>
<![endif]-->
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
<script src="ckeditor/ckeditor.js"></script>
<script src="ckeditor/adapters/jquery.js"></script>
<script type="text/javascript">
$( document ).ready( function() {
$( 'textarea#icerik' ).ckeditor();
} );
</script>
<script type="text/javascript">
function alan_ekle(){
var s='</br><input type="file" name="Resim[]" id="file" />'; resim=document.getElementById('kapsar');
resim.innerHTML = resim.innerHTML + s;
}
</script>
<script type="text/javascript">
function alan_ekle(){
var s='</br><input type="file" name="Resim" id="file" />'; resim=document.getElementById('kapsar');
resim.innerHTML = resim.innerHTML + s;
}
</script>
</head>
<body>
<div id="body-wrapper"> <!-- Wrapper for the radial gradient background -->
<div id="sidebar"><div id="sidebar-wrapper"> <!-- Sidebar with logo and menu -->
<h1 id="sidebar-title"><a data-test="test" rel="nofollow" style="word-wrap: break-word; text-decoration: underline;" target="_blank" onclick="return dhExternalLinkRedirect(this)" href="/ExternalLinkRedirect?module=pgdcode&messageId=89496019&url=#" data-href="#">Simpla Admin</a></h1>
<!-- Logo (221px wide) -->
<a data-test="test" rel="nofollow" style="word-wrap: break-word; text-decoration: underline;" target="_blank" onclick="return dhExternalLinkRedirect(this)" href="/ExternalLinkRedirect?module=pgdcode&messageId=89496019&url=#" data-href="#"><img id="logo" src="resources/images/logo.png" alt="Simpla Admin logo" /></a>
<!-- Sidebar Profile links -->
<div id="profile-links">
Hoşgeldiniz, <a data-test="test" rel="nofollow" style="word-wrap: break-word; text-decoration: underline;" target="_blank" onclick="return dhExternalLinkRedirect(this)" href="/ExternalLinkRedirect?module=pgdcode&messageId=89496019&url=" title="Admin" data-href="" title="Admin"><?php echo $row_ayarlar['ad']; ?></a><br />
<br />
<a data-test="test" rel="nofollow" style="word-wrap: break-word; text-decoration: underline;" target="_blank" onclick="return dhExternalLinkRedirect(this)" href="/ExternalLinkRedirect?module=pgdcode&messageId=89496019&url=<?php echo $logoutAction ?>" title="Yönetim Paneli Çıkış" data-href="<?php echo $logoutAction ?>" title="Yönetim Paneli Çıkış">Sistemden Çıkış</a> </div>
<ul id="main-nav"> <!-- Accordion Menu -->
<li>
<a href="admin.php" class="nav-top-item no-submenu"> <!-- Add the class "no-submenu" to menu items with no sub menu -->
Anasayfa</a>
</li>
<li>
<a href="#" class="nav-top-item"> <!-- Add the class "current" to current menu item -->
Firma Sayfaları
</a>
<ul>
<li><a data-test="test" rel="nofollow" style="word-wrap: break-word; text-decoration: underline;" target="_blank" onclick="return dhExternalLinkRedirect(this)" href="/ExternalLinkRedirect?module=pgdcode&messageId=89496019&url=#" data-href="#">Hakkımızda</a></li>
<li><a data-test="test" rel="nofollow" style="word-wrap: break-word; text-decoration: underline;" target="_blank" onclick="return dhExternalLinkRedirect(this)" href="/ExternalLinkRedirect?module=pgdcode&messageId=89496019&url=#" data-href="#">Misyon</a></li>
<li><a data-test="test" rel="nofollow" style="word-wrap: break-word; text-decoration: underline;" target="_blank" onclick="return dhExternalLinkRedirect(this)" href="/ExternalLinkRedirect?module=pgdcode&messageId=89496019&url=#" data-href="#">Gizlilik</a></li>
<li><a data-test="test" rel="nofollow" style="word-wrap: break-word; text-decoration: underline;" target="_blank" onclick="return dhExternalLinkRedirect(this)" href="/ExternalLinkRedirect?module=pgdcode&messageId=89496019&url=#" data-href="#">Belgeler</a></li>
</ul>
</li>
<li>
<a href="#" class="nav-top-item">
Referanslar
</a>
<ul>
<li><a data-test="test" rel="nofollow" style="word-wrap: break-word; text-decoration: underline;" target="_blank" onclick="return dhExternalLinkRedirect(this)" href="/ExternalLinkRedirect?module=pgdcode&messageId=89496019&url=#" data-href="#">Yeni Referans Ekle</a></li>
<li><a data-test="test" rel="nofollow" style="word-wrap: break-word; text-decoration: underline;" target="_blank" onclick="return dhExternalLinkRedirect(this)" href="/ExternalLinkRedirect?module=pgdcode&messageId=89496019&url=#" data-href="#">Referanslarımız</a></li>
</ul>
</li>
<li>
<a href="#" class="nav-top-item">
Manşetler
</a>
<ul>
<li><a data-test="test" rel="nofollow" style="word-wrap: break-word; text-decoration: underline;" target="_blank" onclick="return dhExternalLinkRedirect(this)" href="/ExternalLinkRedirect?module=pgdcode&messageId=89496019&url=#" data-href="#">Manşetler</a></li>
<li><a data-test="test" rel="nofollow" style="word-wrap: break-word; text-decoration: underline;" target="_blank" onclick="return dhExternalLinkRedirect(this)" href="/ExternalLinkRedirect?module=pgdcode&messageId=89496019&url=#" data-href="#">Yeni Manşet Ekle</a></li>
</ul>
</li>
<li>
<a href="" class="nav-top-item current">
Ürünler
</a>
<ul>
<li><a data-test="test" rel="nofollow" style="word-wrap: break-word; text-decoration: underline;" target="_blank" onclick="return dhExternalLinkRedirect(this)" href="/ExternalLinkRedirect?module=pgdcode&messageId=89496019&url=kategoriler.php" data-href="kategoriler.php">Ürün Kategorileri</a></li>
<li><a data-test="test" rel="nofollow" style="word-wrap: break-word; text-decoration: underline;" target="_blank" onclick="return dhExternalLinkRedirect(this)" href="/ExternalLinkRedirect?module=pgdcode&messageId=89496019&url=kategori_ekle.php" data-href="kategori_ekle.php">Yeni Ürün Kategorisi Ekle</a></li>
<li><a data-test="test" rel="nofollow" style="word-wrap: break-word; text-decoration: underline;" target="_blank" onclick="return dhExternalLinkRedirect(this)" href="/ExternalLinkRedirect?module=pgdcode&messageId=89496019&url=urunler.php" data-href="urunler.php">Ürünler</a></li>
<li><a data-test="test" rel="nofollow" style="word-wrap: break-word; text-decoration: underline;" target="_blank" onclick="return dhExternalLinkRedirect(this)" href="/ExternalLinkRedirect?module=pgdcode&messageId=89496019&url=urun_ekle.php" data-href="urun_ekle.php">Yeni Ürün Ekle</a></li>
</ul>
</li>
<li>
<a href="#" class="nav-top-item">
Hizmetler
</a>
<ul>
<li><a data-test="test" rel="nofollow" style="word-wrap: break-word; text-decoration: underline;" target="_blank" onclick="return dhExternalLinkRedirect(this)" href="/ExternalLinkRedirect?module=pgdcode&messageId=89496019&url=#" data-href="#">Hizmetler</a></li>
<li><a data-test="test" rel="nofollow" style="word-wrap: break-word; text-decoration: underline;" target="_blank" onclick="return dhExternalLinkRedirect(this)" href="/ExternalLinkRedirect?module=pgdcode&messageId=89496019&url=#" data-href="#">Yeni Hizmet Ekle</a></li>
</ul>
</li>
<li>
<a href="#" class="nav-top-item">
Resimler
</a>
<ul>
<li><a data-test="test" rel="nofollow" style="word-wrap: break-word; text-decoration: underline;" target="_blank" onclick="return dhExternalLinkRedirect(this)" href="/ExternalLinkRedirect?module=pgdcode&messageId=89496019&url=#" data-href="#">Resimler</a></li>
<li><a data-test="test" rel="nofollow" style="word-wrap: break-word; text-decoration: underline;" target="_blank" onclick="return dhExternalLinkRedirect(this)" href="/ExternalLinkRedirect?module=pgdcode&messageId=89496019&url=#" data-href="#">Yeni Resim Ekle</a></li>
</ul>
</li>
<li>
<a href="#" class="nav-top-item">
Ayarlar</a>
<ul>
<li><a data-test="test" rel="nofollow" style="word-wrap: break-word; text-decoration: underline;" target="_blank" onclick="return dhExternalLinkRedirect(this)" href="/ExternalLinkRedirect?module=pgdcode&messageId=89496019&url=#" data-href="#">Site Ayarları</a></li>
</ul>
</li>
</ul> <!-- End #main-nav -->
<div id="messages" style="display: none"> <!-- Messages are shown when a link with these attributes are clicked: href="#messages" rel="modal" -->
<h3>3 Messages</h3>
<p>
<strong>17th May 2009</strong> by Admin<br />
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vivamus magna. Cras in mi at felis aliquet congue.
<small><a data-test="test" rel="nofollow" style="word-wrap: break-word; text-decoration: underline;" target="_blank" onclick="return dhExternalLinkRedirect(this)" href="/ExternalLinkRedirect?module=pgdcode&messageId=89496019&url=#" class="remove-link" title="Remove message" data-href="#" class="remove-link" title="Remove message">Remove</a></small>
</p>
<p>
<strong>2nd May 2009</strong> by Jane Doe<br />
Ut a est eget ligula molestie gravida. Curabitur massa. Donec eleifend, libero at sagittis mollis, tellus est malesuada tellus, at luctus turpis elit sit amet quam. Vivamus pretium ornare est.
<small><a data-test="test" rel="nofollow" style="word-wrap: break-word; text-decoration: underline;" target="_blank" onclick="return dhExternalLinkRedirect(this)" href="/ExternalLinkRedirect?module=pgdcode&messageId=89496019&url=#" class="remove-link" title="Remove message" data-href="#" class="remove-link" title="Remove message">Remove</a></small>
</p>
<p>
<strong>25th April 2009</strong> by Admin<br />
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vivamus magna. Cras in mi at felis aliquet congue.
<small><a data-test="test" rel="nofollow" style="word-wrap: break-word; text-decoration: underline;" target="_blank" onclick="return dhExternalLinkRedirect(this)" href="/ExternalLinkRedirect?module=pgdcode&messageId=89496019&url=#" class="remove-link" title="Remove message" data-href="#" class="remove-link" title="Remove message">Remove</a></small>
</p>
<form action="" method="post">
<h4>New Message</h4>
<fieldset>
<textarea class="textarea" name="textfield" cols="79" rows="5"></textarea>
</fieldset>
<fieldset>
<select name="dropdown" class="small-input">
<option value="option1">Send to...</option>
<option value="option2">Everyone</option>
<option value="option3">Admin</option>
<option value="option4">Jane Doe</option>
</select>
<input class="button" type="submit" value="Send" />
</fieldset>
</form>
</div> <!-- End #messages -->
</div></div> <!-- End #sidebar -->
<div id="main-content"> <!-- Main Content Section with everything -->
<noscript> <!-- Show a notification if the user has disabled javascript -->
</noscript>
<!-- Page Head -->
<!-- End .shortcut-buttons-set -->
<div class="clear"></div> <!-- End .clear -->
<div class="content-box"><!-- Start Content Box -->
<div class="content-box-header">
<h3>Ürün Ekle</h3>
<ul class="content-box-tabs"><!-- href must be unique and match the id of target div -->
</ul>
<div class="clear"></div>
</div> <!-- End .content-box-header -->
</div>
<div class="sayfalar">
<p> </p>
<form action="<?php echo $editFormAction; ?>" enctype="multipart/form-data" method="post" name="form1" id="form1">
<table align="center">
<tr valign="baseline">
<td width="19%" align="right" nowrap="nowrap">Ürün Başlığı</td>
<td width="81%"><input name="baslik" type="text" style="padding:10px; width:400px;" size="32"/></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Ürün İçeriği</td>
<td><textarea name="icerik" class=”ckeditor” id="icerik"></textarea></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Ürün Resmi</td>
<td>
<?php
include ("../Connections/baglan.php");
if($_POST){
if ($_FILES["resim"]["size"]<1024*1024){
if ($_FILES["resim"]["type"]=="image/jpeg"){
$dosya_adi=$_FILES["resim"]["name"];
$uret=array("as","rt","ty","yu","fg");
$uzanti=substr($dosya_adi,-4,4);
$sayi_tut=rand(1,10000);
$yeni_ad="../images_up/".$uret[rand(0,4)].$sayi_tut.$uzanti;
if (move_uploaded_file($_FILES["resim"]["tmp_name"],$yeni_ad)){
echo 'Dosya başarıyla yüklendi.';
$sorgu=mysql_query("insert into urunler (resim) values ('$yeni_ad')");
if ($sorgu){
echo 'Veritabanına kaydedildi.';
}else{
echo 'Kayıt sırasında hata oluştu!';
}
}else{
echo 'Dosya Yüklenemedi!';
}
}else{
echo 'Dosya yalnızca jpeg formatında olabilir!';
}
}else{
echo 'Dosya boyutu 1 Mb ı geçemez!';
}
}
?>
<input type="file" name="resim" id="resim" />
</td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Ürün Kategorisi</td>
<td><select name="kat_id" id="kategori"style="padding:10px; width:425px;">
<?php
do {
?>
<option value="<?php echo $row_kategori['id']?>"><?php echo $row_kategori['baslik']?></option>
<?php
} while ($row_kategori = mysql_fetch_assoc($kategori));
$rows = mysql_num_rows($kategori);
if($rows > 0) {
mysql_data_seek($kategori, 0);
$row_kategori = mysql_fetch_assoc($kategori);
}
?>
</select></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right"> </td>
<td><input name="Submit" type="submit" value="Ürün Ekle" /></td>
</tr>
</table>
<input type="hidden" name="id" value="" />
<input type="hidden" name="MM_insert" value="form1" />
</form>
<p> </p>
</div>
<!-- End .content-box -->
<!-- End .content-box -->
<!-- End .content-box -->
<div class="clear"></div>
<!-- Start Notifications -->
<?php
if(isset($_POST['MM_insert']) && @$sorgu==TRUE) {
echo '
<div class="notification success png_bg">
<a data-test="test" rel="nofollow" style="word-wrap: break-word; text-decoration: underline;" target="_blank" onclick="return dhExternalLinkRedirect(this)" href="/ExternalLinkRedirect?module=pgdcode&messageId=89496019&url=#" class="close" data-href="#" class="close"><img src="resources/images/icons/cross_grey_small.png" title="Close this notification" alt="close" /></a>
<div>
Ürün başarılı bir şekilde sisteme eklenmiştir</div>
</div>
';} else if(isset($_POST['MM_insert']) && @$sorgu==FALSE) {
echo '
<div class="notification error png_bg">
<a data-test="test" rel="nofollow" style="word-wrap: break-word; text-decoration: underline;" target="_blank" onclick="return dhExternalLinkRedirect(this)" href="/ExternalLinkRedirect?module=pgdcode&messageId=89496019&url=#" class="close" data-href="#" class="close"><img src="resources/images/icons/cross_grey_small.png" title="Close this notification" alt="close" /></a>
<div>
Ürün sisteme eklenemedi</div>
</div>';}
?>
<!-- End Notifications -->
<div id="footer">
<small>
YSM Bilişim Kurumsal Web Sitesi © Copyright 2013 Web Tasarım : <a data-test="test" rel="nofollow" style="word-wrap: break-word; text-decoration: underline;" target="_blank" onclick="return dhExternalLinkRedirect(this)" href="/ExternalLinkRedirect?module=pgdcode&messageId=89496019&url=http://www.ysmbilisim.com" target="_blank" data-href="http://www.ysmbilisim.com" target="_blank">YSM Bilişim</a><a data-test="test" rel="nofollow" style="word-wrap: break-word; text-decoration: underline;" target="_blank" onclick="return dhExternalLinkRedirect(this)" href="/ExternalLinkRedirect?module=pgdcode&messageId=89496019&url=#" data-href="#"></a> </small> </div>
<!-- End #footer -->
</div> <!-- End #main-content -->
</div>
</body>
</html>
<?php
mysql_free_result($ayarlar);
mysql_free_result($kategori);
?>
ARKADAŞLAR BU SAYFA EKLE DEDİĞİMDE MYSQL E BAŞLIK SEO VE İÇERİĞİ Bİ KAYIT RESMİ BİR KAYIT OLARAK AÇIYOR 2 İŞLEM GİBİ HEPSİ BİR KAYIT OLMASI İÇİN NE YAPABİLİRİM
< Bu mesaj bu kişi tarafından değiştirildi karot28 -- 21 Mart 2014; 16:54:24 >