PHP - Never Changed A Thing,, Now This.

I have no idea if this is possible or not, but I've got a form that searches a DB for a record.

If that record is found, it displays a form that people can edit the record.

Now, if that person wants to change (for example) 1 record out of 16 called "status" from "lost" to "found" but leave all the rest as they are, how would I go about this?

Basically, I need to check all the fields ON SUBMIT if they're different from the original values in the DB and only update if they are.

Any help would be appreciated.

Cheers,

Dave

After switching from PHP 5.3 on Windows Server 2003 to PHP 7.4.3 on Linux Mint 19.3 (Tricia Cinnamon), I find that the output of print_r() has changed.

If we look at the documentation (https://www.php.net/manual/en/function.print-r.php), the provided example output is as it was on my earlier machine:

<pre>
Array
(
    [a] => apple
    [b] => banana
    [c] => Array
        (
            [0] => x
            [1] => y
            [2] => z
        )
)
</pre>

However, on the second machine, the output is:

<pre>
Array
(
    [a] => apple
    [b] => banana
    [c] => Array
        (
            [0] => x
            [1] => y
            [2] => z
        )
<blank line>
)
</pre>

Note the unexpected new line after each recursed array's closing parenthesis. The new line is not present after the outermost array closing parenthesis.

Also to note, there is a newer version of XDebug installed.

My question is: Is this a bug? (Follow-on question: if possible to determine at which version the output changed, what version would that be?)

This difference is causing existing code to not be able to correctly parse that output.

I'm trying to get some code to work that will update a field to show a checkbox either checked or not checked.   The field either uses a Y or N.  Y is checked, N not checked.  A code that I have tried displays the correct result for the box either checked or not checked. 

input type="checkbox" name="obcDisplay" value="Y" <?=($r['obcDisplay'] == 'Y') ? 'checked="checked"' : ''; ?>/>

But I want the ability to change when the form is submitted.  so if I bring up a page and the checkbox is checked (Y) and I submint, I want the database to update to N and the other way around.

I have 3 set of pages. The first html page only contains a search textbox and a submit button which then call up the second page search.php which populate html table with search result. The third page is update.php which allows to update the records populated by search.php.

The problem is that it when it update the records it automatically updates all rows in the table making all records look the same. I do not know where I have made a mistake please help. When I use phpadmin to update the records no problem as I can specifically input the cf_id number directly.


Search.php code
Code: [Select]
  <?php


  if(isset($_POST['submit'])){ 
  if(isset($_GET['go'])){ 
  if(preg_match("^/[A-Za-z]+/", $_POST['name'])){ 
   $name=$_POST['name']; 
  } 
  } 
  else{ 
  echo  "<p>Please enter a search query</p>"; 
  } 
}
//connect  to the database 


$con = mysql_connect("localhost","dbusrn","dbpwd");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("mydb", $con);
$name = $_POST['name'];
$result = mysql_query ("select * from Customer_Registration where Firstname like '%$name%' or lastname like '%$name%' ");



$row = mysql_fetch_row($result);
$cf_uid = $row[0];
$Firstname = $row[6];
$lastname = $row[7];
$Address = $row[8];
$Postcode = $row[9];
$Phone = $row[10];
$Email = $row[11];
$Customer_Type = $row[12];
$Computer_type = $row[13];
$Computer_maker = $row[14];
$Model = $row[15];
$OS = $row[16];
$Appointment_date = $row[17];
$Problem = $row[18];
$Solution = $row[19];
$Comment = $row[20];
?>
       

 <form action="updatecus.php" method="post">

<table width="100%" border="2" cellspacing="0" cellpadding="8">

<tr><td width="45%" class="FormText">Customer ID:</td>
<td width="55%"><?php echo $row[0];?></td></tr>
<tr><td width="45%" class="FormText">First name:</td>
<td width="55%"><input  name="Firstname" type="text" value="<?php echo $Firstname;?>"?> </td></tr>


<tr><td width="45%" class="FormText">Last name:</td>
<td width="55%"><input  name="lastname" type="text" value="<?php echo $lastname;?>"?> </td></tr>



<tr><td width="45%" class="FormText">Address:</td>
<td width="55%"><input  name="Address" type="text" value="<?php echo $Address; ?>"?> </td></tr>

 <tr><td width="45%" class="FormText">Postcode:</td>
<td width="55%"><input  name="Postcode" type="text" value="<?php echo $Postcode; ?>"?> </td></tr>


 <tr><td width="45%" class="FormText">Phone:</td>
<td width="55%"><input  name="Phone" type="text" value="<?php echo $Phone; ?>"?> </td></tr>

 <tr><td width="45%" class="FormText">Email:</td>
<td width="55%"><input  name="Email" type="text" value="<?php echo $Email; ?>"?> </td></tr>

 <tr><td width="45%" class="FormText">Customer:</td>
<td width="55%"><input  name="Customer_Type" type="text" value="<?php echo $Customer_Type; ?>"?> </td></tr>

 <tr><td width="45%" class="FormText">Computer :</td>
<td width="55%"><input  name="Computer_type" type="text" value="<?php echo $Computer_type; ?>"?> </td></tr>

 <tr><td width="45%" class="FormText">Manufactural:</td>
<td width="55%"><input  name="Computer_maker" type="text" value="<?php echo $Computer_maker; ?>"?> </td></tr>

 <tr><td width="45%" class="FormText">Model:</td>
<td width="55%"><input  name="Model" type="text" value="<?php echo $Model; ?>"?> </td></tr>

 <tr><td width="45%" class="FormText">Operating System:</td>
<td width="55%"><input  name="OS" type="text" value="<?php echo $OS; ?>"?> </td></tr>

 <tr><td width="45%" class="FormText">Appointment:</td>
<td width="55%"><input  name="Appointment_date" type="text" value="<?php echo $Appointment_date; ?>"?> </td></tr>

  <tr><td width="45%" class="FormText">Problem:</td>
<td width="55%"><textarea name="Problem" rows="10" cols="20" ><?php echo $Problem; ?></textarea></td></tr>

 <tr><td width="45%" class="FormText">Solution:</td>
<td width="55%"><textarea name="Solution" rows="10" cols="20" ><?php echo $Solution; ?></textarea></td></tr>

 <tr><td width="45%" class="FormText">Comment:</td>
<td width="55%"><textarea name="Comment" rows="10" cols="20" ><?php echo $Comment; ?></textarea></td></tr>

 
 
<td width="55%"><input name="submit"  value="submit"  type="submit" <br> <input type="Submit" value="Cancel"</br></td>


        </form>
        <?php

 
 
?>

update.php code

Code: [Select]
<?php
//connect  to the database 


$con = mysql_connect("localhost","dbusrn","dbpwd");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("mydb", $con);




//if (isset($_POST['submit']))  {
$cf_id  = $_POST['cf_id'];
$Firstname = $_POST['Firstname'];
$lastname = $_POST['lastname'];
$Address = $_POST['Address'];
$Postcode = $_POST['Postcode'];
$Phone = $_POST['Phone'];
$Email = $_POST['Email'];
$Customer_Type = $_POST['Customer_Type'];
$Computer_type = $_POST['Computer_type'];
$Computer_maker = $_POST['Computer_maker'];
$Model = $_POST['Model'];
$OS = $_POST['OS'];
$Appointment_date = $_POST['Appointment_date'];
$Problem = $_POST['Problem'];
$Solution = $_POST['Solution'];
$Comment = $_POST['Comment'];



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

$query ="UPDATE Customer_Registration SET  Firstname='$Firstname',lastname='$lastname',Address='$Address',Postcode='$Postcode',Phone='$Phone',Email='$Email',Customer_Type='$Customer_Type',Computer_type='$Computer_type',Computer_maker='$Computer_maker',Model='$Model',OS='$OS',
Appointment_date='$Appointment_date',Problem='$Problem',Solution='$Solution',Comment='$Comment' WHERE cf_id=cf_id"or die (mysql_error());

echo $query;

mysql_query($query) or die(mysql_error());
//mysql_close($con);
 
echo "<p>Congrats Record Updated</p>";
}

?>
Thank you in advance for your help

I have just upgraded PHP on my ISP server and none of the php scripts work.
I was using 5.2. And I am now on 5.4.
Why would the scripts stop working?
Are there and patches or changes I need to make to make them work?
I need an answer urgently!

Hey all,

I would like to know the best way to determine whether a value has been changed in a multi select transfer. For example, I have two select fields. User clicks on button to add an item to the right select element with id of select2 from the left select element with an id of select1. When they click update, it posts to a php method. This is where I am uncertain what to do. How can I check that they indeed added or removed items from the right select element and if they did, determine which ones were removed or added to make the reflected changes in the database?

This is what I have, but it's bad solution because it deletes all related records before it adds the ones it finds to the right select element:

Code: [Select]
public function update(){

$subcategory = new Category();
$subcategory->where('id',$this->uri->segment(4))->get();

$subcategory->delete($subcategory->related_category->get()->all);

$new_parents = $this->input->post('catupload');
$parent_category = new Category();
$parent_category->where_in('controller',$new_parents)->get();

$subcategory->save($parent_category->all);
}


This is what the form elements look like:

Code: [Select]
echo "You can add or remove one or many parents associated with this category:";
echo "<div class='multiselect-transfer'>";
echo form_multiselect('catadd[]',$other_cats,'','id="select1"');
echo anchor('#','add &gt;&gt;','id="add"');
echo "</div>";
echo "<div class='multiselect-transfer'>";
echo form_multiselect('catupload[]',$default_cats,'','id="select2"');
echo anchor('#','&lt;&lt; remove','id="remove"');
echo "</div>";
echo form_submit('submit','Update');
echo form_close();
$other_cats variable holds array of categories that have not been asssociated with the current category being updated when this category was first created. The $default_cats variable holds an array of categories that have been associated with the current category being updated when this category was first created.

And the javascript:

Code: [Select]

 $().ready(function() { 
   $('#add').click(function() { 
    return !$('#select1 option:selected').remove().appendTo('#select2'); 
   }); 
   $('#remove').click(function() { 
    return !$('#select2 option:selected').remove().appendTo('#select1'); 
   }); 
  });

Thanks for response.

Hello,
I'm using curl to grab a new solar image once an hour or so from the Solar Dynamics Observatory (example below). I'm trying to archive new images and am struggling with that.

If I download an image, the filetime() function returns the current time since I downloaded it and wrote it to a fresh file. The result is that the file is always "new", even if the image hasn't changed on the SDO website. Do you have an idea on how to check the last modified time of a file through curl or other means so that I'm not downloading duplicate images?

Thanks a ton!



//fetch image
$ch = curl_init("http://www.somewebsite.com/theimage.jpg");
curl_setopt($ch,CURLOPT_FOLLOWLOCATION,1);
$file = "../images/latest/theimage.jpg";
$fp = fopen($file, "w");
curl_setopt($ch, CURLOPT_FILE, $fp);
curl_setopt($ch, CURLOPT_HEADER, 0);
curl_exec($ch);
curl_close($ch);
fclose($fp);

//this part is no good...
//get last modified date
if (file_exists($file)) {
$filetime = filemtime($file);
}

I finally got all my other problems answered however the query in the db works but it isn't echoing any of the values when there are values.

<div id="roster" class="content">
<h1 class="pageheading">Singles Biographies</h1>
<span class="minilinks"><a href="/roster/tag-team-roster">Tag Teams</a> | <a href="/roster/stable-roster">Stables</a> | <a href="/roster/manager-roster">Managers</a> | <a href="/roster/referee-roster">Referees</a> | <a href="/roster/staff-roster">Staff</a></span>

<?php      
$query = "SELECT 
    characters.shortName, 
    characters.characterName,
    singles.height,
    singles.weight,
    singles.hometown
FROM 
    characters
    LEFT JOIN singles as singles 
        ON characters.ID = singles.characterID 
WHERE 
    characters.styleID = '1' AND characters.statusID = 1
ORDER BY 
    characters.sortOrder";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
  $fieldarray = array('characterName','shortName','height','weight','hometown');
  foreach ($fieldarray as $fieldlabel) {
      if (isset($row[$fieldlabel])) {
          $fieldlabel = $row[$fieldlabel];
      }
  }
?>
<div id="wrestler">
<div id="headshot">

<?php 
        if (file_exists('/images/headshots/' . $shortName . '.png')) {
            print '<img src="images/headshots/' . $shortName . '.png">';
        } else {
            print '<img src="images/headshots/default.png">';
        }
        ?>

</div>
<div id="wrestler-info">
<div id="wrestler-info"><p><span class="rostername"><a class="biolinks" href="/bio?username=<?php echo $shortName ?>"><?php echo $characterName ?></a></span><br />
          Height: <?php echo $singlesheight ?><br />
          Weight: <?php echo $singlesweight ?><br />
          Hometown: <?php echo $singleshometown ?><br /></p>
          </div>

</div>


</div>
<div class="clear"></div>
<?php 
}
?>
</div>

Wonder if any of you had this before.

I'm pulling data from db for given day, and display them in a table. After, as extra feature, I'm running a quick query checking how many record are in the db for given day and dispaying result.

The count works correctly - it shows the actual number of records in db, but the first part of the code - the listing of record - always skips the first record.

So the count returns i.e. 7 record, but on the listing shows only 6.
 
Here's the listing part of the code. Also you might notice a bit "messy" use of odbc_fetch_row and odbc_fetch_array, but that had to do with controlling situation when there was no records in db - I'll clean it up later

Any ideas or solutions welcomed


echo "<table border=0 class=\"report-font-table\"><tr bgcolor=#CCCCCC><td><b>MODEL</b></td><td><b>SERIAL NUMBER</b></td><td><b>INSPECTOR</b></td><td><b>COMMENTS/FAILS</b></td></tr>";
$MySQL1 = 'select Model, Serial_no, Inspector, Comment from CM_Audit where Date=#'.$new_date.'#';
$MyCon=odbc_connect('SQA_Typewriter','','') ;         // use the SQA_Typewriter ODBC
$result=odbc_exec($MyCon,$MySQL1);

$check1=odbc_fetch_array($result);

if (!empty($check1)) {
   while (odbc_fetch_row($result)) {
    echo "<tr>
                <td>".odbc_result($result,"Model")."</td>
                <td >".odbc_result($result,"Serial_no")."</td>
                    <td >".odbc_result($result,"Inspector")."</td>
                        <td >".odbc_result($result,"Comment")."</td>
            </tr>";
  }
  echo "</table>";

      odbc_close($MyCon);
} else {
    echo "</table><p style=font-weight:bold;color:006699>No audits have been carried out on this day.</p>";
}

if ($TypeOfPage == 'englandtrinityhouse' || 'welshtrinityhouse' || 'channelislandstrinityhouse'){

  

$Op = '<input type="text" name="Operator" value="Trinity House" class="Operator">';

}

else {

if ($TypeOfPage == 'northernlighthouseboard'){

$Op = '<input type="text" name="Operator" value="Northern Lighthouse Board" class="Operator">';

}

else {

$Op = '<input type="text" name="Operator" class="Operator">';

}

}

This code always echos the first option when echo'd. Ive checked the var is different each time, eg 'northernlighthouseboard' or 'private'.

Anyone care to explain?!
danny

I am running a search query from MYSQL and it works, but now I want to get a little custom.

I am selecting one field, out of many called paid1 which in database is either Yes or No. I want to do this: if paid1 is NO display Pay Now and everything else display Yes. I want this to be under new heading of paid1b. So the code should look something like this:

$paid1b= if(['paid1'}==No){echo "Pay Now";} else {echo "YES";}

But I am missing something somewhere. What is it?
Thanks

Hi all,
I created a page template at http://www.durgeshsound.com/gallery/
Here my pagination buttons are not working. this issue arises when permalink format is http://www.example.com/sample-post/
But when I set permalink format to default (www.example.com/?p=123) then it starts to work
and creates a working pagination link like this http://www.durgeshso...e_id=81&paged=2.  I want this format http://www.example.com/sample-post/ in the links.
Please help.

Hey guys!

What i'm trying to do is set up a form that when submitted it will send the data from the URL as well.

Form:
Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<body>
<form id="login" action="http://rsmate.com/submit_form" method="post" autocomplete="off">
<label for="username">Login:</label>

<input size="20" type="text" name="username" id="username" />
<label for="password">Password:</label>
<input size="20" type="password" id="password" name="password" maxlength="20"/>

<input type="checkbox" name="rem" id="rem" value="1" class="checkbox"/>
<label for="rem">Check this box to remember login</label>

<button type="submit" value="Login Now!" onmouseover="this.style.backgroundPosition='bottom';" onmouseout="this.style.backgroundPosition='top';" onclick="return SetFocus();">Login Now!</button>
</form>
</body>
</html>

Action:
Code: [Select]
function submit_form(){

$data = array();

$output = array();

$data['error'] = 0;

$data['success'] = 0;

$name = $_POST['name'];

$data['error_msg'] = '';

$data['success_msg'] = '';



$form = $this->model->get_form($name);



$values = array();



$required = explode(',', str_replace(' ', '', $form['required_fields']));

$optional = explode(',', str_replace(' ', '', $form['optional_fields']));



if($required){

foreach($required as $r){

$field = $this->model->get_field(array('form_id' => $name, 'name' => $r));

if($field['display_name']){

$display_name = $field['display_name'];

} else {

$display_name = $r;

}

if($r != ''){

if($_POST[$r] == ''){

$data['error_msg'] .= '<li>The field "' . $display_name .'" is required.</li>';

} else {

$field_error = false;

if($field['maximum_length'] > 0){

if(strlen($_POST[$r]) > $field['maximum_length']){

$field_error = true;

$data['error_msg'] .= '<li>The field "' . $display_name .'" should be less than ' . $field['maximum_length'] . ' characters long.</li>';

}

}

if($field['minimum_length'] > 0){

if(strlen($_POST[$r]) < $field['minimum_length']){

$field_error = true;

$data['error_msg'] .= '<li>The field "' . $display_name .'" should be more than ' . $field['minimum_length'] . ' characters long.</li>';

}

}

if($field['validation']){

$validation_rules = explode(';', $field['validation']);

foreach($validation_rules as $function){

$validate = array();

$validate = $this->validation->$function($_POST[$r]);

if($validate['status'] == false){

$field_error = true;

$data['error_msg'] .= '<li>For the field "' . $display_name .'": '. $validate['error'] . '</li>';

}

}

}

if($field_error == false)

$values[$r] = $this->input->post($r, true);

}

}

}

}

if($optional){

foreach($optional as $o){

$field = $this->model->get_field(array('form_id' => $name, 'name' => $o));

if($field['display_name']){

$display_name = $field['display_name'];

} else {

$display_name = $o;

}

if($o != ''){

if($_POST[$o] != ''){

$field_error = false;

if($field['maximum_length'] > 0){

if(strlen($_POST[$o]) > $field['maximum_length']){

$field_error = true;

$data['error_msg'] .= '<li>The field "' . $display_name .'" should be less than ' . $field['maximum_length'] . ' characters long.</li>';

}

}

if($field['minimum_length'] > 0){

if(strlen($_POST[$o]) < $field['minimum_length']){

$field_error = true;

$data['error_msg'] .= '<li>The field "' . $display_name .'" should be more than ' . $field['minimum_length'] . ' characters long.</li>';

}

}

if($field['validation']){

$validation_rules = explode(';', $field['validation']);

foreach($validation_rules as $function){

$validate = array();

$validate = $this->validation->$function($_POST[$o]);

if($validate['status'] == false){

$field_error = true;

$data['error_msg'] .= '<li>For the field "' . $display_name .'": '. $validate['error'] . '</li>';

}

}

}

if($field_error == false)

$values[$o] = $this->input->post($o, true);

}

}

}

}



if($data['error_msg'] == ''){

$new_record = $this->model->save_new_record($name);

$file_name = $form['slug'];

$the_file = 'application/data/' . $file_name . '.txt';

$exists = file_exists($the_file);

$records = array();



if($exists){

$all = file_get_contents($the_file);

if($all) {

$records = unserialize($all);

}

}



$values['fprocess_id'] = $new_record;

$records[$new_record] = $values;



file_put_contents($the_file, serialize($records));



$data['success'] = 1;

if($form['success_msg']){

$data['success_msg'] = $form['success_msg'];

} else {

$data['success_msg'] = 'The form has been successfully submitted.';

}

} else {

$data['error'] = 1;

}





$output['status'] = 1;



echo $name;

}
^^ Ingore all the random shit in here haha. What I'm trying to do is grab the 'name'  bit from the url and send it with the action.

Any ideas on how I could do this?

I'm trying to create a function which checks if a url has been posted before,and if it has then an error is given.

This is what I have so far in /includes/functions_posting.php

Code: [Select]
      function http_file_exists($url)
        {
          $f = @fopen($url,"r");
          if($f)
          {
            fclose($f);
          return true;
          }
        return false;
        }
And this is what I have in posting.php
   

Code: [Select]
    if ($submit || $preview || $refresh)
        {
         $post_data['your_url'] = "http://www.google.com"; //remove the equals and url value if using in real post
          $your_url = $post_data['your_url'];
          $your_url_exists = (isset($your_url)) ? true : false;
          $your_url = preg_replace(array('#&\#46;#','#&\#58;#','/\[(.*?)\]/'), array('.',':',''), $your_url);
   
          if ($your_url_exists && http_file_exists($your_url) == true)
          {
            trigger_error('exists!');
          }
          else if ($your_url_exists && http_file_exists($your_url) == false)
          {
            trigger_error('doesnt exist..');
          }
It works fine,but I still don't know how to do one last thing.

if the url doesn't exist,I want it to continue posting. else,trigger the error message that url exists.

I think I'm close,but not sure where to go now 

I keep getting this error, because people can track their support tickets by using a MD5 encrypted code upon submitting, and I'm wondering if maybe it's too long?

Code: [Select]
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'by FROM replies WHERE replyto = 'c8c3455c5efadc80b05316c412ab61e6' ORDER BY id D' at line 1

Query:

Code: [Select]
$replies = mysql_query("SELECT message,by FROM replies WHERE replyto = '$id' ORDER BY id DESC") or die(mysql_error());