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

metabee

poperann

falkencreative

Join the conversation

Browse

Activity

Store

Support