Inserting parameter into a form field

Expand|Select|Wrap|Line Numbers

 
<form enctype="multipart/form-data" action="add_acq.php" method="POST"> 

<p align="center" style="margin-bottom: 0"><font face="Arial">Enter 

EPS userid:</font></p>

<p align="center" style="margin-top: 0; margin-bottom: 0"><font face="Arial"><input type="text" name="userid" size="20"> 

<br>

<p align="center"><i><b><font face="Verdana" size="4" color="#003399">

Engineering Property System - Upload a File</font></b></i></p>

<br> 

<p align="center">Select a File:</font></p>

<p align="center" style="margin-top: 0"><font face="Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 

<input type="file" name="filename" size="20"></font></p>

<p align="center" style="margin-bottom: 0"><font face="Arial">File Description:</font></p>

<p align="center" style="margin-top: 0"><font face="Arial"> 

<input type="text" name = "descrip" size="20"></font></p>

<p align="center"> 

<input type="submit" value="Upload File"></p>

</form>

</html>

This goes to:

add_acq.php

<?php 

//This is the directory where images will be saved 

$target = "E:/docs/acq08/".$HTTP_POST_FILES['filename']['name'];

//This gets all the other information from the form 

$userid=$_POST['userid'];

$descrip=$_POST['descrip']; 

$file=($_FILES['filename']['name']); 

// Connects to the Database 

if ($c=OCILogon("eps_attach", "eps_attach", "epsdev")) 

{

  echo "Successfully connected to EPS.\n <BR/><BR/>";

} 

else 

{

  $err = OCIError();

  echo "Oracle Connection Error <BR/>" . $err[text];

} 

//Writes the information to the database 

$s = OCIParse($c, "insert into eps.upload_attach values ('$userid', '$file', '$descrip', sysdate, 'ACQ', null)");

OCIExecute($s, OCI_DEFAULT);

//echo "EPS Attachment record created.<BR/>\n"; 

OCICommit($c);

//Writes the file to the server 

if(move_uploaded_file($_FILES['filename']['tmp_name'], $target)) 

{ 

//Tells you if its all ok 

echo "Your file ". basename( $_FILES['uploadedfile']['name']). " has been uploaded, and your information has been added.<BR/><BR/>Please close this window, and Save the information in EPS.<BR/><BR/>"; 

} 

else { 

//Gives an error if it is not 

echo "Sorry, there was a problem uploading your file.<BR/> <BR/> <BR/> <BR/> <BR/> <BR/>"; 

} 

?>

This is being run on a windows 2003 Server Enterprise RC 2 machine.
The issue is the following. We want to pull the userid parameter from the url used to call this form. To take the userid parametere from the url, and insert into userid field on the form and pass it to the php.
any help would be much appriciated

Jul 18 '08 #1

Subscribe Post Reply

2307

pbmods

5,821

Expert 4TB

Heya, Gaxman.

To use a variable from the URL, use $_GET. To use a variable from the post form submission, use $_POST.

Jul 18 '08 #2

gaxman

Appriciate the advice, but can you show me in code. What am i supposed to put in the form? value="_$GET['userid']" doesnt work and do i set form method as get or post. Also, What abut the HTTP_POST_FILES will get affect that function, because doing what you said still doesnt work? what about parse_url()?

Jul 22 '08 #3

pbmods

5,821

Expert 4TB

You'll want to do this:

Expand|Select|Wrap|Line Numbers

 
<input type="text" name="userid" size="20" value="<?php echo $_GET['userid']; ?>">

That will only work once, though, because the form submits the userid via post. Instead, you should consider doing this:

Expand|Select|Wrap|Line Numbers

 
<form enctype="multipart/form-data" action="add_acq.php?userid=<?php echo $_GET['userid']; ?>" method="POST">

Jul 23 '08 #4

gaxman

still not working properly
any other ideas?

Jul 23 '08 #5

pbmods

5,821

Expert 4TB

What is it doing instead of what you want it to be doing?

Jul 24 '08 #6

gaxman

when i put your code in and i put the value of userid in and i hit the upload button it doesnt goto add.php and connect etc. What it does after i click upload is it brings up a window asking to open or save add.php. What i want this script to do is the following:
1. Grab userid from url. Then the user will browse for file, and put a description in that field. Then click upload. It will then take that information and post it to add.php and connect to the database, insert userid/description of file/etc into the table, then save and exit.
I know this can be done, any help will be greatly appriciated.

Jul 24 '08 #7

pbmods

5,821

Expert 4TB

Try storing the User ID in the session instead of trying to pass it in between forms.

Jul 25 '08 #8

gaxman

could you please show me code or be a little more detailed with your answer please. would appriciate it

Jul 28 '08 #9

pcfreak30

you can look up tons of php session tutorials. I will show you though.

Expand|Select|Wrap|Line Numbers

 
<form enctype="multipart/form-data" action="add_acq.php" method="POST"> 

<p align="center" style="margin-bottom: 0"><font face="Arial">Enter 

EPS userid:</font></p>

<p align="center" style="margin-top: 0; margin-bottom: 0"><font face="Arial"><input type="text" name="userid" size="20"> 

<br>

<p align="center"><i><b><font face="Verdana" size="4" color="#003399">

Engineering Property System - Upload a File</font></b></i></p>

<br> 

<p align="center">Select a File:</font></p>

<p align="center" style="margin-top: 0"><font face="Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 

<input type="file" name="filename" size="20"></font></p>

<p align="center" style="margin-bottom: 0"><font face="Arial">File Description:</font></p>

<p align="center" style="margin-top: 0"><font face="Arial"> 

<input type="text" name = "descrip" size="20"></font></p>

<p align="center"> 

<input type="submit" value="Upload File"></p>

</form>

</html>

This goes to:

add_acq.php

<?php 

//Start the session
 
session_start();
 
//This is the directory where images will be saved 

$target = "E:/docs/acq08/".$HTTP_POST_FILES['filename']['name'];

//This gets all the other information from the form 

$userid=$_POST['userid'];

$descrip=$_POST['descrip']; 

$file=($_FILES['filename']['name']); 

// Connects to the Database 

if ($c=OCILogon("eps_attach", "eps_attach", "epsdev")) 

{

  echo "Successfully connected to EPS.\n <BR/><BR/>";

} 

else 

{

  $err = OCIError();

  echo "Oracle Connection Error <BR/>" . $err[text];

} 

//Writes the information to the database 

$s = OCIParse($c, "insert into eps.upload_attach values ('$userid', '$file', '$descrip', sysdate, 'ACQ', null)");

OCIExecute($s, OCI_DEFAULT);

//echo "EPS Attachment record created.<BR/>\n"; 

OCICommit($c);

//Writes the file to the server 

if(move_uploaded_file($_FILES['filename']['tmp_name'], $target)) 

{ 
 
// Put the userid variable in the session, making a session variable

$SESSION["userid"]= $HTTP_POST_FILES['filename']['name'];
 
//Tells you if its all ok 

echo "Your file ". basename( $_FILES['uploadedfile']['name']). " has been uploaded, and your information has been added.<BR/><BR/>Please close this window, and Save the information in EPS.<BR/><BR/>"; 

} 

else { 

//Gives an error if it is not 

echo "Sorry, there was a problem uploading your file.<BR/> <BR/> <BR/> <BR/> <BR/> <BR/>"; 

} 

?>

Jul 28 '08 #10

gaxman

you can look up tons of php session tutorials. I will show you though.

Expand|Select|Wrap|Line Numbers

<form enctype="multipart/form-data" action="add_acq.php" method="POST">

Enter

EPS userid:

<input type="text" name="userid" size="20">

 



Engineering Property System - Upload a File

 

Select a File:

                      

<input type="file" name="filename" size="20">

File Description:



<input type="text" name = "descrip" size="20">



<input type="submit" value="Upload File">

</form>

</html>

This goes to:

add_acq.php

<?php

//Start the session

session_start();

//This is the directory where images will be saved

$target = "E:/docs/acq08/".$HTTP_POST_FILES['filename']['name'];

//This gets all the other information from the form

$userid=$_POST['userid'];

$descrip=$_POST['descrip'];

$file=($_FILES['filename']['name']);

// Connects to the Database

if ($c=OCILogon("eps_attach", "eps_attach", "epsdev"))

{

 echo "Successfully connected to EPS.\n ";

}

else

{

 $err = OCIError();

 echo "Oracle Connection Error " . $err[text];

}

//Writes the information to the database

$s = OCIParse($c, "insert into eps.upload_attach values ('$userid', '$file', '$descrip', sysdate, 'ACQ', null)");

OCIExecute($s, OCI_DEFAULT);

//echo "EPS Attachment record created. \n";

OCICommit($c);

//Writes the file to the server

if(move_uploaded_file($_FILES['filename']['tmp_name'], $target))

{

// Put the userid variable in the session, making a session variable

$SESSION["userid"]= $HTTP_POST_FILES['filename']['name'];

//Tells you if its all ok

echo "Your file ". basename( $_FILES['uploadedfile']['name']). " has been uploaded, and your information has been added. Please close this window, and Save the information in EPS. ";

}

else {

//Gives an error if it is not

echo "Sorry, there was a problem uploading your file. ";

}

?>

That didnt fix the problem. Just curiuosly are you guys testing what you tell me or just giving suggestions?
Please test, i would much appriciate it.

Jul 29 '08 #11

gaxman

the issue is that everytime i click upload file it doenst run the add_acq.php. it just brings up the window to open the php file or save it or to cancel. why is it doing this any ideas?

Jul 29 '08 #12

pbmods

5,821

Expert 4TB

You need to configure your webserver to execute PHP files.

Are you running Apache or IIS?

Jul 31 '08 #13

gaxman

lol, this script works w/o the userid stuff and i already have that enabled. please test this out and any other help would be appriciated

Jul 31 '08 #14

gaxman

anyone have any other ideas i would greatly appriciate it?

Aug 5 '08 #15

samikhan83

hi gaxman .....
According to wat i understood from ur question.....

i have a suggestion....

first u have to get ur data from url..... that can be done using $_REQUEST[] or $_GET[]

lets say ur URL is http://localhost/sample.php?id=123456

u get ur id by

$id=$_GET["id"]; or $id=$_REQUEST["id"];

then u want it in ur id field

u can or put it in ur id text field .....

<input type="text" name="txt_id" value="<?=$id?>" size="20">

or u can directly put the value in text field

<input type="text" name="txt_id" value="<?=$_GET["id"]?>" size="20">

then u can get the id value in php by wat method ur using to post from data like get or post

for get
$id=$_GET["txt_id"];

for post
$id=$_POST["txt_id"]

Aug 6 '08 #16

gaxman

thank you for timely reply. The problem when everyone tells me to put php in the value field for the text box is the following

Expand|Select|Wrap|Line Numbers

 
<html>

<?

$userid = $_REQUEST["userid"];

?>

<form enctype="multipart/form-data" action="http://eps09.ccc.northgrum.com/upload/test_add.php" method="POST">

<p align="center" style="margin-bottom: 0"><font face="Arial">Enter 

EPS userid:</font></p>

<p align="center" style="margin-top: 0; margin-bottom: 0"><font face="Arial"><input type="text" name="userid" value="<?=$id?>" size="20"> 

<br>

is that for the value on the page in the box what shows is <?=$id?>. No matter if i put <?php $id?> or <?php echo $id ?> it always put the php code in there, it never pulls the value. Any ideas why its doing this?

Aug 6 '08 #17

samikhan83

if ur extracting the field value in the same page the in from tag u have to use

<?php echo $_SERVER['PHP_SELF']?> in the action field of the form

<form action="<?php echo $_SERVER['PHP_SELF']?>" method="post" name="frm_pr_entry" id="frm_pr_entry">

Aug 6 '08 #18

gaxman

i think your misguided if you can please re-read my original post to see
again this is what i am trying to do
When the user opens upload_acq.html :

Expand|Select|Wrap|Line Numbers

 
<form enctype="multipart/form-data" action="add_acq.php" method="POST">

<p align="center" style="margin-bottom: 0"><font face="Arial">Enter

EPS userid:</font></p>

<p align="center" style="margin-top: 0; margin-bottom: 0"><font face="Arial"><input type="text" name="userid" size="20">

<br>

<p align="center"><i><b><font face="Verdana" size="4" color="#003399">

Engineering Property System - Upload a File</font></b></i></p>

<br>

<p align="center">Select a File:</font></p>

<p align="center" style="margin-top: 0"><font face="Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

<input type="file" name="filename" size="20"></font></p>

<p align="center" style="margin-bottom: 0"><font face="Arial">File Description:</font></p>

<p align="center" style="margin-top: 0"><font face="Arial">

<input type="text" name = "descrip" size="20"></font></p>

<p align="center">

<input type="submit" value="Upload File"></p>

</form>

</html>

it is going to as you open the page put http://www.myserver.com?userid=usern...sonopeningpage. I want the script to the put the usernameofpersonopeningpage to be passed into the form in a hidden field. Then when the user selects the file for upload and gives it a description have all three (usernameofpersonopeningpage,filename,description) pass to add_acq.php. Here it will take these fields, connect to oracle, and insert all three of those into the table and disconnect. So above at the beginning of this thread is the full code for both of the .html and .php files. If you can show me code i would be much appriciated. Thanks

Aug 6 '08 #19

samikhan83

This is the code .... but i strictly suggest that dont just copy the code examine it and do some thinking and use it....

this is wat i did for uploading some product.... image and its description..
wat i am doing is making the uploaded image round cornored with white color as background...

this is only for .jpg image for format you can do some changes using imagecreatefrom fucntion of php for jpg imagecreatefromjpeg(); for png imagecreatefrompng(); and gif imagecreatefromgif()....

Expand|Select|Wrap|Line Numbers

  
<?php

require_once("../comman/connection.php");

require_once("product_group_func.php");

require_once("product_func.php");

$conn=connect();
 
if(isset($_POST["btn_sub"]))

{
 
//get data from form
 
$pro_grp=trim($_POST["sel_pr_grp"]);

$pro_code=trim($_POST["txt_pr_code_add"]);

$pro_name=trim($_POST["txt_pr_name_add"]);

$pro_desc=trim($_POST["txt_pr_desc_add"]);

$pro_price=trim($_POST["txt_pr_price_add"]);

$pro_manu=trim($_POST["txt_pr_manu_add"]);

$save="";

$save_t="";
 
//validation in php
 
    if ($pro_grp=="none")

    {

        $errors[] = 'Please Select The Product Group For Product';

    }
 
    if (empty($pro_code))

    {

        $errors[] = 'Please Enter The Product Code';

    }
 
    if (empty($pro_name))

    {

        $errors[] = 'Please Enter The Product Name';

    }
 
    if (empty($pro_desc))

    {

        $errors[] = 'Please Enter The Product Description';

    }
 
    if (empty($pro_price))

    {

        $errors[] = 'Please Enter The Product Price';

    }

    else if (!is_numeric($pro_price))

    {

    $errors[] = 'Please Enter The Price Without $ sign';

    }
 
    if (empty($pro_manu))

    {

        $errors[] = 'Please Enter The Product Manufaturer';

    }
 
    if (count($errors) == 0)

    {
 
        if (isset ($_FILES['pr_file_add'])){

              $imagename = $_FILES['pr_file_add']['name'];

              $source = $_FILES['pr_file_add']['tmp_name'];

              $target = "images/full_images/".$imagename;

              move_uploaded_file($source, $target);
 
              $imagepath = $imagename;

              $save = "images/full_images/" . $imagepath; //This is the new file you saving

              $file = "images/full_images/" . $imagepath; //This is the original file
 
              list($width, $height) = getimagesize($file) ; 
 
              $modwidth = 400; 
 
              $diff = $width / $modwidth;
 
              //$modheight = $height / $diff; 

              $modheight = 400;
 
              $tn = imagecreatetruecolor($modwidth, $modheight) ; 

              $image = imagecreatefromjpeg($file) ; 
 
               imagecopyresampled($tn, $image, 0, 0, 0, 0, $modwidth, $modheight, $width, $height) ; 

               $white  = ImageColorAllocate ($tn, 255, 255, 255);
 
              imagearc($tn, 33, 33, 70, 70,  180, 270, $white);

              imagearc($tn, 366, 366, 70, 70,  360, 90, $white);

              imagearc($tn, 33, 366, 70, 70,  90, 180, $white);

              imagearc($tn, 366, 33, 70, 70,  270, 0, $white);
 
              imagefilltoborder ($tn, 0, 0, $white, $white);

              imagefilltoborder ($tn, 400, 0, $white, $white);

              imagefilltoborder ($tn, 0, 400, $white, $white);

              imagefilltoborder ($tn, 400, 400, $white, $white);
 
              imagejpeg($tn, $save, 100) ; 
 
              $save_t = "images/thumb_nails/sml_" . $imagepath; //This is the new file you saving

              $file = "images/full_images/" . $imagepath; //This is the original file
 
              list($width, $height) = getimagesize($file) ; 
 
              $modwidth = 100; 
 
             // $diff = $width / $modwidth;
 
              //$modheight = $height / $diff; 
 
              $modheight = 100;

              $tn = imagecreatetruecolor($modwidth, $modheight) ; 

              $image = imagecreatefromjpeg($file) ; 

              imagecopyresampled($tn, $image, 0, 0, 0, 0, $modwidth, $modheight, $width, $height) ; 
 
              imagejpeg($tn, $save_t, 100) ; 

              begin();

              if(ins_pr($pro_code,$pro_name,$pro_desc,$pro_price,$pro_manu,$save,$save_t,$pro_grp))

              {

                commit();

                $pro_grp="";

                $pro_code="";

                $pro_name="";

                $pro_desc="";

                $pro_price="";

                $pro_manu="";

                $errors[]="Product Added Successfully";
 
               }

              else

              {

              rollback();

              $errors[]="Please Select The Proper Data";

              }
 
          }
 
    else

    {

        $errors[] = 'Please Select The Image To Be Uploaded';

    }
 
    }
 
}
 
?>

<!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=utf-8" />

<title>Untitled Document</title>

<link href="admin.css" rel="stylesheet" type="text/css" />

<script language="javascript" src="Add_Tech_Specs.js" type="text/javascript"></script>

</head>
 
<body>

<div id="container">

<div id="header"><h1>

Administrator Control Panel <br/>

<span>Add Product</span></h1></div>

<div id="top_nav">

</div>
 
<form action="<?php echo $_SERVER['PHP_SELF']?>" method="post" enctype="multipart/form-data" name="frm_add_pr" id="frm_add_pr">

<span id="back"><a href="javascript:history.go(-1);">back</a></span>

<span style="color:#FF0000; padding-left:300px;"><?=$errors[0]?></span>

<div style="padding-left:200px;">

  <table width="403" border="1" bordercolor="#006600" >

  <tr>

    <td width="166">Product Group*</td>

    <td width="218">

    <select name="sel_pr_grp" id="sel_pr_grp">  

    <option selected="selected" value="none">Select Group</option>

     <?php  $result=sel_pr_grp(); while($row=mysql_fetch_array($result)){?>

<option value="<?=$row[0]?>"><?=$row[2]?></option>

<?php }?>

    </select> </td>

  </tr>

  <tr>

    <td>Product Code*</td>

    <td><input type="text" name="txt_pr_code_add" id="txt_pr_code_add" value="<?=$pro_code?>"/></td>

  </tr>

  <tr>

    <td>Product  Name*</td>

    <td><input name="txt_pr_name_add" type="text" id="txt_pr_name_add" value="<?=$pro_name?>"/></td>

  </tr>

  <tr>

    <td>Product Description *</td>

    <td><textarea name="txt_pr_desc_add" rows="6" wrap="virtual" id="txt_pr_desc_add" ><?=$pro_desc?>

    </textarea></td>

  </tr>

  <tr>

    <td>Product Price*</td>

    <td><input type="text" name="txt_pr_price_add" id="txt_pr_price_add" value="<?=$pro_price?>"/></td>

  </tr>

  <tr>

    <td>Product Manufacturer*</td>

    <td><input type="text" name="txt_pr_manu_add" id="txt_pr_manu_add" value="<?=$pro_manu?>"/></td>

  </tr>

  <tr>

    <td>Product Image*</td>

    <td><input type="file" name="pr_file_add" id="pr_file_add" value="<?=$pr_file_add?>"/></td>

  </tr>
 
</table>
 
<table  border="1" bordercolor="#006600"  width="403" >

<thead>

<tr align="center">

<td colspan="2">

<a href="javascript:Add_Tech_Specs_Func()"><span>Click To Add Techincal Specifications </span></a><input name="spec" id="spec" type="hidden" value="0" /></td>

</tr>

<tr style="text-align:center">

<td width="194">Name</td>

<td width="193">Specification</td>

</tr>
 
</thead>

<tbody id="add_pro_tb">

</tbody>
 
</table>

<table border="1" bordercolor="#006600"  width="403" >
 
<tr>

    <td width="194">Click to Add Product*</td>

    <td width="193"><input name="btn_sub" type="submit" value="Save" />

      <input type="reset" name="btn_clr" id="button" value="Discard" /></td>

  </tr>
 
</table>

</div>

</form>

</div>

</body>

</html>

<?php 
 
disconnect($conn);

?>

Aug 6 '08 #20

pbmods

5,821

Expert 4TB

is that for the value on the page in the box what shows is <?=$id?>. No matter if i put <?php $id?> or <?php echo $id ?> it always put the php code in there, it never pulls the value. Any ideas why its doing this?

Are you seeing the <? $userid = $_REQUEST["userid"]; ?> in the source of the page as well?

Aug 6 '08 #21

gaxman

no it only shows the wuts in the value field
so for instance on the page it shows
<?php echo $userid ?> in the value box

Aug 7 '08 #22

pbmods

5,821

Expert 4TB

I'm confused.

You're sure if you go to View Source in IE or FF you're not seeing the "<? $userid = $_REQUEST["userid"]; ?>" in the source code as well?

I was going to suggest that your server is just treating the script as an HTML document and outputting it without processing it. But if it's processing some of the PHP and not the rest of it, I'm completely baffled.

Aug 7 '08 #23

Inserting parameter into a form field

Similar topics