have a problem in arrays that having multiple forms

annerhexian

hi..

pls help me...
im just new in php and i wish i could learn more.. i needed it for one day or two..hope u can reconsider my questions to you.. pls do help me..

i want my row array will be a column.....

pls see me first my codes:

Expand|Select|Wrap|Line Numbers

 
DATAbase:               

    form1academicbachelor varchar(20) not null,

    form1bachelorschool varchar(20),

    form1bachelorschoolyear varchar(20),

    form1academicMasteral varchar(20) not null,

    form1masteralschool varchar(20),

     form1masteralschoolyear varchar(20),

Expand|Select|Wrap|Line Numbers

  
<?php    

    include 'dbConnect.php';

    mysql_select_db("ranking",$con);
 
    $form1academicbachelor=array();

    $form1bachelorschool=array();

    $form1bachelorschoolyear=array();

    $form1academicMasteral=array();
 
    $form1academicbachelor=$_POST['bacheloracadform1'];

    $form1bachelorschool=$_POST['bachschoolnameform1'];

    $form1bachelorschoolyear=$_POST['bachyeargraduatedform1'];

    $form1academicMasteral=$_POST['masteralacademicsform1'];
 
    $form1academicbachelor=implode(',',$form1academicbachelor);

    $form1bachelorschool=implode(',',$form1bachelorschool);

    $form1bachelorschoolyear=implode(',',form1bachelorschoolyear);

    $form1academicMasteral=implode(',',$form1academicMasteral);
 
echo "<table border=1 cellspacing=0 width = 700>
 
        <tr bgcolor=dddddd>

        <td align=center> <font color=8B0000 size=2><b> Bachelor Degree </b> </font></td>

        <td align=center> <font color=8B0000 size=2><b> School Name </b> </font></td>

        <td align=center> <font color=8B0000 size=2><b> School Year </b> </font></td>

        </td>

";
 
echo'     <tr>

        <td align=center> '.$form1academicbachelor.' </td>

        <td align=center> '.$form1bachelorschool.' </td>

        <td align=center> '.$form1bachelorschoolyear.' </td>
 
        <td align=center>
 
        <span class="style2"><font size=2>
 
        </font></span>
 
        </td>

        </tr>';
 
echo "</table>";
 
?>

ouput:

Expand|Select|Wrap|Line Numbers

 
===============================================

BACHELOR DEGREE  | SCHOOL NAME  | SCHOOL YEAR

===============================================

BSIT,BSM,BEED    | sc1,sc2,sc3  | yy1,yy2,yy3

i want my output that will be like this

Expand|Select|Wrap|Line Numbers

 
==============================================

BACHELOR DEGREE  | SCHOOL NAME  | SCHOOL YEAR

==============================================

BSIT             | sc1          | yy1

BSM              | sc2          | yy2

BEED             | sc3          | yy3

==============================================

MASTERAL DEGREE  | SCHOOL NAME  | SCHOOL YEAR

==============================================

xxxx1            | kk1          | ppp1

xxx2             | kk2          | pp2

pls give me some suggestions in here on how to get like that format..

I really want that the arraybachelorvariable() will be a column and not a row...
and so on with the other.....

hoping for your help and thank you so much in advance..

dlite922

You really need to learn to code right, try doing some online tutorials.

If i had 3 series of data that i needed to put in a column i would do a forlook like this

[PHP]
<table >
<?php
for ($i = 0; $i < count($oneOfMyArrays); $i++)
{
echo "<tr><td>" . $arrayOne[$i] . "</td>
<td>" . $arrayTwo[$i] . "</td>
</td>" . $thirdArr[$i] . "</td></tr>";
}
?>
</table>
[/PHP]

NOTE*: The above assumes you'll always have the same size for all three arrays! There's no error checking for the index.

Hope that helps you.

enumula

Hi

Here is code...Hope this wud help u...

DB file:-

Expand|Select|Wrap|Line Numbers

 
-- phpMyAdmin SQL Dump

-- version 2.6.1

-- http://www.phpmyadmin.net

-- 

-- Host: localhost

-- Generation Time: Jan 18, 2008 at 04:23 PM

-- Server version: 4.1.9

-- PHP Version: 4.3.10

-- 

-- Database: `form`

-- 
 
-- --------------------------------------------------------
 
-- 

-- Table structure for table `bachelor`

-- 
 
DROP TABLE IF EXISTS `bachelor`;

CREATE TABLE `bachelor` (

  `bachelor_id` int(11) NOT NULL auto_increment,

  `form1academicbachelor` varchar(100) NOT NULL default '',

  `form1bachelorschool` varchar(100) NOT NULL default '',

  `form1bachelorschoolyear` varchar(100) NOT NULL default '',

  `form1academicMasteral` varchar(100) NOT NULL default '',

  PRIMARY KEY  (`bachelor_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
 
-- 

-- Dumping data for table `bachelor`

-- 
 
INSERT INTO `bachelor` VALUES (1, 'swetha', 'Keys High School', '2000', 'BRECW');

INSERT INTO `bachelor` VALUES (2, 'Raj', 'HBSP', '2000', 'PG');

dbConnect.php

Expand|Select|Wrap|Line Numbers

 
<?

    $connection_type = "local";
 
    if ($connection_type == "local")

    {

        $db_servername="localhost";        

        $db_username="root";

        $db_password="";

        $db_name="form";

        $db_link = mysql_connect($db_servername, $db_username, $db_password) or die("could not connect to the local atebase server");

        $db= mysql_select_db($db_name,$db_link) or die("Not a valid database");
 
    }

    ?>

function.php

Expand|Select|Wrap|Line Numbers

 
<?php
 
class execute_query

{

    //getting the list of categorys

    function get_result_details($select_query)

    {

        require 'dbConnect.php';

        $results=array();

        $select_query_result=mysql_query($select_query,$db_link) or die(" Not a valid Select Query Category ".mysql_error());

        if(mysql_num_rows($select_query_result) > 0)

        {

            while($get_details=mysql_fetch_array($select_query_result))

            {

                $array_count=count($get_details)/2;

                for($i=0;$i<$array_count;$i++)

                {    

                    $results[]=$get_details[$i];

                }

            }

        }

        //To Free the result set

        mysql_free_result($select_query_result);

        //To Close the connection object

        mysql_close($db_link);

        return $results;

    }
 
    //Insert Query function ....

    function insert_query($insert_query)

    {

        require 'dbConnect.php';

        $insert_id="";

        $insert_query_result=mysql_query($insert_query,$db_link) or die(" Not a valid Insert Query ".mysql_error());

        $insert_id=mysql_insert_id();

        mysql_close($db_link);

        return $insert_id;

    }
 
}

?>

form.php

Expand|Select|Wrap|Line Numbers

 
<?php
 
require 'function.php';
 
?>

<form name='formname' method= post action="insert.php" >

academicbachelor&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type=textbox name="form1academicbachelor" value=""><br>

bachelorschool&nbsp;&nbsp;&nbsp&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type=textbox name="form1bachelorschool" value=""><br>

bachelorschoolyear&nbsp;&nbsp;<input type=textbox name="form1bachelorschoolyear" value=""><br>

academicMasteral&nbsp;&nbsp;&nbsp;&nbsp;<input type=textbox name="form1academicMasteral" value="">

<input type="hidden" name="bachelor">

<input type="submit" name="submit" value="submit" >

<?
 
$query="select * from bachelor";

     $obj_query= new execute_query();

     $type_array=$obj_query->get_result_details($query);
 
$array_length=count($type_array);

$form1academicbachelor=array();

$form1bachelorschool=array();

$form1bachelorschoolyear=array();

$form1academicMasteral=array();
 
echo "<table border=1 cellspacing=0 width = 700>
 
<tr bgcolor=dddddd>

<td align=center> <font color=8B0000 size=2><b> Bachelor ID </b> </font></td>

<td align=center> <font color=8B0000 size=2><b> Bachelor Name </b> </font></td>

<td align=center> <font color=8B0000 size=2><b> School Name </b> </font></td>

<td align=center> <font color=8B0000 size=2><b> School Year </b> </font></td>

<td align=center> <font color=8B0000 size=2><b> Bachelor Masteral </b> </font></td>

</td>

";
 
for($i=0;$i<$array_length;$i++)

{

echo' <tr>

<td align=center> '.$type_array[$i].' </td>

<td align=center> '.$type_array[$i+1].' </td>

<td align=center> '.$type_array[$i+2].' </td>

<td align=center> '.$type_array[$i+3].' </td>

<td align=center> '.$type_array[$i+4].' </td>
 
</tr>';

$i=$i+4;

}
 
echo "</table>";
 
?>

insert.php

Expand|Select|Wrap|Line Numbers

 
<?
 
include 'settings.php';

require 'function.php';

$obj_query= new execute_query();

$form1academicbachelor=$_POST['form1academicbachelor'];

  $form1bachelorschool=$_POST['form1bachelorschool'];

$form1bachelorschoolyear=$_POST['form1bachelorschoolyear'];

$form1academicMasteral=$_POST['form1academicMasteral'];

 $insert="insert into bachelor (form1academicbachelor,form1bachelorschool,form1bachelorschoolyear,form1academicMasteral) values ('$form1academicbachelor','$form1bachelorschool','$form1bachelorschoolyear','$form1academicMasteral')";

$insert_value= $obj_query->insert_query($insert);
 
header("Location:form.php");

exit;

?>

output:-

Expand|Select|Wrap|Line Numbers

 
Bachelor ID  Bachelor Name  School Name  School Year  Bachelor Masteral  

1                        swetha     Keys High School        2000              BRECW  

2                            Raj            HBSP                   2000                  PG

Check it out....

annerhexian

Quote:

Originally Posted by enumula

Hi

Here is code...Hope this wud help u...

...

output:-

Bachelor ID Bachelor Name School Name School Year Bachelor Masteral
1 swetha Keys High School 2000 BRECW
2 Raj HBSP 2000 PG

Check it out....

thnak you for the help it was already solved already..

Atli

Hi annerhexian and enumula.

Please use [code] tags when posting your code examples. (See How to ask a question)

[code=php] ...PHP code goes here... [/code]

Thank you.
Moderator

enumula

Quote:

Originally Posted by Atli

Hi annerhexian and enumula.

Please use [code] tags when posting your code examples. (See How to ask a question)

[code=php] ...PHP code goes here... [/code]

Thank you.

Moderator

Thanku ....
Ill may sure to it frm next time.:-)