Google php iLe pek aLakası yok ajax
Hocam Googlede aradım Şunu Buldum;
jSuggest 1.0 - Advanced Auto-complete for jQuery | Keansphere
ama bi türlü uyarlayamadım. Biraz Yardımcı Olurmusunuz
Benim Kodlarım;
<!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">
<head>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-9">
<META HTTP-EQUIV="Content-Language" CONTENT="tr">
<!-- TinyMCE -->
<script type="text/javascript" src="../../Z-inc/tinymce/jscripts/tiny_mce/tiny_mce.js"></script>
<script type="text/javascript">
tinyMCE.init({
// General options
mode : "textareas",
theme : "advanced",
skin : "o2k7",
language:"tr",
skin_variant : "silver",
plugins : "safari,pagebreak,style,layer,table,save,advhr,advimage,advlink,emotions,iespell,inlinepopups,insertdatetime,preview,media,searchreplace,print,contextmenu,paste,directionality,fullscreen,noneditable,visualchars,nonbreaking,xhtmlxtras,template",
// Theme options
theme_advanced_buttons1 : "bold,italic,underline,strikethrough,|,justifyleft,justifycenter,justifyright,justifyfull,styleselect,formatselect,fontselect,fontsizeselect",
theme_advanced_buttons2 : "cut,copy,paste,pastetext,pasteword,|,search,replace,|,bullist,numlist,|,outdent,indent,blockquote,|,undo,redo,|,link,unlink,anchor,image,cleanup,code,preview,|,forecolor,backcolor",
theme_advanced_buttons2 : "cut,copy,paste,pastetext,pasteword,|,search,replace,|,bullist,numlist,|,outdent,indent,blockquote,|,undo,redo,|,link,unlink,anchor,image,cleanup,code,preview,|,forecolor,backcolor",
theme_advanced_buttons3 : "tablecontrols,|,hr,removeformat,visualaid,|,sub,sup,|,charmap,emotions,iespell,media,advhr,|,ltr,rtl,|,fullscreen",
theme_advanced_buttons4 : "insertlayer,moveforward,movebackward,absolute,|,styleprops,|,cite,abbr,acronym,del,ins,attribs,|,visualchars,nonbreaking,template,pagebreak",
theme_advanced_toolbar_location : "top",
theme_advanced_toolbar_align : "left",
theme_advanced_statusbar_location : "bottom",
theme_advanced_resizing : true,
// Example content CSS (should be your site CSS)
content_css : "../../Z-inc/tinymce/css/content.css",
// Drop lists for link/image/media/template dialogs
template_external_list_url : "../../Z-inc/tinymce/lists/template_list.js",
external_link_list_url : "../../Z-inc/tinymce/lists/link_list.js",
external_image_list_url : "../../Z-inc/tinymce/lists/image_list.js",
media_external_list_url : "../../Z-inc/tinymce/lists/media_list.js",
// Replace values for the template plugin
template_replace_values : {
username : "Some User",
staffid : "991234"
}
});
</script>
<!-- /TinyMCE -->
</head>
<p style="border:#ccc 3px double; font-family:'Trebuchet MS'; font-size:18px; background-color:#EAEAEA" align="center">Program Ekleme Formu</p>
<?php
include ("../../Z-inc/genel_fonk.php");
include ("../../Z-inc/mysql_baglan.php");
function prosubcat($main_id,$prog_form)
{
$tablo = "SELECT * FROM programlar_alt_kat WHERE m_id=$main_id ORDER BY id";
$sorgu = mysql_query ($tablo) ;
while ($oku = mysql_fetch_array($sorgu))
{
$sub_id = $oku["id"];
$sub_kat_isim = $oku["kat_isim"];
$sub_kat_depth = $oku["depth"];
$prog_form=$prog_form."<option value=\"$sub_id\">";
$x=0;
while($x<$sub_kat_depth)
{
$prog_form=$prog_form."--";
$x++;
}
$prog_form=$prog_form.$sub_kat_isim."</option>";
$prog_form = prosubcat($sub_id,$prog_form);
}
return $prog_form;
}
Function program(){
global $baglan,$programekleform;
echo "$programekleform";
}
Function programekle(){
global $programekleform,$baglan;
$cprokat = $_POST["prokat"];
$cproisim = $_POST["proisim"];
$cprosurum = $_POST["prosurum"];
$cprodil = $_POST["prodil"];
$cproindirl = $_POST["indirl"];
$cproboyut = $_POST["proboyut"];
$cprokullanim = $_POST["kullanim"];
$cproaciklama = $_POST["z-editor"];
$cproresim = $_POST["proresim"];
$cprotarih = date("Y-m-d");
$cproplatform = $_POST["proplatform"];
$metakey = $_POST["metakey"];
$metadesc = $_POST["metadesc"];
if (($cprokat =="") or ($cproisim =="") or ($cproindirl =="") )
{
echo "Zorunlu alanlar boş bırakılamaz.";
}
else{
$cproaciklama =str_replace('\'',''',$cproaciklama);
$aciklama=str_replace(''',' ',$cproaciklama);
$metakey=str_replace(''',' ',$metakey);
$metadesc=str_replace(''',' ',$metadesc);
$tabloyakaydet = mysql_query("insert into programlar(platform,tarih,kullanim,dil,katid,isim,surum,link,boyut,aciklama,resim,etiket,`key`,`desc`) values ('$cproplatform','$cprotarih','$cprokullanim','$cprodil','$cprokat','$cproisim','$cprosurum','$cproindirl','$cproboyut','$cproaciklama','$cproresim','$etiketler','$metakey','$metadesc')");
if ($tabloyakaydet)
{
echo "Kayıt tamam";
}
else{echo "Kayit Yapilamadi";}
}
}
// Program Gönderme Formu Baslangiç - Portalz
$programekleform = "
<form id=\"form1\" name=\"form1\" method=\"post\" action=\"program_ekle.php?islem=ekle\">
<table style=\"font-family:'Trebuchet MS'; font-size:12px\" width=\"100%\" height=\"700\" cellspacing=\"1\" cellpadding=\"3\">
<tr bgcolor=\"antiquewhite\">
<th style=\"border:1px solid #ccc\" width=\"200px\" scope=\"row\">Kategori</th>
<td style=\"border:1px solid #ccc\" width=\"5px\">:</td>
<td style=\"border:1px solid #ccc\"><label>
<select style=\"width:250px;\" name=\"prokat\" id=\"prokat\">";
$tablo = "SELECT * FROM programlar_alt_kat WHERE m_id=0 ORDER BY id";
$sorgu = mysql_query ( $tablo );
while ( $oku = mysql_fetch_assoc ( $sorgu ) )
{
$katisim = $oku["kat_isim"];
$katid = $oku["id"];
$programekleform = $programekleform."<option value=\"$katid\">$katisim</option>";
$programekleform = prosubcat($katid,$programekleform);
}
$programekleform = $programekleform."</select>
</label></td>
</tr>
<tr bgcolor=\"whitesmoke\">
<th style=\"border:1px solid #ccc\" scope=\"row\">Program Adı</th>
<td style=\"border:1px solid #ccc\">:</td>
<td style=\"border:1px solid #ccc\"><label>
<input style=\"width:250px;\" type=\"text\" name=\"proisim\" id=\"proisim\" />
</label></td>
</tr>
<tr bgcolor=\"antiquewhite\">
<th style=\"border:1px solid #ccc\" scope=\"row\">Sürüm</th>
<td style=\"border:1px solid #ccc\">:</td>
<td style=\"border:1px solid #ccc\"><input style=\"width:250px;\" type=\"text\" name=\"prosurum\" id=\"prosurum\" /></td>
</tr>
<tr bgcolor=\"whitesmoke\">
<th style=\"border:1px solid #ccc\" scope=\"row\">Dili</th>
<td style=\"border:1px solid #ccc\">:</td>
<td style=\"border:1px solid #ccc\"><select style=\"width:250px;\" name=\"prodil\" id=\"prodil\">
<option>İngilizce</option>
<option>Türkçe</option>
<option>Almanca</option>
<option>İtalyanca</option>
<option>Belirtilmedi</option>
</select></td>
</tr>
<tr bgcolor=\"antiquewhite\">
<th style=\"border:1px solid #ccc\" scope=\"row\">İndirme Linki</th>
<td style=\"border:1px solid #ccc\">:</td>
<td style=\"border:1px solid #ccc\"><input style=\"width:250px;\" type=\"text\" name=\"indirl\" id=\"indirl\" /></td>
</tr>
<tr bgcolor=\"whitesmoke\">
<th style=\"border:1px solid #ccc\" scope=\"row\">Boyut</th>
<td style=\"border:1px solid #ccc\">:</td>
<td style=\"border:1px solid #ccc\"><input style=\"width:250px;\" type=\"text\" name=\"proboyut\" id=\"proboyut\" />
</td>
</tr>
<tr bgcolor=\"antiquewhite\">
<th style=\"border:1px solid #ccc\" scope=\"row\">Platform</th>
<td style=\"border:1px solid #ccc\">:</td>
<td style=\"border:1px solid #ccc\"><input style=\"width:250px;\" type=\"text\" name=\"proplatform\" id=\"proplatform\" />
</td>
</tr>
<tr bgcolor=\"whitesmoke\">
<th style=\"border:1px solid #ccc\" scope=\"row\">Kullanım İzni</th>
<td style=\"border:1px solid #ccc\">:</td>
<td style=\"border:1px solid #ccc\"><select name=\"kullanim\" id=\"kullanim\">
<option>Süre/Kullanım Kısıtlamalı (Shareware)</option>
<option>Ücretsiz (Freeware)</option>
<option>Özellik Kısıtlamalı (Demo)</option>
<option>Diğer</option>
</select></td>
</tr>
<tr bgcolor=\"antiquewhite\">
<th style=\"border:1px solid #ccc\" scope=\"row\">Resim</th>
<td style=\"border:1px solid #ccc\">:</td>
<td style=\"border:1px solid #ccc\"><label>
<input style=\"width:250px;\" type=\"text\" name=\"proresim\" id=\"proresim\" />
</label></td>
</tr>
<tr bgcolor=\"whitesmoke\">
<th style=\"border:1px solid #ccc\" scope=\"row\">Meta Keywords</th>
<td style=\"border:1px solid #ccc\">:</td>
<td style=\"border:1px solid #ccc\"><label>
<input style=\"width:250px;\" type=\"text\" name=\"metakey\" id=\"metakey\" />
</label></td>
</tr>
<tr bgcolor=\"antiquewhite\">
<th style=\"border:1px solid #ccc\" scope=\"row\">Meta Description</th>
<td style=\"border:1px solid #ccc\">:</td>
<td style=\"border:1px solid #ccc\"><label>
<input style=\"width:250px;\" type=\"text\" name=\"metadesc\" id=\"metadesc\" />
</label></td>
</tr>
<tr><td style=\"border:1px solid #ccc\" bgcolor=\"whitesmoke\" align=\"center\" colspan=\"3\"><b>Açıklama</b></td></tr>
<tr>
<td style=\"border:1px solid #ccc\" colspan=\"3\"><label>
<textarea id=\"z-editor\" name=\"z-editor\"></textarea>
</label></td>
</tr>
<tr>
<td style=\"border:1px solid #ccc\" colspan=3><label>
<input type=\"submit\" name=\"gonder\" id=\"gonder\" value=\"Gönder\" />
</label></td>
</tr>
</table>
</form>";
// Program Gönderme Formu Bitis - Portalz
$islem = $_GET[islem];
switch ($islem)
{
default:
program();
break;
case "ekle":
programekle();
break;
}
?>