PHP - Changed An Else/if But Now Fails... What Did I Miss?

Ive created a process which automatically creates a form for all of the "courses" that are listed in a database. This table shows the name, the course code, the current program the course is under and an option to delete the course. I have created a drop down menu for the user to select any of the current programs to switch the course into. My problem is I have X amount of select fields and radio buttons and I dont know how to tell which one has been changed below is my code, appreciate the help!:



        case "ep":
        
        if (isset ($_GET['id'])){
            $id = $_GET['id'];
                    echo "Below lists all of the current courses under this program. Once you have made all of the changes click the submit button at the bottom of the page. <br><br><br>";
                    $query = "SELECT * FROM courses WHERE cid = $id";
                    $result = mysql_query($query) or die (mysql_error());
                    echo "<form action=\"course_process.php\" method=\"post\">";
                    echo "<table><tr><td><strong>Course Name</strong></td><td><strong>Course Code</strong></td><td><strong>Change Course Program</strong></td><td><strong>Delete</strong></td></tr>";
                    $i = 0;
                    
                    while ($row = mysql_fetch_assoc($result)){
                        $r = $row['id'];
                        $query2 = "SELECT * from catagories";
                        $result2 = mysql_query($query2) or die (mysql_error());
                        echo "<tr><td> ". $row['name']. " </td><td> ".$row['code']." </td><td><select name=\"".$row['id']."\">";
                        
                        while ($row2 = mysql_fetch_assoc($result2)){
                        
                        echo "<option value=".$row2['id'].">".$row2['name']. "</option>";
                            }
                            
                             echo "</select></td><td><input name=\"".$row['id']."\" type=\"radio\" value=\"Click to delete\" /></td></tr>";
                    }
                    echo "<tr><td></td><td></td><td></td><td><input name=\"submit\" type=\"submit\" value=\"Commit Changes\" /> </td></tr></table></form>";
                    
                    
                }else{
                    echo "Invalid action request. ERROR CODE 1";
                    
                }
                
        break;

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

OK I'm 98% new to PHP. I'm trying to do my own website and my idea will work something like this:

index.php
____________________
Header + Nav
{PHP INCLUDE}
Footer
____________________

The content will reside in another *.php page

If you look at www.avlscotland.com/test 'temporary'

It loads default.php when you go to the page which is perfect.

I have it working in basic form although only the hyperlinks
HOME - ABOUT AVL - DEAD LINK are active at this moment.

So it works this way with everything in the same directory,
but I want it to load the content from a subdirectory /test/pages/content.php

This is the PHP code I am using

<?php

// Check if page has been requested
if (!isset($_GET['content'])) { // Page has not been requested, show default page
$content = 'default.php';

} else { // Page has been requested, validate page exists, show page
$content = $_GET['content'].'.php';

} // End if page has been requested

// Check to see if page exists
if (file_exists($content)) { // Page exists

// Show page
include("$content");

} else { // Page doesn't exist

echo '<br>';
echo '<br>';
echo '<br>';
echo 'Sorry, the page that you are trying to access does not exist.<br>';
echo 'Please return to <a href="http://www.avlscotland.com/test/index.php">AVL Scotland</a><br>';
echo '<br>';
echo 'Thank you.<br>';
} // End if page exists
?>


I'm accessing the pages using links like
<a class="menuactive" href="test/index.php?content=avl">Home</a>

What I'm struggling to do is make the PHP look for the content files in a sub-directory.

Look forward to any help you can offer.

Thanks,

Ross

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 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'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 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);
}

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.

i use file_get_contents() to grab entire web pages to send as html emails. How can i error check that the url i use in file_get_contents() actually exists. I thought i could put it in an if statement like cURL but that doesn't work.

Code: [Select]
<?php

if($email_body = file_get_contents($url))
{
$config['mailtype'] = 'html';
$this->email->initialize($config);
$this->email->from('support@test.com', 'Testing');
$this->email->to($email);
$this->email->subject("Confirm Reply-To Email");
$this->email->message($email_body);
$this->email->send();
        }

I am having an issue in which fopen randomly generates either timeout or "failed to open stream" errors when trying to get stock quotes from yahoo finance.

Here's an example.

<b>Warning</b>:  fopen(http://finance.yahoo.com/d/quotes.csv?s=NFLX&amp;f=sl1d1t1c1ohgv&amp;e=.csv) [<a href='function.fopen'>function.fopen</a>]: failed to open stream: HTTP request failed!

This issue occurs sporadically; sometimes it's fine, other times it errors out causing the quote to fail.

Any ideas on how I can resolve this? Thanks very much.

I have release notes on my server, at example.com/release.txt. My software points to this file so people can see the notes:

Code: [Select]
file_get_contents( http://example.com/release.txt );
Why -- since all sites are on the internet -- can most of my customers see the file but some cannot? Just seems odd to me. Could some servers be turning that off or something? Doesn't seem like a problem on my server.

I'm trying to pull the stock quotes Beta from yahoo finance since the yahoo query language doesn't support it. 

My code returns an empty array.  Any ideas why?

Code: [Select]
<?php

$content = file_get_contents('http://finance.yahoo.com/q?s=NFLX');
preg_match('#<tr><th width="48%" scope="row">Beta:</th><td class="yfnc_tabledata1">(.*)</td></tr>#', $content, $match);

print_array($match);

?>

I have installed a new extension on my server. After installation, i see the .so file in the extension directory. I also added the extension to the php.ini file. However, php still fails to load the extension. Any suggestions on how i can fix this?   I am running PHP 5.* with Apache/2.* (CentOS)   Restarted apache server after adding the extension in the php.ini file.   I followed the installation instructions as listed on this website: http://www.mickgenie...-centos-server/