PHP - Modify Mysql Tables Using Form Back-end Of Cms

Cannot modify header information - headers already sent by (output started at )  on line 179
 I labeled 179 its at the bottom.
I understand this means its already generating the html but not how or where.  A solution would of course be nice but if some one could tell me even how to figure it out it would be great.

Code: [Select]
<?php

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



// EDIT THE 2 LINES BELOW AS REQUIRED
    $email_to = "test@test.com";
    $email_subject = "$mile";
    
     
    function died($error) {
        // your error code can go here
        echo "We are very sorry, but there were error(s) found with the form you submitted. ";
        echo "These errors appear below.<br /><br />";
        echo $error."<br /><br />";
        echo "Please go back and fix these errors.<br /><br />";
        die();
    }
    
     /*"trail_section_mile", float dash
    "trail_section_name", #9()alphanumeric
    "name",
    "date"auto date
    "email",same
    "telephone" same
    "trail_condition" no validation just sanitize size limit
    "attention_area"   no validation just sanitize size limit
    "under_20"          no validation just sanitize size limit
    "_20_54"          no validation just sanitize size limit
    "_55_over"          no validation just sanitize size limit
    */
 if(!isset($_POST['trail_section_mile']) ) {
        died('1');      
    } 
    if(!isset($_POST['trail_section_name']) ) {
        died('2');      
    }
    if(!isset($_POST['name']) ) {
        died('3');      
    } 
    if(!isset($_POST['email']) ) {
        died('4');      
    }
    if(!isset($_POST['telephone']) ) {
        died('5');      
    } 
    if(!isset($_POST['trail_condition']) ) {
        died('6');   
    }
       if(!isset($_POST['attention_area']) ) {
        died('7');   
    }
    if(!isset($_POST['under_20']) ) {
        died('8');      
    } 
    if(!isset($_POST['_20_54']) ) {
        died('9');      
    }
    if(!isset($_POST['_55_over']) ) {
        died('0');      
    } 
   
      if(!isset($_POST['total_hours']) ) {
        died('011');      
    }
    
    //comments field is a honeypot
    
      require ('Validate.php');
$email = $_REQUEST['email'];
$validate = new Validate();
if (!Validate::email($email, array('check_domain' => true, 'use_rfc822' =>true))) {
  echo "Invalid email";
}
      
    
    $trail_section_mile = $_POST['trail_section_mile']; // required
    $trail_section_name = $_POST['trail_section_name']; // required
   $name = $_POST['name']; // required
   $email = $_POST['email']; // required
   $telephone = $_POST['telephone']; // required
   $trail_condition = $_POST['trail_condition']; // required
    $attention_area = $_POST['attention_area']; // required
   $under_20 = $_POST['under_20'];
   $_20_54 = $_POST['_20_54'];
   $_55_over = $_POST['_55_over'];
   $_55_over = $_POST['total_hours'];
    // required
 
 if (preg_match('/[\d\D\b\B\s\S]/', $comments)) {
    echo "nope";
}
   
if (!preg_match("/([\w\.\#\-\,]{1,30})+/", $trail_section_mile)) 
{echo "please enter the section mile markers again only numbers, decimals dashes and # are aloud";
}

if (!preg_match("/[a-z'-]+/", $trail_section_name)) {
    echo "Try your last name again.";
}

if (!preg_match("/[a-z'-]+/", $name)) {   
    echo "please re-type your address.";
}

 if (!preg_match("/^\(?([0-9]{3})\)?[-. ]?([0-9]{3})[-. ]?([0-9]{4})$/i", $telephone))
 {
    echo "Something is wrong with the phone number you intered. Please enter your area code first then ther rest of tyour number.";
}

   
 if (( preg_match( "/[\r\n]/", $first_name ) || 
 preg_match( "/[\r\n]/", $email ) || 
 preg_match( "/[\r\n]/", $last_name) ) || 
 preg_match( "/[\r\n]/", $state)) {

   echo "nope";

}
  
    $trail_section_mile = strip_tags($trail_section_mile);
    $trail_section_name = strip_tags($trail_section_name);
   $name  =strip_tags($name);
   $email = strip_tags($email);
   $telephone = strip_tags($telephone);
   $trail_condition = strip_tags($trail_condition);
    $attention_area = strip_tags($attention_area);
    $under_20 = strip_tags($under_20);
   $_20_54 = strip_tags($_20_54);
   $_55_over = strip_tags($_55_over);
    $total_hours = strip_tags($total_hours);
   
   
   $trail_section_mile = htmlspecialchars($trail_section_mile);
    $trail_section_name = htmlspecialchars($trail_section_name);
   $name = htmlspecialchars($name);
   $email = htmlspecialchars($email);
   $telephone = htmlspecialchars($telephone);
   $trail_condition = htmlspecialchars($trail_condition);
    $attention_area = htmlspecialchars($attention_area);
    $under_20 = htmlspecialchars($under_20);
   $under_20 = htmlspecialchars($_20_54);
   $_55_over = htmlspecialchars($_55_over);
    $total_hours = htmlspecialchars($total_hours);
    
   
  
    $email_message = "Form details below.\n\n";
       $email_message = date("m/d/Y") . "\n";

    function clean_string($string) {
      $bad = array("content-type","bcc:","to:","cc:","href");
      return str_replace($bad,"",$string);
    }
     
    $email_message .= "Trail Section Mile Markers: ".clean_string($trail_section_mile)."\n";
    $email_message .= "Trail Section Name : ".clean_string($trail_section_name)."\n";
   $email_message .= "Reported by: ".clean_string($name)."\n";
   $email_message .= "Email Address: ".clean_string($email)."\n";
   $email_message .= "Telephone Number: ".clean_string($telephone)."\n";
   $email_message .= "General Trail Condition : ".clean_string($trail_condition)."\n";
    $email_message .= "Mile #/Problem/Suggested Improvements: ".clean_string($attention_area)."\n";
    $email_message .= "Volunteers Under Age 20 #Males/#Females/Ethnicity/Name: ".clean_string($under_20)."\n";
    $email_message .= "   
Volunteers Ages 20 to 54 #Males/#Females/Ethnicity/Name: ".clean_string($_20_54)."\n";
        $email_message .= "Volunteers Age 55+ #Males/#Females/Ethnicity/Name: ".clean_string($_55_over)."\n";
    $email_message .= "Total Volunteer Hours: ".clean_string($total_hours)."\n";

   
     $about ="Maintenance Report from" .$name. "/n";
     
// create email headers
$headers = 'Subject : '.$about."/r/n"
.'From: '.$email."\r\n"
.'Reply-To: '.$email."\r\n" .
'X-Mailer: PHP/' . phpversion();
header("Location: oht/maintenance/maintenance-report/thank-you/");                              //line 179
@mail($email_to, $email_subject, $email_message, $headers); 
?>

<?php
}
?>


MOD EDIT: [code] . . . [/code] BBCode tags added.

The Script:

<?php

include($_SERVER['DOCUMENT_ROOT'] . "/gallerysite/header.php");

?>
<?php

include($_SERVER['DOCUMENT_ROOT'] . "/gallerysite/connect.php");

?>
<?php

if(isset($_GET['thread_id'])) {

    $tqs = "SELECT * FROM `thread` WHERE `id` = '" . $_GET['thread_id'] . "'";
    $tqr = mysqli_query($dbc, $tqs) or die(mysqli_error($dbc));
    $row = mysqli_fetch_assoc($tqr);

    ?>

    <div class="div">
        <h1>Admin Modify</h1>
        <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
            <input type="text" name="title" value="<?php echo $row['title']; ?>"/><br/>
            <textarea type="text" name="caption"><?php echo $row['caption']; ?></textarea>
            <input type="submit" name="admin_update" value="Update" />
        </form>
    </div>

<?php

    // This prints e.g.:
    // 47
    echo "The Thread ID: ";
    echo $_GET['thread_id'];

    if(isset($_POST['admin_update'])){
        $tqs = "UPDATE `thread` SET `title` = '" . $_POST['title'] . "', `caption` = '" . $_POST['caption'] . "' WHERE `id` = '" . $_GET['thread_id'] . "'";
        $tqr = mysqli_query($dbc, $tqs) or die(mysqli_error($dbc));
    }

}



?>
<?php

include($_SERVER['DOCUMENT_ROOT'] . "/gallerysite/footer.php");

?>

I do not see why this is not working. The "UPDATE" SQL statement has worked without the "WHERE" part and modified all of the posts. (With this the database connection works too.)   Though, this statement does work in PhpMyAdmin:

UPDATE `thread` SET `title` = 'testing', `caption` = 'testing' WHERE `id` = '47';

I added the "WHERE" part to the script and now it is not modifying the text in the table anymore, basically the "updates" do not happen.   What could be the issue here?   Any suggestions are much appreciated.   Also, I have used this way of "syntax style" in PHP, perhaps somebody could be modifying the "UPDATE" SQL statement into a different syntax style so I can try it out, I would much appreciate it. I would also like to ask how the "syntax style" I have used is and if it can be better than this?
Edited by glassfish, 20 October 2014 - 05:52 AM.

Hi friends. I want to php code on how i can modify my retrieved database values from a particular table before echoing out. Please could you help me correct the code. Or if there is any better way of editing loop datas before printing out, please kindly drop the code for me. Thanks

<?php    

$q = "SELECT * FROM threads WHERE catid='2'";

  $get = $database->query($q) or die(mysql_error());

 $row=mysql_fetch_row($get);


$value=$row['0']['title'];

$one='first value'; 

echo $value.$one;


$value=$row['1']['name'];

$two='second value'; 

echo $value.$two;


$value=$row['2']['category'];

$three='third value'; 

echo $value.$three;

?>

please if there is any better way of editing loop values from mysql database before printing out, please kindly drop the code for me. Thanks

This portion is kind of stumping me. Basically, I have a two tables in this DB: users and users_access_level (Separated for DB normalization)

users: id / username / password / realname / access_level
users_access_level: access_level / access_name

What I'm trying to do, is echo the data onto an HTML table that displays users.username in one table data and then uses the users.access_level to find users_access_level.access_name and echo into the following table data, I would prefer not to use multiple queries if possible or nested queries.

Example row for users: 1234 / tmac / password / tmac / 99
Example row for users_access_level: 99 / Admin

Using the examples above, I would want the output to appear as such:

Username: Access Name: Tmac Admin
I am not 100% sure where to start with this, but I pick up quickly, I just need a nudge in the right direction.

The code I attempted to create just shows my lack of knowledge of joining tables, but I'll post it if you want to see that I did at least make an effort to code this myself.

Thanks for reading!

hi

i have generated a product list from a mysql table called product_list, once i enter a new product in to the table the product will be shown in the generated list and the list will grow and the table grows.  and i want to allow user the edit/delete/save the products from the generated table, i have no idea how to do it and what is the algorithmic idea to do it so. here is the php and the html code.

<!--Body container  for creating a new product in to the list-->
<div class="body_orderviewform">
  <form name="form1" method="post" action="upload_file.php" enctype="multipart/form-data">
    <p>
      <label for="user_id">User ID:</label>
      <input type="text" name="user_id" id="user_id">
      <label for="customer_name">Customer Name:</label>
      <input type="text" name="customer_name" id="customer_name">
      <label for="customer_family">Customer_family</label>
      <input type="text" name="customer_family" id="customer_family">
      <label for="freelancer_name">Purchaser:</label>
      <input name="freelancer_name" type="text" id="freelancer_name">
     
      <? if (isset($_COOKIE['picAdd'])) echo $_COOKIE['picAdd'];?>
     
    </p>
 <!------------------------------------------------------------------------------------------------------- for generating the list -->
   
<div  class="div.neworder_list" >   

   <div  class="div.neworder_listheader" align="center">
   
    <table width="637" border="1" >
      <tr>
        <td width="193"><label for="link">link:</label>
          <label for="link_new"></label>
          <input type="text" name="link_new" id="link_new"></td>
        <td width="202"><label for="unitprice">Unit Price:</label>
          <label for="Unit_price_new"></label>
          <input type="text" name="Unit_price_new" id="Unit_price_new"></td>
        <td width="220"><label for="qty">Quantity:</label>
          <label for="quantity_new"></label>
          <input type="text" name="quantity_new" id="quantity_new"></td>
      </tr>
      <tr>
        <td><label for="express">Express Fee:</label>
          <label for="express_new"></label>
          <input type="text" name="express_new" id="express_new"></td>
        <td><label for="commission_new">Commission:</label>
          <input type="text" name="commission_new" id="commission_new"></td>
        <td><label for="customer_description">Description</label>
          <label for="description_new"></label>
          <textarea name="description_new" id="description_new" cols="45" rows="5"></textarea></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">Picture Upload:
              <input type="hidden" name="<?php echo ini_get("session.upload_progress.name");?>" value="123" />
              <input name="file" type="file" autofocus="autofocus"/>
              <br />


      </tr>
      <tr>
        <td colspan="3"><input type="reset" name="reset" id="reset" value="Reset">
        <input type="submit" name="submit" id="submit" value="Submit The Product"></td>
      </tr>
    </table>

 
</form>   
</div>
   
<div class="neworder_listview">
  <p>
  <form action="" method="post" name="list">
    <input type="submit" name="del" id="del" value="Save">
    <input type="submit" name="save" id="save" value="Del">
  </p>
  <table width="1022" border="1" align="center">
    <tr>
      <th width="24" scope="col">&nbsp;</th>
    <th width="24" scope="col">Row#</th>
    <th width="137" scope="col">Manager</th>
    <th width="137" scope="col">Purchaser Desc</th>
    <th width="40" scope="col"><p>Link</p>
      <p>/Ссылки</p></th>
    <th width="53" scope="col">ФОТО</th>
    <th width="50" scope="col">Unit Price/Цена за еденицу товара</th>
    <th width="46" scope="col">Quantity/ Кол-во</th>
    <th width="138" scope="col">Total Unit Price/ Общая цена</th>
    <th width="89" scope="col">Express/Доставка по Китаю</th>
    <th width="119" scope="col">Description/Описание</th>
    <th width="89" scope="col">ADDITIONAL LINKS/ЗAMЕНЫ</th>
    </tr>
   


<?php

   $username = "my username";
   $password = "my pass";
   $database = "userinfo";
   $link = mysql_connect("localhost", "$username", "$password");
   
   if(!$link) {echo("Failed to establish connection to mysql server");
               exit();}

   $status = mysql_select_db($database);
   $query = "SELECT * FROM order_list";
   $result = mysql_query($query);
   $num = mysql_num_rows($result);
   $i=0;
 
 
 
  while ($i < $num) {
   $field1_name=mysql_result($result,$i,"admin_st");
   $field2_name=mysql_result($result,$i,"freelancer_st");
   $field3_name=mysql_result($result,$i,"link");
   $field4_name=mysql_result($result,$i,"picture");
   $field5_name=mysql_result($result,$i,"unitprice");
   $field6_name=mysql_result($result,$i,"qty");
   $field7_name=mysql_result($result,$i,"express");
   $field8_name=mysql_result($result,$i,"customer_st");
   $i++;
    }
 
?>







<?php
$i=0;
$row=1;
while ($i < $num) {

$f1=mysql_result($result,$i,"admin_st");
$f2=mysql_result($result,$i,"freelancer_st");
$f3=mysql_result($result,$i,"link");
$f4=mysql_result($result,$i,"pic_address");
$f5=mysql_result($result,$i,"unitprice");
$f6=mysql_result($result,$i,"qty");
$f7=mysql_result($result,$i,"express");
$f8=mysql_result($result,$i,"customer_st");
$totao_unit_price = $f5*$f6;
?>
  <tr>
    <td><input type="checkbox" name="del_chbox" id="del_chbox">
   <td><p><font face="Arial"><input name="row_txtbox" type="text" id="row_txtbox" size="2" value="<?php echo $row; ?>"></font></td>
   <td><p><font face="Arial"> <textarea name="manager_txtbox" cols="10" id="manager_txtbox"><?php echo $f1; ?></textarea></font></td>
   <td><p><font face="Arial">        <textarea name="purchase_txtbox" cols="10" id="purchase_txtbox"><?php echo $f2; ?></textarea>
</font></td>


   <td><font face="Arial"><a href="<?php $f3 ?>" target="_blank"><?php echo $f3; ?></a></font></td>
   <td><font face="Arial"><img src="<?php echo $f4;?>" width="100" align="middle"100></font></td>
   <td><font face="Arial"><input name="unitprice_txtbox" type="text" id="unitprice_txtbox" size="2" value="<?php echo $f5; ?>"></font></td>
   <td><font face="Arial"> <input name="qty_txtbox" type="text" id="qty_txtbox" size="2" value="<?php echo $f6; ?>"></font></td>
   <td><p><font face="Arial"><?php echo $totao_unit_price; ?></font></td>
   <td><p><font face="Arial"><input name="express2" type="text" id="express3" size="2" value="<?php echo $f7; ?>"></font></td>
   <td><p><font face="Arial"> <textarea name="custdesc_txtbox" cols="20" id="custdesc_txtbox"><?php echo $f8; ?></textarea></font></td>
    <td><input name="express2" type="text" id="express3" size="2" value="<?php echo "new link" ?>"></td>
   </tr>

  <p>
    <?php
$i++;
$row++;
}
?>
</table>
   
  </p>
  <p>&nbsp;</p>
  </form>