how to insert value selected in the dropdown to backend?

hello everybody,
i had created a dropdown in which project names will be appeared. and i am getting those project name from backend. Below that dropdown i am having a table of users with a check box.so whenever i select a projectname and click on the checkbox of one user, that projectname and username should store in project assign table. The problem is username is storing but the projectname is not storing in the database. it is displaying that column empty.
so please do the needful.
Thank u.

Expand|Select|Wrap|Line Numbers

 <?php

ob_start();

@session_start();

require_once ("check.php");

createsessions($username,$password,$userid,$projectid);

    $con=mysql_connect("10.70.1.50","invensis","invensis");

    if(!$con)

        {

            die('Could not connect: ' . mysql_error());

        }

    mysql_select_db("database_myproject",$con);

    $sql="SELECT projectname from projects where createdby='".mysql_real_escape_string($_SESSION['username'])."'";

    mysql_error();

    $result=mysql_query($sql);

    $options=""; 

    while ($row=mysql_fetch_array($result)) 

    {

        $id=$row["projectid"];

        $projectname=$row["projectname"];

        $options.="<option value=\"$id\">".$projectname.'</option>';

    }

    $sql2="SELECT * FROM users where reportingto='".mysql_real_escape_string($_SESSION['username'])."' and role='2'";

    mysql_error();

    $result2=mysql_query($sql2);

    $num=mysql_num_rows($result2);
 
    ?> 

<head>

<body>

<script language="javascript" type="text/javascript">

        function check()

        {

            if(document.getElementById('checkbox[]').value == "")

            {

                alert('Please select checkbox');

                return false;
 
            }

        }

        </script>
 
<form action="projectassign.php" method="post">

<table width="100%">

<tr><td> <img src="Logofinalcopy.gif">

</td></tr>

    <tr>

        <td bgcolor="aqua"><h2>Project assign</h2></td>

    </tr></table>

    <br>

    <table align="center">

    <tr>

        <td>projectassign</td>

        <td><select name="projectassign">

        <option value="<?php echo '$projectassign';?>" >----select project----</option><?php echo $options ?>

        </select>

        </td>

    </tr>

    </table>  

    <br><br><br>  

    <table border="1" cellspacing="0" cellpadding="0" align="center" style="width: 500px">

    <tr>

        <th></th>

        <th>userid</th>

        <th>username</th>
 
    </tr>

    <?php

    $sno=1;

    while($row=mysql_fetch_array($result2, MYSQL_ASSOC)){

    ?>

     <tr>

<td><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<? echo $row['userid']; ?>"></td>

<td><? echo $row['userid']; ?></td>

<td><? echo $row['username'];?></td>

</tr>

<?php

    $sno=$sno+1;

}

?>

    </table>
 
    <?php

if(isset($_POST['Submit']))
 
    {

        $checkbox=$_POST['checkbox'];

        for($i=0;$i<count($checkbox);$i++)

        {

        $del_id = mysql_real_escape_string($checkbox[$i]);        

        $sql = "INSERT INTO projectassign(projectassign,userid)values('".mysql_real_escape_string($_POST['projectassign'])."','$del_id')";

         echo $sql;

         mysql_error();

        $result = mysql_query($sql);
 
        }

    }    
 
    ?>

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

    </form>

    </body>

    </head>

Mar 31 '10 #1

Subscribe Post Reply

3055

Atli

5,058

Expert 4TB

Hey.

When you select the projects for you <option> boxes, you specify that the value of each should be a "projectid", but you fail to fetch such a row from your database. Thus, the value attribute of all the projectassign options is empty, which is the value put into the projectassign table where the project id should go.

If you turn the error messages on, PHP should give you a warning that the "projectid" index doesn't exist.

P.S.
Putting mysql_error() by itself without printing it is pointless. It returns an error, it does not print it. You need to do that yourself with an echo or print. It's also quite popular to put it in a "or die()" clause following the mysql_query() call.

Mar 31 '10 #2

niths

i didnt understand wat u said. can u please do that in my code..so that i can come to know. thank u.

Apr 1 '10 #3

Atli

5,058

Expert 4TB

On line #18 you try to use a "projectid" from the query on line #12. But that column isn't in your query. - If you want to use a column from your table in your code, it needs to be included in the query.

Consider this:

Expand|Select|Wrap|Line Numbers

 <?php

$sql = "SELECT `one`, `two`

        FROM `my_table`";

$result = mysql_query($sql);

$row = mysql_fetch_assoc($result);
 
// These will print the values, as expected.

echo $row['one'];

echo $row['two'];
 
// But this will print nothing, because

// this field was not retrieved in the query.

echo $row['three'];

?>

Apr 1 '10 #4

by: Mamun | last post by:

Hi All, I have the following case. I am trying to update a table based on the value of dropdown box and checkbox. Here is what I have in page1.asp <table>

ASP / Active Server Pages

How to synchronize current record in the form with value selected in a combobox ?

by: Zlatko Matiæ | last post by:

There is a form (single form) and a combobox. I want that current record of the form is adjusted according to selected value in the combobox. Cuurrent record should be the same as the value in the...

Microsoft Access / VBA

bind a dropdown in a column in a datagrid based on the dropdown value selected in another column of the datagrid.

by: vishnu | last post by:

Hi, I have a fully editable datagrid which has dropdownlist in two columns. Now i have to bind the dropdown in the second column based on the value selected in the dropdown in the firstcolumn. so...

ASP.NET

web form: populating one listview dependent on value selected in another

by: planetthoughtful | last post by:

Hi All, I have a c# web form that has two listviews on it. Both currently retrieve their list entries from two separate tables in an SQLServer backend. I've been asked to make the values in the...

C# / C Sharp

if checkbox true insert value problem ?

by: Fary4u | last post by:

Hi is any body know where is actual problem is coz it's look me some problem ? to insert value into the MS ACCESS DATABASE after the value is true form html <input type="checkbox"...

ASP / Active Server Pages

Problem in maintaining the selected value of dropdown list

by: itgaurav198 | last post by:

Hi, i have one jsp in which i select a value from drop down and on change of this a servlet is called that accesses some values and return to the same jsp where these values get populated in...

Java

passing the selected value of dropdown box to the next html page

by: sindhu | last post by:

Hello acoder. I want to know another type of passing values between pages I have three frames frame1 for main horizontal menu frame 2 for vertical submenu frame 3 which is is loaded based on...

Javascript

Js function to change respecive cell value onchange selected value of dropdown value

by: tarunkhatri | last post by:

Hi. I have a javascript function to change the value of the cell on chnage event of a dropdown list.My code is workin but the problem is that the value of the cell is chaning but not respective to...

Javascript

How to load a grid in asp.net based on the dropdown value selected using ajax

by: visweswaran2830 | last post by:

Hi, I have four cascading dropdown control and now I want to load a gird data based on the value selected on that dropdown. This should be done by using ajax concepts..

ASP.NET

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

how to insert value selected in the dropdown to backend?

Similar topics