Jump to content

Problem in the form of data entry

reza01

By reza01
in PHP Coding Help

Recommended Posts

reza01 Newbie

reza01

Posted
Posted

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.

<?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\"> $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">
	 </td>
					<td style="width: 1384px">
	 </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">
					   
						<input type="text" style="width: 50px" name="title" size="20"> 
	group: 
						<select name="group" onchange="get_sub_groups(this.value)">
							<?php echo $ad_groups; ?>
						</select> sub_group:
						<select name="sub_group">
							<?php echo $ad_sub_groups; ?>
						</select></span>                                                            
	</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">
					 </span>   <span lang="en-us">
						<input type="text" style="width: 50px" name="title2" size="20"> 
	group: 
						<select name="group0" onchange="get_sub_groups(this.value)">
							<?php echo $ad_groups; ?>
						</select> sub_group:
						<select name="sub_group0">
							<?php echo $ad_sub_groups; ?>
						</select></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">
	 <span lang="en-us">  
						<input type="text" style="width: 50px" name="title3" size="20"> group: 
						<select name="group1" onchange="get_sub_groups(this.value)">
							<?php echo $ad_groups; ?>
						</select> sub_group:
						<select name="sub_group1">
							<?php echo $ad_sub_groups; ?>
						</select></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">
					   </span> <span lang="en-us"><input type="text" style="width: 50px" name="title4" size="20"> group:</span> <span lang="en-us"> <select name="group2" onchange="get_sub_groups(this.value)">
							<?php echo $ad_groups; ?>
						</select> sub_group:
						<select name="sub_group2">
							<?php echo $ad_sub_groups; ?>
						</select></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">
					 </span>   <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"> <select name="group3" onchange="get_sub_groups(this.value)">
							<?php echo $ad_groups; ?>
						</select> sub_group
						<select name="sub_group3">
							<?php echo $ad_sub_groups; ?>
						</select></span>                                                            
							</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.

Link to comment
https://forums.phpfreaks.com/topic/163113-problem-in-the-form-of-data-entry/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.