nokhodi
شنبه 10 خرداد 1393, 10:25 صبح
سلام دوستان
کد Mysql م برای اتصال به بانک خطا میده...
در صورتی که همین کد توی یک صفحه دیگه داره کار میکنه
119723
قطعه کدم اینه :
<?php require_once('Connections/cn.php');
mysql_query('SET NAMES \'utf8\'');
?>
<?php
$func=$_POST['type_func'];
$p1=$_POST['p1'];
$p2=$_POST['p2'];
$p3=$_POST['p3'];
switch($func)
{
case "cat":
catgory();
break;
case "cat_post":
posts($p1,$p2,$p3);
break;
case "showpost":
show_post($s);
break;
}
?>
<?php
function catgory()
{
mysql_select_db($database_cn, $cn);
$query_rs1 = "SELECT term_id,name FROM wp_terms WHERE term_id=1 or term_id=2 or term_id=5 or term_id=6 or term_id=10 or term_id=18 or term_id=22 or term_id=28 or term_id=30";
$rs1 = mysql_query($query_rs1, $cn) or die(mysql_error());
$row_rs1 = mysql_fetch_assoc($rs1);
$totalRows_rs1 = mysql_num_rows($rs1);
$arry = array();
do {
$arr = array();
$arr['id_term'] = $row_rs1['term_id'];
$arr['name_term'] = $row_rs1['name'];
$arry[]=$arr;
}
while ($row_rs1 = mysql_fetch_assoc($rs1));
echo json_encode($arry);
}
////////////////////////////////////////////////////////////////////////////////////
function posts($p1,$p2,$p3)
{
mysql_select_db($database_cn, $cn);
$query_rs1 = "SELECT DISTINCT `wp_term_relationships`.`object_id` , `wp_term_taxonomy`.`parent` , `wp_posts`.`post_title`
FROM wp_term_relationships, wp_term_taxonomy, wp_posts
WHERE `wp_posts`.`post_status` = 'publish'
AND `wp_posts`.`post_type` = 'post'
AND `wp_term_taxonomy`.`term_taxonomy_id` = `wp_term_relationships`.`term_taxonomy_id`
AND `wp_posts`.`ID` = `wp_term_relationships`.`object_id`
AND `wp_term_taxonomy`.`parent` <>0
and `wp_term_taxonomy`.`parent`=$p1
LIMIT $p2 , $p3";
$rs1 = mysql_query($query_rs1, $cn) or die(mysql_error());
$row_rs1 = mysql_fetch_assoc($rs1);
$totalRows_rs1 = mysql_num_rows($rs1);
$arry = array();
do {
$arr = array();
$arr['id_post'] = $row_rs1['object_id'];
$arr['id_cat'] = $row_rs1['parent'];
$arr['title_post'] = $row_rs1['post_title'];
$arry[]=$arr;
}
while ($row_rs1 = mysql_fetch_assoc($rs1));
echo json_encode($arry);
}
////////////////////////////////////////////////////////////////////////////////////
function show_post($p1,$p2,$p3)
{
echo $func;
echo $p1;
echo $p2;
echo $p3;
}
?>
کد Mysql م برای اتصال به بانک خطا میده...
در صورتی که همین کد توی یک صفحه دیگه داره کار میکنه
119723
قطعه کدم اینه :
<?php require_once('Connections/cn.php');
mysql_query('SET NAMES \'utf8\'');
?>
<?php
$func=$_POST['type_func'];
$p1=$_POST['p1'];
$p2=$_POST['p2'];
$p3=$_POST['p3'];
switch($func)
{
case "cat":
catgory();
break;
case "cat_post":
posts($p1,$p2,$p3);
break;
case "showpost":
show_post($s);
break;
}
?>
<?php
function catgory()
{
mysql_select_db($database_cn, $cn);
$query_rs1 = "SELECT term_id,name FROM wp_terms WHERE term_id=1 or term_id=2 or term_id=5 or term_id=6 or term_id=10 or term_id=18 or term_id=22 or term_id=28 or term_id=30";
$rs1 = mysql_query($query_rs1, $cn) or die(mysql_error());
$row_rs1 = mysql_fetch_assoc($rs1);
$totalRows_rs1 = mysql_num_rows($rs1);
$arry = array();
do {
$arr = array();
$arr['id_term'] = $row_rs1['term_id'];
$arr['name_term'] = $row_rs1['name'];
$arry[]=$arr;
}
while ($row_rs1 = mysql_fetch_assoc($rs1));
echo json_encode($arry);
}
////////////////////////////////////////////////////////////////////////////////////
function posts($p1,$p2,$p3)
{
mysql_select_db($database_cn, $cn);
$query_rs1 = "SELECT DISTINCT `wp_term_relationships`.`object_id` , `wp_term_taxonomy`.`parent` , `wp_posts`.`post_title`
FROM wp_term_relationships, wp_term_taxonomy, wp_posts
WHERE `wp_posts`.`post_status` = 'publish'
AND `wp_posts`.`post_type` = 'post'
AND `wp_term_taxonomy`.`term_taxonomy_id` = `wp_term_relationships`.`term_taxonomy_id`
AND `wp_posts`.`ID` = `wp_term_relationships`.`object_id`
AND `wp_term_taxonomy`.`parent` <>0
and `wp_term_taxonomy`.`parent`=$p1
LIMIT $p2 , $p3";
$rs1 = mysql_query($query_rs1, $cn) or die(mysql_error());
$row_rs1 = mysql_fetch_assoc($rs1);
$totalRows_rs1 = mysql_num_rows($rs1);
$arry = array();
do {
$arr = array();
$arr['id_post'] = $row_rs1['object_id'];
$arr['id_cat'] = $row_rs1['parent'];
$arr['title_post'] = $row_rs1['post_title'];
$arry[]=$arr;
}
while ($row_rs1 = mysql_fetch_assoc($rs1));
echo json_encode($arry);
}
////////////////////////////////////////////////////////////////////////////////////
function show_post($p1,$p2,$p3)
{
echo $func;
echo $p1;
echo $p2;
echo $p3;
}
?>