help me plz

tum_bin

i have the following form:

<form action="participant_handler1.php" method="POST">
<table>
<tr>
<td align="right">User Name: </td>
<td>
<input type="text" name="puname" id="ppuname" size="25" maxlength="50" />
</td>
</tr>
<tr>
<td align="right">Password: </td>
<td>
<input type="text" name="ppass" id="ppass" size="25" maxlength="50" />
</td>
</tr>

            <tr>
                <td>
                    <input type="submit" value="Submit"/>
                </td>
                <td>
                    <input type="reset" value="Clear"/>
                </td>
            </tr>
        </table>

    </form>

and have sql database:

CREATE TABLE module4.password (
eid INT( 10 ) NOT NULL ,
username VARCHAR( 40 ) NOT NULL ,
password VARCHAR( 40 ) NOT NULL
) ENGINE = MYISAM ;

INSERT INTO module4.password (
eid ,
username ,
password
)
VALUES (
'1', 'Aparna', 'passmenow'
), (
'2', 'Arif', 'passme'
), (
'3', 'Hridoy', 'heart'
), (
'4', 'Mithun', 'mypass001'
), (
'5', 'Shimu', 'shimukhan'
);

if i will input username and password froom database it will say log otherwise it will say invalied data or loging

dalecosp

Perhaps you'd like to show someone here at PHPBuilder (note that name, P-H-P-Builder) some PHP code? Maybe the PHP source code to the PHP file called "participant_handler1.PHP" ...

Please? Hello? Please?

tum_bin

how can i delete from sql database table ???? what i have to add in funtion quary?

function editable_fetch($username, $password, $db_name, $title_text, $table_header, $query) {
$db = mysql_connect('localhost', $username, $password) or die('‘Unable to connect. Check your connection parameters.');
mysql_select_db($db_name, $db) or die(mysql_error($db));
$result = mysql_query($query, $db) or die(mysql_error($db));
$total_no_rows = mysql_num_rows($result);
mysql_close($db);
$output = <<<HEREDOC_1
<div id="table_container">
HEREDOC_1;

$output.='<h2 align="center">' . $title_text . '</h2>';

$output .=<<<HEREDOC_2
    <table>
        <tr class="header">

HEREDOC_2;

for ($i = 0; $i < count($table_header); ++$i) {
    $output.='<th>' . $table_header[$i] . '</th>';
}

$output.='</tr>';

$current_row = 0;
while ($row = mysql_fetch_assoc($result)) {
    extract($row);
    if ($current_row &#37; 2 == 0)
        $output .='<tr class="even">';
    else
        $output .='<tr class="odd">';

    foreach ($row as $value) {
        $output.='<td align="center">' . $value . '</td>';
    }
    $output.=<<<HEREDOC
            <td><a href="part_edit_handler.php?pid=$pid">[EDIT]</a></td>

HEREDOC;

    $output.=<<<HEREDOC_D
            <td><a href="part_delete_handler.php?pid=$pid">[DEL]</a></td>
            </tr>

HEREDOC_D;
++$current_row;
}
$output.=<<<HEREDOC_4
</table>
<br/>
<b>Total Rows Fetched=$total_no_rows</b>
</div>
HEREDOC_4;

return $output;

}

function input_participant($username, $password, $db_name, $input_val) {
$db = mysql_connect('localhost', $username, $password) or die('‘Unable to connect. Check your connection parameters.');
mysql_select_db($db_name, $db) or die(mysql_error($db));
$input_string = 'insert into participant (name,date_of_birth,sex,cell_no,email) ' .
'values(\'' . $input_val['name'] . '\',\'' . $input_val['date_of_birth'] . '\',\'' . $input_val['sex'] . '\',\'' . $input_val['cell_no'] .
'\',\'' . $input_val['email'] . '\')';
// echo 'DEBUG: '.$input_string.'<br/>';

/*     * **************************task_4(b)************************************************* */

$status = mysql_query($input_string, $db);
if ($status != 1)
    echo 'Could not be inserted!';

mysql_close($db);

}

function edit_part_form($username, $password, $db_name, $pid_arg) {
$db = mysql_connect('localhost', $username, $password) or die('‘Unable to connect. Check your connection parameters.');
mysql_select_db($db_name, $db) or die(mysql_error($db));
$query = 'select * from participant where pid=' . $pid_arg;
$result = mysql_query($query, $db) or die(mysql_error($db));

mysql_close($db);

$row = mysql_fetch_assoc($result);
extract($row);

$year=substr($date_of_birth,0,4);
$month=substr($date_of_birth,5,2);
$day=substr($date_of_birth,8,2);

$male=$female='';
if($sex=='male')
    $male='checked';
else if($sex=='female')
    $female='checked';

$output = <<<HEREDOC
    <h2>Edit Participant Information</h2>
    <form action="part_edit_form_handler.php" method="POST">
        <table>
            <tr>
                <td align="right">Participant ID (PID): </td>
                <td>
                    <input type="text" name="pid" id="pid" size="40" maxlength="50" value=$pid readonly="readonly" />
                </td>
            </tr>
            <tr>
                <td align="right">Name: </td>
                <td>
                    <input type="text" name="pname" id="pname" size="40" maxlength="50" value=$name />
                </td>
            </tr>
            <tr>
                <td align="right">Date of Birth(YYYY-MM-DD): </td>
                <td>
                    <input type="text" name="year" id="year" size="4" value=$year />
                    <input type="text" name="month" id="month" size="2" value=$month />
                    <input type="text" name="day" id="day" size="2" value=$day />
                </td>
            </tr>
            <tr>
                <td align="right">Gender:</td>
                <td>
                    <input type="radio" name="sex" id="sex" value="male" $male />Male
                    <br/>
                    <input type="radio" name="sex" id="sex" value="female" $female />Female
                </td>
            </tr>
            <tr>
                <td align="right">Cellphone: </td>
                <td>
                    <input type="text" name="cell_no" id="cell_no" size="20" maxlength="20" value=$cell_no />
                </td>
            </tr>
            <tr>
                <td align="right">Email: </td>
                <td>
                    <input type="text" name="email" id="email" size="30" maxlength="30" value=$email />
                </td>
            </tr>

            <tr>
                <td>
                    <input type="submit" value="Save Changes"/>
                </td>

            </tr>
        </table>

HEREDOC;
return $output;
}

function edit_participant($username, $password, $db_name, $input_val) {
$db = mysql_connect('localhost', $username, $password) or die('‘Unable to connect. Check your connection parameters.');
mysql_select_db($db_name, $db) or die(mysql_error($db));
$input_string = 'update participant set name=\''.$input_val['name'].'\',date_of_birth=\''.
$input_val['date_of_birth'].'\',sex=\''.$input_val['sex'].'\',cell_no=\''.
$input_val['cell_no'].'\',email=\''.$input_val['email'].'\' where pid='.$input_val['pid'];
echo 'DEBUG: '.$input_string.'<br/>';

/*     * **************************task_4(b)************************************************* */

$status = mysql_query($input_string, $db);
if ($status != 1)
    echo 'Could not be inserted!';

mysql_close($db);

}

function delete_part_form($username, $password, $db_name, $pid_arg) {
$db = mysql_connect('localhost', $username, $password) or die('‘Unable to connect. Check your connection parameters.');
mysql_select_db($db_name, $db) or die(mysql_error($db));
$query = 'select * from participant where pid=' . $pid_arg;
$result = mysql_query($query, $db) or die(mysql_error($db));
mysql_close($db);
$row = mysql_fetch_assoc($result);
extract($row);

$year=substr($date_of_birth,0,4);
$month=substr($date_of_birth,5,2);
$day=substr($date_of_birth,8,2);

$male=$female='';
if($sex=='male')
    $male='checked';
else if($sex=='female')
    $female='checked';

$output = <<<HEREDOC
    <h2>Edit Participant Information</h2>
    <form action="part_delete_form_handler.php" method="POST">
        <table>
            <tr>
                <td align="right">Participant ID (PID): </td>
                <td>
                    <input type="text" name="pid" id="pid" size="40" maxlength="50" value=$pid readonly="readonly" />
                </td>
            </tr>
            <tr>
                <td align="right">Name: </td>
                <td>
                    <input type="text" name="pname" id="pname" size="40" maxlength="50" value=$name />
                </td>
            </tr>
            <tr>
                <td align="right">Date of Birth(YYYY-MM-DD): </td>
                <td>
                    <input type="text" name="year" id="year" size="4" value=$year />
                    <input type="text" name="month" id="month" size="2" value=$month />
                    <input type="text" name="day" id="day" size="2" value=$day />
                </td>
            </tr>
            <tr>
                <td align="right">Gender:</td>
                <td>
                    <input type="radio" name="sex" id="sex" value="male" $male />Male
                    <br/>
                    <input type="radio" name="sex" id="sex" value="female" $female />Female
                </td>
            </tr>
            <tr>
                <td align="right">Cellphone: </td>
                <td>
                    <input type="text" name="cell_no" id="cell_no" size="20" maxlength="20" value=$cell_no />
                </td>
            </tr>
            <tr>
                <td align="right">Email: </td>
                <td>
                    <input type="text" name="email" id="email" size="30" maxlength="30" value=$email />
                </td>
            </tr>

            <tr>
                <td>
                    <input type="submit" value="Confirm Delete"/>
                </td>

            </tr>
        </table>

HEREDOC;
return $output;
}

function delete_participant($username, $password, $db_name, $input_val) {
$db = mysql_connect('localhost', $username, $password) or die('‘Unable to connect. Check your connection parameters.');
mysql_select_db($db_name, $db) or die(mysql_error($db));
#$query = 'delete form test.participant where participant.pid ='.$input_val['pid'];
$input_string = 'delete from participant where pid='.$input_val[pid];
echo 'DEBUG: '.$input_string.'<br/>';

/*     * **************************task_4(b)************************************************* */

#$status = mysql_query($input_string, $db);
#if ($status != 1)
#echo 'Could not be inserted!';

mysql_close($db);

}
?>