Page 1 of 1

Problem in the form of data entry

Posted: Sun Jun 21, 2009 6:15 am
by reza01
helo
pleas help me.

i have some question about this code.

we have a program that it works with one row(p1-->group-->sub_group) that it work corectly.
now we want chnge it.
we want add 4 row in to this program that it will have(p2,3,4,5-->group-->sub_group).
we changed it but it dident work corectly.
and we want insert a id in the data bais tables for ech sub_groups.

Code: Select all

<?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)
    {
    $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(6);
 
    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;
  
 for (i=0; i<6; i++)
      if (valid_arr[i] == "")
        {
        isvalid = false;
        alert("?? ???? ????? ?????? ?????? ???.");
        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 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>
    </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: 50px" 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;
        </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: 50px" 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; </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: 50px" 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; </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: 50px" 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;
        </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: 50px" 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
                            <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;
                                </table>
            </form>
        </span></td></tr></table></div></td><td width='4' valign='top'></td></tr></table></center></div>
</body></html>
 
i will be glad if you answer to me.
tanks.

Re: Problem in the form of data entry

Posted: Sun Jun 21, 2009 7:17 am
by Eric!
Sorry but with 300+ lines you are going to have to provide more information to get help. What does 'didn't work' mean? Can you provide the details of your problem and what part isn't working?