News:

Wondering if this will always be free?  See why free is better.

Main Menu

i can,t insert information please help me.

Started by reza01, June 20, 2009, 05:57:45 AM

Previous topic - Next topic
Print
Go Down Pages1
User actions

reza01

June 20, 2009, 05:57:45 AM
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_group5.title.
title2.title3.title4.title5.descr.text.name.tel.City.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 Select
<?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 Select
<?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','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').

I will be glad if you answer.
tanks.
Print
Go Up Pages1
User actions
Advertisement: