Creating SQL table via PHP

Dev Articles Community Forums Sponsor:

Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here

June 16th, 2004, 11:11 AM

KnightRider

Registered User

Join Date: Jun 2004

Posts: 1

Time spent in forums: < 1 sec
Reputation Power: 0

Creating SQL table via PHP

Hi friends,

I am having this problem which I am unable to solve.
I am trying to create a user friendly inventory database.
To create a table, the user enters the number of fields required.
The user clicks submit and (using a form) and is redirected to another page where there are (#of fields)textboxes displayed using a for loop. The user is supposed to type in the required fields and then click submit. It should then output the all the fields. My problem is that how can I access those text fields if I have used a for loop to create them. I know that if I normally give a text box a variable name.. I can then POST it. But here it's in a for loop that get repeated as many times depending on the number of fields selected by the user. Please help..I am trying to figure this out..and am still unsuccessful. Here is the part of the code causing all the problem:

PHP Code:


		
			
function create_table(){ 



global $_REQUEST;

$out.= "<H2><B>Create Table</B></H2>"; 

$out.= "<form action = '?res=tblinfo' method = 'post'> 

Table Name: <input type = 'text' name = 'tablename'/> 

Enter Fields: <input type = 'text' name = 'fields'/>

<input type = 'submit' name = 'submit' value = 'Submit table' /> 

</form>";

return $out;

}





function table_info(){

$out = "<H4><b>{$_POST['tablename']}<b></H4>";

$out.= "<H4><b>Enter Required Fields<b><H4>";

$out.= "<form action = '?res=query' method = 'post'>";

for($i=1; $i<=$_POST['fields']; $i++){

$out.= "<input type = 'text' name = 'field'/><br>";

}

$out.= "<input type = 'submit' name = 'submit' value = 'Submit' />

</form>";



return $out;

Last edited by stumpy : June 18th, 2004 at 01:58 AM. Reason: Please use helpful thread titles, and wrap your code in code tags

June 16th, 2004, 12:06 PM

Pheifel

Contributing User

Join Date: Mar 2004

Location: Denmark

Posts: 174

Time spent in forums: 43 m 46 sec
Reputation Power: 5

if you name the textfields numerical ei from 1 to what-ever-the-user-chooses. Then you can acces it by making an array with the same number of places as the for-loop makes.

June 18th, 2004, 01:21 AM

laidbak

you know how we do

Join Date: Jun 2002

Location: In Tha IE -- San Bernardino COUNTY

Posts: 788

Time spent in forums: 2 h 4 m 2 sec
Reputation Power: 7

I modified your code slightly:

PHP Code:


		
			
<?php

function create_table()

{ 

    $out.= '<H2><B>Create Table</B></H2>'; 

    $out.= '<form action="" method="post">';

    $out.= '<input type="hidden" name="res" value="tblinfo">';

    $out.= 'Table Name: <input type="text" name="tablename"/> 

    # Fields: <input type="text" name="fields"/>

    <input type="submit" value="Submit table"/> 

    </form>';



    return $out;

}



function table_info()

{

    $out = '<H4><b>'.$_POST['tablename'].'<b></H4>';

    $out.= '<H4><b>Enter Required Fields<b><H4>';

    $out.= '<form action="" method="post">';

    $out.= '<input type="hidden" name="res" value="query">';

    for($i=1; $i<=$_POST['fields']; $i++){

        $out.= '<input type="text" name="field[]"/><br>';

    }



    $out.= '<input type="submit" value="Submit"/>

    </form>';

    

    return $out;

}



function show_table()

{

    print '<pre>'; 

    print_r($_POST['field']);

    print '</pre>';

}

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title><?php print ($_POST['res']=='tblinfo') ? 'Display Table' : 'Create Table'; ?></title>

</head>

<body>

<?php

    if ($_POST['res']=='tblinfo') {

        print table_info();

    } elseif ($_POST['res']=='query') {

        show_table(); 

    } else {

        print create_table();

    }

?>

</body>

</html>

You can also test it here: www.laidbak.net/codetest/create_table.php

__________________
__________________________________________________ _
Wil Moore III, MCP | Integrations Specialist | Senior Consultant
Are You Listed...? | DigitallySmooth Inc.

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: