Mysidia Adoptables Support Forum  

Home Community Mys-Script Creative Off-Topic
Go Back   Mysidia Adoptables Support Forum > Mysidia Adoptables > Questions and Supports

Notices

Reply
 
Thread Tools Display Modes
  #1  
Old 06-20-2009, 04:25 AM
reza01 reza01 is offline
Member
 
Join Date: Jun 2009
Posts: 2
Credits: 954
reza01
Default i can,t insert information please help me.

hi
i am a beginner in php.

i have problem with some codes.

In PHP new_ad.php and add_new_ad.php ther is some information
like( sub_group.sub_group2.sub_group3.sub_group4.sub_gro up5.title.
title2.title3.title4.title5.descr.text.name.tel.Ci ty.address.type.duration)
that i inserted them in new_add.php, but they don't inserted in to phpMyAdmin and Database.

new_ad.php:
Code:
<?php
  include("../config.php");
  include("../jdf.php");

  mysql_connect($db_server, $db_username, $db_password);
  mysql_select_db($db_name);

  $query = "SET NAMES 'utf8'";
  mysql_query($query);

  $query = "SELECT * FROM settings";
  $result = mysql_query($query);
  
  if (mysql_num_rows($result))
    {
    $row = mysql_fetch_array($result);
    $site_name = $row['SiteName'];
    $side_bar  = $row['SideBar'];
    }

  $today = jdate("l");
  $today .= " " . jdate("y/m/d");
  $groups = get_groups();

  $authorized = 1;
  if ($authorized=1)
    {
    $ad_groups = get_groups2();
    $ad_sub_groups = get_sub_groups();
    $ad_types  = get_types();
    $durations = get_durations();
    }
  else
    header("location:login.php");

  function check_authorization()
  {
    session_start();
    if (isset($_SESSION['uname']) && isset($_SESSION['upass']))
      return true;
    else
      return false;
  }

  function get_groups()
  {
    $query = "SELECT * FROM groups";
    $result = mysql_query($query);

    $groups_html = "";
    while (($row = mysql_fetch_array($result)))    
      {
      $name = $row['Name'];
      $id   = $row['ID'];
      $groups_html .= "<a href=\"../main_group.php?id=$id\"><img src=%22../images/fbrows4R.gif\">&nbsp;$name</a><br>";
      }

    return $groups_html;
  }

  function get_groups2()
  {
    $query = "SELECT * FROM groups WHERE ParentID=0";
    $result = mysql_query($query);

    $groups_html = "";
    while (($row = mysql_fetch_array($result)))    
      {
      $name = $row['Name'];
      $id   = $row['ID'];
      $groups_html .= "<option value=\"$id\">$name</option>";
      }

    return $groups_html;
  }

  function get_sub_groups()
  {
    $query = "SELECT * FROM groups WHERE ParentID=0";
    $result = mysql_query($query);    
    if (mysql_num_rows($result))
      {
      $row = mysql_fetch_array($result);
      $pid = $row['ID'];
      }

    $query = "SELECT * FROM groups WHERE ParentID=$pid";
    $result = mysql_query($query);

    $groups_html = "";
    while (($row = mysql_fetch_array($result)))    
      {
      $name = $row['Name'];
      $id   = $row['ID'];
      $groups_html .= "<option value=\"$id\">$name</option>";
      }

    return $groups_html;
  }

  function get_types()
  {
    $query = "SELECT * FROM adtypes";
    $result = mysql_query($query);

    $groups_html = "";
    while (($row = mysql_fetch_array($result)))    
      {
      $name = $row['Name'];
      $id   = $row['ID'];
      $groups_html .= "<option value=\"$id\">$name</option>";
      }

    return $groups_html;
  }

  function get_durations()
  {
    $query = "SELECT * FROM durations";
    $result = mysql_query($query);

    $groups_html = "";
    while (($row = mysql_fetch_array($result)))    
      {
      $name = $row['Name'];
      $id   = $row['ID'];
      $groups_html .= "<option value=\"$id\">$name</option>";
      }

    return $groups_html;
  }
?>

<html dir='ltr' xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office"><header><META NAME='distribution' CONTENT=''> <meta http-equiv='Content-Language' content='fa'><meta http-equiv='Content-Type' content='text/html; charset=utf-8'><meta name='Author' content='Hadi Fanaee'><META NAME='robots' CONTENT='index, follow'><META NAME='revisit-after' CONTENT='1 days'><style>body{FONT-SIZE: 10pt ; FONT-FAMILY: Tahoma ;background-color:#FFFFFF;color:#llllll}
index_body{FONT-SIZE: 10pt ; FONT-FAMILY: Tahoma ;background-color:#FFFFFF;background-image:url('../images/00000000.txt')}
input{FONT-SIZE: 10pt ; FONT-FAMILY: Tahoma}
select{FONT-SIZE: 10pt ; FONT-FAMILY: Tahoma}
textarea{FONT-SIZE: 10pt ; FONT-FAMILY: Tahoma}
table{FONT-SIZE: 10pt ; FONT-FAMILY: Tahoma}
A:hover {COLOR: #FF0000; TEXT-DECORATION: none}
A {	COLOR: #00008b; TEXT-DECORATION: none}
.text_small  { font-size: 10px  }
.text_big  { font-size: 14pt  }
.index_main{border-collapse: collapse; font-size: 10pt ; background-color:#FFFFFF;background-image:url('../images/bkpic000.gif'); color:#llllll}
.index_table{border-collapse: collapse; font-size:10pt ; background-color:#F0F0F0; color:}
.index_table_inner{border-collapse: collapse; font-size:10pt ;color:}
.index_table_title{color:; font-size:10pt ; text-align:center}
.button1{font-family: Tahoma; font-size: 10pt ; color:   }
.input1{font-family: Tahoma; font-size: 10pt ; color:   }
.index_table_button{font-family: Tahoma; font-size: 10pt ; color:   }
.index_table_input{font-family: Tahoma; font-size: 10pt ; color:   }
.index_header{color:;  font-size:10pt ; text-align:center}
.index_menubar{background-image: url('../images/tmenubar.gif'); color:#384EA0;   font-size:10pt ; text-align:center}
.text2  { color:#00008b  }
.text3 { color:#0000ff  }
.text4 {   }
.hr{color:#0066CC}
.tblheaderbg{background-color:#F0F0F0;}
.tblheader{border:1px solid #F0F0F0; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma}
.block_title{color:#480580; font-size:10px ; text-align:Center}
.style13 {
	background-color: #e20a19;
	text-align: center;
	color: #FFFFFF;
}
.style14 {
	background-color: #018232;
	text-align: center;
	color: #FFFFFF;
}
.style15 {
	background-color: #fc4e1b;
	text-align: center;
	color: #FFFFFF;
}
.style16 {
	background-color: #0001fe;
	color: #FFFFFF;
	text-align: center;
}
.style17 {
	background-color: #650103;
	color: #FFFFFF;
	text-align: center;
}
</style>

<script type="text/javascript">

  function get_sub_groups(group)
  {
    document.newad.sub_group.options.length = 0;
    jsel = document.createElement('script');
    jsel.type = "text/javascript";
    jsel.src = "get_sub_groups.php?grp=" + group;
    document.body.appendChild(jsel);
  }

  function calc_price()
  {
    type = document.newad.type.value;
    duration = document.newad.duration.value;
    stars = document.newad.stars.value;

    jsel = document.createElement('script');
    jsel.type = "text/javascript";
    jsel.src  = "calc_price.php?";
    jsel.src += "type=" + type;
    jsel.src += "duration=" + duration;
    jsel.src += "stars=" + stars;
    document.appendChild(jsel);
  }

  function validate()
  {
    valid_arr = new Array(18);

    valid_arr[0]  = document.newad.group.value;
    valid_arr[1]  = document.newad.sub_group.value;
    valid_arr[2]  = document.newad.sub_group2.value;
    valid_arr[3]  = document.newad.sub_group3.value;
    valid_arr[4]  = document.newad.sub_group4.value;
    valid_arr[5]  = document.newad.sub_group5.value;
    valid_arr[6]  = document.newad.title.value;
    valid_arr[7]  = document.newad.title2.value;
    valid_arr[8]  = document.newad.title3.value;
    valid_arr[9]  = document.newad.title4.value;
    valid_arr[10] = document.newad.title5.value;
    valid_arr[11] = document.newad.descr.value;
    valid_arr[12] = document.newad.text.value;
    valid_arr[13] = document.newad.name.value;
    valid_arr[14] = document.newad.tel.value;
    valid_arr[15] = document.newad.City.value;
    valid_arr[16] = document.newad.address.value;
    valid_arr[17] = document.newad.type.value;
    valid_arr[18] = document.newad.duration.value;
    valid_arr[19] = document.newad.link.value;
 
    for (i=0; i<18; i++)
      if (valid_arr[i] == "")
        {
        isvalid = false;
        alert("file all");
        return false;
        }

    return true;
  }

</script>

<body onresize='buildsubmenus_horizontal();buildsubmenus()' background='../images/bg000000.gif' leftmargin='0' topmargin='0'><script language='JavaScript' src='../images/farsi000.js'></script><meta http-equiv='Content-Type' content='text/html; charset=utf-8'>

<link rel="stylesheet" type="text/css" href="../images/style000.css">
<div style="width: 980px; float: right;" dir="rtl">

<div align='center'><table dir='rtl' border='0' cellpadding='0' cellspacing='0' width='100%' class='index_main'><td width='4' valign='top'></td><td bgcolor='#FFFFFF'  width='150' valign='top'>
	&nbsp;</td><td width='10' valign='top'></td><td dir='rtl' background='../images/bkpic000.gif' width='99%' class='index_main' align=center valign='top'><div align=center><table border='0' cellpadding='0' cellspacing='0'  class='index_main' width='98%'><tr><td height='6' width='100%'></tr><tr><td width='100%'><title>...???? ????? ??????? ???????? ?????? ...  </title><link rel='stylesheet' type='text/css' href='../images/style000.css'><DIV style="MARGIN-TOP: 3px; FLOAT: left; WIDTH: 100%">
<TABLE class=picc cellSpacing=0 cellPadding=0 width="100%">
  <TBODY>
  <TR>
    <TD class=ghd colSpan="4"> <span lang="en-us">insert new</span></TD></TR></TBODY></TABLE>
		</div>
			<form name="newad" method="post" action="add_new_ad.php" onsubmit="return validate()">
				<table style="width: 100%">
					<tr>
						<td style="width: 121px">
		&nbsp;</td>
						<td style="width: 1384px">
		&nbsp;</td>
					</tr>
					<tr>
		<span lang="en-us">
						<td style="width: 121px" class="style13"><strong>
						<span lang="en-us">p</span> 
						1</strong></td>
		</span>
						<td style="width: 1384px">
		<span lang="en-us">
						&nbsp;&nbsp;&nbsp;
							<input type="text" style="width: 308px" name="title" size="20"> 
		group:&nbsp;
							<select name="group" onchange="get_sub_groups(this.value)">
								<?php echo $ad_groups; ?>
							</select>&nbsp;sub group:
							<select name="sub_group">
								<?php echo $ad_sub_groups; ?>
							</select></span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
		<input name="Button1" type="button" value="product"></td>
					</tr>
		<span lang="en-us">
					<tr>
						<td style="width: 121px" class="style14"><strong>
						<span lang="en-us">p</span> 
						2</strong></td>
						<td style="width: 1384px">
		<span lang="en-us">
						&nbsp;</span>&nbsp;&nbsp; <span lang="en-us">
							<input type="text" style="width: 308px" name="title2" size="20"> 
		group:&nbsp;
							<select name="group0" onchange="get_sub_groups(this.value)">
								<?php echo $ad_groups; ?>
							</select>&nbsp;sub group:
							<select name="sub_group0">
								<?php echo $ad_sub_groups; ?>
							</select></span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span lang="en-us">
		<input name="Button2" type="button" value="product"></span></td>
					</tr>
					<tr>
						<td style="width: 121px; height: 29px;" class="style15">
						<strong><span lang="en-us">p</span> 3</strong></td>
						<td style="width: 1384px">
		&nbsp;<span lang="en-us">&nbsp;&nbsp;
							<input type="text" style="width: 308px" name="title3" size="20">&nbsp;group:&nbsp;
							<select name="group1" onchange="get_sub_groups(this.value)">
								<?php echo $ad_groups; ?>
							</select>&nbsp;sub group:
							<select name="sub_group1">
								<?php echo $ad_sub_groups; ?>
							</select></span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span lang="en-us">
		<input name="Button3" type="button" value="product"></span></td>
					</tr>
					<tr>
						<td style="width: 121px" class="style16"><strong>
						<span lang="en-us">p</span> 
						4</strong></td>
						<td style="width: 1384px">
		<span lang="en-us">
						&nbsp;&nbsp; </span>&nbsp;<span lang="en-us"><input type="text" style="width: 308px" name="title4" size="20">&nbsp;group:</span> <span lang="en-us">&nbsp;<select name="group2" onchange="get_sub_groups(this.value)">
								<?php echo $ad_groups; ?>
							</select>&nbsp;sub group:
							<select name="sub_group2">
								<?php echo $ad_sub_groups; ?>
							</select></span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
		<span lang="en-us">
		<input name="Button4" type="button" value="product"></span></td>
					</tr>
					<tr>
						<td style="width: 121px" class="style17"><strong>
						<span lang="en-us">p</span> 
						5</strong></td>
						<td style="width: 1384px">
		<span lang="en-us">
						&nbsp;</span>&nbsp;&nbsp; <span lang="en-us">
							<input type="text" style="width: 308px" name="title5" size="20"></span> 
		<span lang="en-us">
						group:</span> <span lang="en-us">&nbsp;<select name="group3" onchange="get_sub_groups(this.value)">
								<?php echo $ad_groups; ?>
							</select>&nbsp;sub group&nbsp;
							<select name="sub_group3">
								<?php echo $ad_sub_groups; ?>
							</select></span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
		<span lang="en-us">
		<input name="Button5" type="button" value="product"></span></td>
					</tr>
					<tr>
						<td style="width: 121px">&nbsp;</td>
						<td style="width: 1384px">&nbsp;</td>
					</tr>
					<tr>
						<td style="width: 121px">&nbsp;</td>
						<td style="width: 1384px"><span lang="en-us">announce 
						text</span></td>
					</tr>
					<tr>
						<td style="width: 121px">&nbsp;</td>
						<td style="width: 1384px"><span lang="en-us">
							<textarea name="text" style="height: 175px; width: 365px" rows="1" cols="20"></textarea>
						</span></td>
					</tr>
					<tr>
						<td style="width: 121px">&nbsp;</td>
						<td style="width: 1384px">&nbsp;</td>
					</tr>
					<tr>
						<td style="width: 121px">&nbsp;</td>
						<td style="width: 1384px">&nbsp;<span lang="en-us">name:</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						<span lang="en-us">
							<input type="text" style="width: 300px" name="name" size="20"></span>&nbsp; </td>
					</tr>
					<tr>
						<td style="width: 121px">&nbsp;</td>
						<td style="width: 1384px">&nbsp;</td>
					</tr>
					<tr>
						<td style="width: 121px">&nbsp;</td>
						<td style="width: 1384px">&nbsp; :&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						<span lang="en-us">
							<input type="text" style="width: 300px" name="descr" size="20"></span> 
						</td>
					</tr>
					<tr>
						<td style="width: 121px">&nbsp;</td>
						<td style="width: 1384px">&nbsp;</td>
					</tr>
					<tr>
						<td style="width: 121px">&nbsp;</td>
						<td style="width: 1384px"><span lang="en-us">tel</span>:&nbsp;&nbsp;&nbsp; <span lang="en-us">
							<input type="text" style="width: 300px" name="tel" size="20"></span></td>
					</tr>
					<tr>
						<td style="width: 121px; height: 39px;"></td>
						<td style="width: 1384px; height: 39px;"></td>
					</tr>
					<tr>
						<td style="height: 26px; width: 121px;">&nbsp;</td>
						<td style="height: 26px; width: 1384px;">
						<span lang="en-us">city</span>:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; <span lang="en-us">
							<input type="text" style="width: 300px" name="city" size="20"></span></td>
					</tr>
					<tr>
						<td style="width: 121px">&nbsp;</td>
						<td style="width: 1384px">&nbsp;</td>
					</tr>
					<tr>
						<td style="height: 16px; width: 121px;">&nbsp;</td>
						<td style="height: 16px; width: 1384px;">
						Address:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;
						<span lang="en-us">
							<input type="text" style="width: 300px" name="address" size="20"></span></td>
					</tr>
					<tr>
						<td style="height: 16px; width: 121px;">&nbsp;</td>
						<td style="height: 16px; width: 1384px;">&nbsp;</td>
					</tr>
					<tr>
						<td style="height: 16px; width: 121px;">&nbsp;</td>
						<td style="height: 16px; width: 1384px;">
						<span lang="en-us">link</span>:<span lang="en-us"><input type="text" style="width: 300px" name="link" size="20">//:http</span></td>
					</tr>
					<tr>
						<td style="height: 16px; width: 121px;">&nbsp;</td>
						<td style="height: 16px; width: 1384px;">&nbsp;</td>
					</tr>
					<tr>
						<td style="height: 26px; width: 121px;">&nbsp;</td>
						<td style="height: 26px; width: 1384px;">
						<span lang="en-us">type</span>:&nbsp; <span lang="en-us">
							&nbsp;
							</span>&nbsp;&nbsp;&nbsp; <span lang="en-us">
							<select name="type" onclick="calc_price()">
								<option selected="" value="free">free</option>
								<option value="express">??????</option>
							</select>
						</span></td>
					</tr>
					<tr>
						<td style="width: 121px">&nbsp;</td>
						<td style="width: 1384px"></td>
					</tr>
					<tr>
						<td style="width: 121px">&nbsp;</td>
						<td style="width: 1384px">Duration:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						<span lang="en-us">
							<select name="duration" onclick="calc_price()">
								<?php echo $durations; ?>
							</select>
						</span></td>
					</tr>
					<tr>
						<td style="width: 121px">&nbsp;</td>
						<td style="width: 1384px">&nbsp;</td>
					</tr>
					<tr>
						<td style="width: 121px">&nbsp;</td>
						<td style="width: 1384px">Stars:&nbsp;&nbsp;&nbsp;&nbsp; <span lang="en-us">
							<select name="stars" style="width: 32px" onclick="calc_price()">
								<option>0</option>
								<option>1</option>
								<option>2</option>
								<option>3</option>
								<option>4</option>
								<option>5</option>
								<option>6</option>
								<option>7</option>
							</select></span></td>
					</tr>
					<tr>
						<td style="width: 121px">&nbsp;</td>
						<td style="width: 1384px">&nbsp;</td>
					</tr>
					<tr>
						<td style="width: 121px">&nbsp;</td>
						<td style="width: 1384px"><span lang="en-us">
							<input type="submit" value="send">
						</span></td>
					</tr>
					<tr>
						<td style="width: 121px">&nbsp;</td>
						<td style="width: 1384px">&nbsp;</td>
					</tr>
					<tr>
						<td style="width: 121px">&nbsp;</td>
						<td style="width: 1384px">&nbsp;</td>
					</tr>
					<tr>
						<td style="width: 121px">&nbsp;</td>
						<td style="width: 1384px">&nbsp;</td>
					</tr>
				</table>
			</form>
		</span><td width='10' valign='top'></td></td></tr></table></div></td><td bgcolor='#FFFFFF' width='150' valign='top' align=center><p align=center></td><td width='4' valign='top'></td></tr></table></center></div>
</body></html>
add_new_ad.php:
Code:
<?php
  include("../config.php");
  include("jdf.php");

  mysql_connect($db_server, $db_username, $db_password);
  mysql_select_db($db_name);

  $query = "SET NAMES 'utf8'";
  mysql_query($query);

  $query = "SELECT * FROM settings";
  $result = mysql_query($query);
  
  if (mysql_num_rows($result))
    {
    $row = mysql_fetch_array($result);
    $site_name = $row['SiteName'];
    $side_bar  = $row['SideBar'];
    }

  $today = jdate("l");
  $today .= " " . jdate("y/m/d");
  $groups = get_groups();

  $authorized = check_authorization();
  if ($authorized)
    {
    $title = "";
    $text = "";
    add_new_ad();
    }
  else
    header("location:login.php");

  function check_authorization()
  {
    session_start();
    if (isset($_SESSION['uname']) && isset($_SESSION['upass']))
      return true;
    else
      return false;
  }

  function get_groups()
  {
    $query = "SELECT * FROM groups";
    $result = mysql_query($query);

    $groups_html = "";
    while (($row = mysql_fetch_array($result)))    
      {
      $name = $row['Name'];
      $id   = $row['ID'];
      $groups_html .= "<a href=\"../main_group.php?id=$id\"><img src=%22../images/fbrows4R.gif\">&nbsp;$name</a><br>";
      }

    return $groups_html;
  }

  function add_new_ad()
  {
    $group      = $_POST['group'];
    $sub_group  = $_POST['sub_group'];
    $sub_group2 = $_POST['sub_group2'];
    $sub_group3 = $_POST['sub_group3'];
    $sub_group4 = $_POST['sub_group4'];
    $sub_group5 = $_POST['sub_group5'];    
    $title      = trim($_POST['title']);
    $title2     = trim($_POST['title2']);
    $title3     = trim($_POST['title3']);	
    $title4     = trim($_POST['title4']);
    $title5     = trim($_POST['title5']);
    $title5     = trim($_POST['title5']);    

    $descr      = trim($_POST['descr']);    
    $text       = $_POST['text'];
    $name       = $_POST['name'];
    $tel        = $_POST['tel'];
    $city       = $_POST['city'];
    $address    = $_POST['address'];
    $type       = $_POST['type'];
    $duration   = $_POST['duration'];
    $link       = $_POST['link'];
    $stars      = $_POST['stars'];

    $uname = $_SESSION['uname'];
    $price = calc_price();
    $date  = jdate("ymd");

    $query = "SELECT Balance, ID FROM users WHERE Username='$uname'";
    $result = mysql_query($query);			
    $row = mysql_fetch_array($result);
    $balance = $row['Balance'];

    if ($price > $balance)
      {
      $GLOBALS['msg'] = "??? ?????? ???? ???? ??? ??? ???? ??????.";
      return;
      }
    else
      {
      $userid = $row['ID'];
      $query  = "INSERT INTO ads ('ID', 'UserID',    'GroupID',    'GroupID2',    'GroupID3',    'GroupID4',    'GroupID5',  'Title', 'Title2', 'Title3', 'Title4', 'Title5', 'Descr',  'Text',  'Name','Email','Tel','City' , 'Address', 'Type',  'Duration',  'Date','ExpireDate','SpecialFrom','Stars' ,'Status','Views','Image','mode','Link') ";
      $query .=          "VALUES (NULL,'$userid', '$sub_group', '$sub_group2', '$sub_group3', '$sub_group4', '$sub_group5', '$title','$title2','$title3','$title4','$title5','$descr', '$text', '$name',        $tel , $City , $address ,'$type', '$duration', '$date', NULL                     ,'$stars',     '1', 0     , NULL  ,    1 , $link     )";
      mysql_query($query);

      $GLOBALS['title'] = $title;
      $GLOBALS['text']  = $text;
      $GLOBALS['text']  = str_replace("\n", "<br>", $GLOBALS['text']);
      $GLOBALS['msg']   = "Registered your announce";
      }
  }

  function calc_price()
  {
    $type     = $_POST['type'];
    $duration = $_POST['duration'];
    $stars    = $_POST['stars'];

    $price = 0;
    $query = "SELECT Fee FROM durations WHERE AdType=$type and ID=$duration";
    $result = mysql_query($query);
    if (mysql_num_rows($result))
      {
      $row = mysql_fetch_array($result);
      $price = $row['Fee'];
      }

    $query = "SELECT Fee FROM stars WHERE Star=$stars";
    $result = mysql_query($query);
    if (mysql_num_rows($result))
      {
      $row = mysql_fetch_array($result);
      $price += $row['Fee'];
      }

    return $price;
  }

?>

<html dir='ltr' xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office"><header><META NAME='distribution' CONTENT=''> <meta http-equiv='Content-Language' content='fa'><meta http-equiv='Content-Type' content='text/html; charset=utf-8'><meta name='Author' content='Hadi Fanaee'><META NAME='robots' CONTENT='index, follow'><META NAME='revisit-after' CONTENT='1 days'><style>body{FONT-SIZE: 10pt ; FONT-FAMILY: Tahoma ;background-color:#FFFFFF;color:#llllll}
index_body{FONT-SIZE: 10pt ; FONT-FAMILY: Tahoma ;background-color:#FFFFFF;background-image:url('../images/00000000.txt')}
input{FONT-SIZE: 10pt ; FONT-FAMILY: Tahoma}
select{FONT-SIZE: 10pt ; FONT-FAMILY: Tahoma}
textarea{FONT-SIZE: 10pt ; FONT-FAMILY: Tahoma}
table{FONT-SIZE: 10pt ; FONT-FAMILY: Tahoma}
A:hover {COLOR: #FF0000; TEXT-DECORATION: none}
A {	COLOR: #00008b; TEXT-DECORATION: none}
.text_small  { font-size: 10px  }
.text_big  { font-size: 14pt  }
.index_main{border-collapse: collapse; font-size: 10pt ; background-color:#FFFFFF;background-image:url('../images/bkpic000.gif'); color:#llllll}
.index_table{border-collapse: collapse; font-size:10pt ; background-color:#F0F0F0; color:}
.index_table_inner{border-collapse: collapse; font-size:10pt ;color:}
.index_table_title{color:; font-size:10pt ; text-align:center}
.button1{font-family: Tahoma; font-size: 10pt ; color:   }
.input1{font-family: Tahoma; font-size: 10pt ; color:   }
.index_table_button{font-family: Tahoma; font-size: 10pt ; color:   }
.index_table_input{font-family: Tahoma; font-size: 10pt ; color:   }
.index_header{color:;  font-size:10pt ; text-align:center}
.index_menubar{background-image: url('../images/tmenubar.gif'); color:#384EA0;   font-size:10pt ; text-align:center}
.text2  { color:#00008b  }
.text3 { color:#0000ff  }
.text4 {   }
.hr{color:#0066CC}
.tblheaderbg{background-color:#F0F0F0;}
.tblheader{border:1px solid #F0F0F0; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma}
.block_title{color:#480580; font-size:10px ; text-align:Center}
.style7 {
	color: #FF0000;
}
</style>

<script type="text/javascript">
<?php echo $js; ?>
</script>

<body onresize='buildsubmenus_horizontal();buildsubmenus()' background='../images/bg000000.gif' leftmargin='0' topmargin='0'><script language='JavaScript' src='../images/farsi000.js'></script><meta http-equiv='Content-Type' content='text/html; charset=utf-8'>

<link rel="stylesheet" type="text/css" href="../images/style000.css">
<div style="width: 980px; float: right;" dir="rtl">

<div align='center'><table dir='rtl' border='0' cellpadding='0' cellspacing='0' width='100%' class='index_main'><td width='4' valign='top'></td><td bgcolor='#FFFFFF'  width='150' valign='top'>
	&nbsp;</td><td width='10' valign='top'></td><td dir='rtl' background='../images/bkpic000.gif' width='99%' class='index_main' align=center valign='top'><div align=center><table border='0' cellpadding='0' cellspacing='0'  class='index_main' width='98%'><tr><td height='6' width='100%'></tr><tr><td width='100%'><title>...???? ????? ??????? ???????? ?????? ...  </title><link rel='stylesheet' type='text/css' href='../images/style000.css'><DIV style="MARGIN-TOP: 3px; FLOAT: left; WIDTH: 100%">
<TABLE class=picc cellSpacing=0 cellPadding=0 width="100%">
  <TBODY>
  <TR>
    <TD class=ghd colSpan="4">users control panel</TD></TR></TBODY></TABLE>
		<table style="width: 100%">
			<tr>
				<td>&nbsp;</td>
			</tr>
			<tr>
				<td class="style7"><span lang="en-us"><?php echo $msg; ?></span></td>
			</tr>
			<tr>
				<td>&nbsp;</td>
			</tr>
			<tr>
				<td><span lang="en-us">
				<font color="red"><?php echo $title; ?></font>
				</span></td>
			</tr>
			<tr>
				<td>&nbsp;</td>
			</tr>
			<tr>
				<td><span lang="en-us">
				<?php echo $text; ?>
				</span></td>
			</tr>
</table>
		</div>
		<td width='10' valign='top'></td></td></tr></table></div></td><td bgcolor='#FFFFFF'  width='150' valign='top' align=center><p align=center></td><td width='4' valign='top'></td></tr></table></center></div>
</body></html>
my field in the ads table is the same as:

('ID','UserID','GroupID','GroupID2','GroupID3','Gr oupID4','GroupID5',
'Title','Title2','Title3','Title4','Title5','Descr ','Text','Name','Email'
,'Tel','City','Address','Type','Duration','Date',' ExpireDate','SpecialFrom'
,'Stars','Status','Views','Image','mode','Link').

I will be glad if you answer.
tanks.
Reply With Quote
  #2  
Old 06-20-2009, 09:20 AM
BMR777 BMR777 is offline
Member
 
Join Date: Jan 2011
Posts: 1,122
Gender: Male
Credits: 10,765
BMR777 is on a distinguished road
Default RE: i can,t insert information please help me.

The code you posted is not from my Adoptables Script. You sure you have the right forums? I only provide support for my Rusnak PHP Adoptables Script here, not for competing products.

Brandon
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
insert flash / .swf files voni Questions and Supports 7 06-15-2014 10:55 AM
Insert Issue SilverDragonTears Questions and Supports 4 02-12-2013 06:38 AM
Insert Data/Tables Trouble AlexC Programming and Game Development 2 05-03-2012 07:44 PM
Footer Information Canaille Questions and Supports 6 09-06-2011 06:33 PM
Can't retain adoptable information Kyris Questions and Supports 9 01-27-2011 09:08 AM


All times are GMT -5. The time now is 03:36 AM.

Currently Active Users: 9671 (0 members and 9671 guests)
Threads: 4,080, Posts: 32,024, Members: 2,016
Welcome to our newest members, jolob.
BETA





What's New?

What's Hot?

What's Popular?


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
vBCommerce I v2.0.0 Gold ©2010, PixelFX Studios
vBCredits I v2.0.0 Gold ©2010, PixelFX Studios
Emoticons by darkmoon3636