I'm getting confused

poperann · January 31, 2012

Hello.

I started to edit database of someone else and I came a cross this....

thing which I'm guessing that it suppose to edit multiple entry in one click of button(or something)

I cannot figure what he was thinking, but I was told to make it work...

(Problem) I'm not a website person who can do php.... I can read and understand some what.

Please help me to see what I can do.

______________________________________

<?php

//Set session and password requirement

session_start(); //start session

if (!isset($_SESSION['agent']) OR ($_SESSION['agent'] != md5($_SERVER['HTTP_USER_AGENT']) )){

require_once ('../includes/login_functions.inc.php');

//$url = absolute_url();

header("Location: /info/login.php");

exit();

}

$page_title = 'Browse Contacts';

//include ('../includes/header.html');

?>

<head>

<title>Browse Contacts</title>

<!--

body {

background-color: #AEEBFF;

}

#navigation table tr td a strong {

color: #36F;

}

#navigation table {

color: #36F;

}

#navigation4 form h2 {

color: #0303FC;

}

font {

color: #0303FC;

}

.font1 {

color: #F00;

font-size:24px

}

.font2 {

font-size: 24px;

font-family: "Book Antiqua";

font-weight: bold;

}

.font {

text-align: center;

}

-->

</style>

</head>

<body>

<?php

// This page displays and handles a form for inserting records into the expense_categories table.

// Create an HTML table:

echo '<table border="2" width="90%" cellspacing="2" cellpadding="2" align="center">

<td align="center" valign="top"><b>Submit</b></td>

<td align="center" valign="top"><b>First Name</b></td>

</tr>

';

// Include the MySQL information:

require_once ('../../mysqldb.php');

//handle the form

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

ini_set('display_errors', 1);

error_reporting (E_ALL | E_STRICT);

//track success

//$problem = FALSE;

$errors = array();

$gc1 = mysqli_real_escape_string($dbc, trim($_POST['gc1']));

$gc2 = mysqli_real_escape_string($dbc, trim($_POST['gc2']));

$gc3 = mysqli_real_escape_string($dbc, trim($_POST['gc3']));

$l1c1 = mysqli_real_escape_string($dbc, trim($_POST['l1-c1']));

$l1c2 = mysqli_real_escape_string($dbc, trim($_POST['l1-c2']));

$l1c2 = mysqli_real_escape_string($dbc, trim($_POST['l1-c3']));

$l1c2 = mysqli_real_escape_string($dbc, trim($_POST['l1-c5']));

$l2c1 = mysqli_real_escape_string($dbc, trim($_POST['l2-c1']));

$l2c2 = mysqli_real_escape_string($dbc, trim($_POST['l2-c2']));

$l2c3 = mysqli_real_escape_string($dbc, trim($_POST['l2-c3']));

$l2c5 = mysqli_real_escape_string($dbc, trim($_POST['l2-c5']));

if (empty($errors)) {

//make the update query

$q = "UPDATE contacts SET gc1='$gc1', gc2='$gc2', gc3='$gc3', l1-c1='$l1c1', l1-c2='$l1c2', l1-c3='$l1c3', l1-c5='$l1c5', l2-c1='$l2c1', l2-c2='$l2c2', l2-c3='$l2c3', l2-c5='$l2c5', WHERE contacts_id = $contacts_id LIMIT 1";

//echo $q;

//run the query

$r = @mysqli_query ($dbc,$q);

//if it ran ok

if ($r) {

echo '<h2>Thank you.</h2>

<p>Your contact information is added.</p><p><br /></p>';

} else { //if it did not run ok

//public message

echo '<h2>System Error.</h2>

<p class="error">Your contact information could not be posted. Please try again later.</p>';

//debugging message

echo '<p>' . mysqli_error($dbc) . '<br /><br />Query: ' . $q . '</p>';

}

//run the query

$rs = @mysqli_query($dbc,$qs);

//if it ran ok

if ($rs) {

echo '<h2>Thank you.</h2>

<p>Your information is added.</p><p><br /></p>';

echo '<p> <a href="http://Website.org">website.org </a></p>';

} else { //if it did not run ok

//debugging message

echo '<p>' . mysqli_error($dbc) . '<br /><br />Query: ' . $q . '</p>';

} //end of if ($r)

//close the db connection

mysqli_close($dbc);

exit();

} else { //report the errors

echo '<h2>Error</h2>

<p class="error">The following errors occured:<br />';

//print the errors

foreach ($errors as $msg) {

echo " - $msg<br />\n";

}

echo '</p><p><font color="green">Please try again.</font></p><br />

<font color="red">Press the browsers back button above to retain form data</font></p>';

} // endo of if (empty($errors)) IF

//close the db connection

mysqli_close($dbc);

echo '<p> <a href="contact.html">Contact Main</a></p>';

echo '<p> <a href="http://website.com">website</a></p>';

}//end main submit conditional

//create the query to populate the browse table

$query2 = 'SELECT * FROM contacts ORDER BY contacts_id';

if ($r = mysqli_query($dbc, $query2)) { //run the query

//retrieve and print

while ($row = mysqli_fetch_array($r, MYSQLI_ASSOC)) {

echo '

</tr> </form>';

}

} else { //if the query didn't run

print '<p style="color: red;">Could not retrieve the data because:<br />' . mysqli_error() . ' .</p><p>The query being run was: ' . $q. '</p>';

}

//count the number of records

$num = @mysqli_num_rows($r);

echo "There are $num records.\n";

mysqli_close($dbc);

?>

</table>

<p></p>

</body>

</html>

metabee · February 6, 2012

Perhaps Ben can help you to solve the problems.

poperann · February 6, 2012

How is Ben....??

falkencreative · February 6, 2012

I'm assuming @Metabee was talking about me.

What exactly is the issue with the code above? You said that you have to "make it work" -- is it broken somehow? Are you getting errors?

Sign In

I'm getting confused

Recommended Posts

poperann

Link to comment

Share on other sites

metabee

Link to comment

Share on other sites

poperann

Link to comment

Share on other sites

falkencreative

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Store

Support