Problem in the form of data entry

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
reza01
Forum Newbie
Posts: 4
Joined: Sat Jun 20, 2009 4:09 am

Problem in the form of data entry

Post 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.
Eric!
DevNet Resident
Posts: 1146
Joined: Sun Jun 14, 2009 3:13 pm

Re: Problem in the form of data entry

Post 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?
Post Reply