PHP - Include Url With Variable

 

Hi All,

I've been trying to access xml data from an API feed, but it needs a Variable to be passed to an include file without a form. the include is at the header of the page.

in the code below, i'm trying to retrieve the variable $project_add from the $xml_2 feed. $proj_add_ID comes from another feed and is being passed ok. 

foreach ($projects_1 as $proj_1) {

                        $job_no =$proj_1['job_no'];
                        $job_name =$proj_1['job_name'];
                        $job_status =$proj_1['job_status'];
                        $job_staff =$proj_1['job_staff'];
                        $job_due =$proj_1['job_due'];
                        $clr_1 = $colors_1[$job_status];
                        
                        if ($err_2) {
                        echo "cURL Error #:" . $err_2;
                         } else {
                        $_POST['job_id']= $job_no;
                        $xml_2=simplexml_load_string($response_2) or die("Error: Cannot create object");
                        $proj_add = $xml_2->xpath("CustomFields/CustomField[ID ='$proj_add_ID']");                         
                            foreach($proj_add as $item_2) {
                            $project_add = "$item_2->Text";
                        }            
                        echo "<div class='row no-gutters'>";
                        echo "<div class='col-sm bg-white border rounded'><a href='managejob.php?job_id=$job_no' class='text-left ml-1'><strong>$job_no</strong></a></div>";
                        echo "<div class='col-sm-2 bg-white border rounded'><p class='text-left ml-1'>$job_name</p></div>";                         
                        echo "<div class='col-sm-2 bg-white border rounded'><p class='text-left ml-1'></p>$project_add</div>";                        
                        echo "<div class='col-sm-2 bg-white border rounded'>" . state_dropdown_1($job_no, $job_status, $clr_1) . "</div>";                        
                        echo "<div class='col-sm-2 bg-white border rounded'><p class='text-left ml-1'>$job_staff</p></div>"; 
                        echo "<div class='col-sm-2 bg-white border rounded'><form action='CALL_API_PUTTaskDate.php' method='POST'>"
                                . "<input type='hidden' name='task_ID' value ='". $jdata['task_ID'] ."'>"
                                . "<input type='hidden' name='est_min' value ='". $jdata['est_min'] ."'>"
                                . "<input class ='form-control bg-white text-dark font-weight-bold' type='date' name='start_date' value='" . date('Y-m-d', strtotime( $jdata['display_date_1'] )) . "' onchange='this.form.submit()'>"
                                . "</form></div>";
                        echo "<div class='col-sm bg-white border rounded'><p class='text-left ml-1 mt-1'><strong>" . date('d/m/Y', strtotime( $jdata['display_date'])) . "</strong></p></div></div>";
                        
                       }

The include file is like this

/ collect Custom Felds
if ($_SERVER["REQUEST_METHOD"] == "POST") {
    // collect value of status input field
    $job_no = $_REQUEST['job_id'];
      } 

if (isset($_POST['job_id'])) {
$job_no = $_POST['job_id'];
}

if (isset($_GET['job_id'])) {
$job_no = $_GET['job_id'];
}

$curl_2 = curl_init();

curl_setopt_array($curl_2, array(
  CURLOPT_URL => "https://api.xxx.com/job.api/get/$job_no/customfield?apiKey=xxx&accountKey=xxx",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "GET",
  CURLOPT_HTTPHEADER => array(
    "Accept: */*",
    "Accept-Encoding: gzip, deflate",
    "Cache-Control: no-cache",
    "Connection: keep-alive",
    "Host: api.xxx.com",
    "Postman-Token: xxx",
    "User-Agent: PostmanRuntime/7.17.1",
    "cache-control: no-cache"
  ),
));

$response_2 = curl_exec($curl_2);
$err_2 = curl_error($curl_2);

curl_close($curl_2);

The problem is the variable $job_no isn't getting passed to CURLOPT_URL so it's not retrieving the data required. i need to be able to retrieve this data without submitting a form as it's in a foreach loop and the Id is specific to each iteration. is there a way to do this? I have been able to achieve this by putting the include within the div tags that it will be displayed but it just slows down everything too much and hangs. 

Any help will be much appreciated. 

Kind regards,

Michael Bennington.

Ok it's abit complicated so i'll try to explain as best as I can.
Upon registration a file is created with your username that was registered and also a file for your profile named after your username so it would be /profiles/usernamesprofilehere.php.

I put a code into the profile that is:
Code: [Select]
include ("/home/giacjrdi/public_html/mysite/profiles/profileinfo/$username.info.php");
echo "<center><b><br /> $user's Profile <br /></b></center>";
$username is calling the cookie's username
while $user is calling the account's username.

eg if I try to view "bob"'s profile but logged in as "fred" since the include function is under $username which is cookies, it will retrieve "fred"'s information and post it on "bob"'s profile.

The only sollution i can think of would be to store a username variable in the url and use it for the include function.

Hello all,

I am a beginner at PHP and trying to form an IF statement, I'm running into a problem which I cannot seem to solve.
Due to my lack of syntax knowledge I would appreciate if someone could point me in the right direction.

The combo variables are sent to this page through a form and defined as these variables at the top of the page.
e.g $combo0 = $_POST["combo0"];

When the results are displayed any form field which was left blank or empty I want to show "N/A" if data is detected in being sent through the form I then want the "Else" statement to take affect.

Currently when I run the below statement N/A is echoed despite if data was sent through the form fields or not....

if (empty($scrap))  {
echo "<h3>Submitted Scrap Results</h3> No scrap parts were booked off";
}
elseif (empty($combo0) || empty($combo1) || empty($combo2) || empty($combo3) || empty($combo4)) {
echo "N/A";
}
else {
echo "<h3>Submitted Scrap Results</h3> <b>Reason:</b> " .$combo0." - ".$combo1." - ".$combo2." - ".$combo3." - ".$combo4."
<br /> <b>on machine</b> " .$mid. " - <b>No. Scrap</b> " .$noscrap. "";
}

Anyone any ideas?

Hi

Still a new comer when it comes to PHP.

I have a situation where I want to use an include within an include and I am having trouble with my file paths.

My main header include, includes everything for each page of my site, beyond the opening of the body to incorporate my navigation etc conditionally loading in css, and loading in titles and meta data etc depending on the page in question.

This header needs to reference another include called the-pod.php which is required for every page, the only trouble is I want to use / to reference the root of the server and this is breaking my code. I can't use ../../ etc as its a different path depending on where the master file is located.

So my question is how do I get around this?

Can the root of the server or path to the root be stored in a variable? and if so how would I write this.

Any tips / advice will be greatly appreciated.

Hi Guys.. Merry Christmas

Im kinda new to this fantastic world of PHP and i have a little problem i hope you can help me with.

Im trying to build a website where I use include() to genereate my content. On my index.php i have a menu which includes
content in a content div from external .php pages, my structure kinda goes like this.. (simplified)

site/
   index.php
   content/
       fronpage.php
       products.php
       contact.php

The HTML looks like this.

<div id="menu">
    <ul>
          <li><a href="index.php?page=frontpage">frontpage</a></li>
          <li><a href="index.php?page=products">frontpage</a></li>
          <li><a href="index.php?page=contact">frontpage</a></li>
    </ul>         
</div               

<div id="main">

<?php
     include('/content/'.$_GET['page'].'.php');
?>

</div>

This all works very fine, but my problem is, can I have a include inside an already included page?
I would like to have a menu on my products.php site, but that page is already included from above,
and i would like the menu on the products.php site to stay as the content from the nested include
changes with input from the /products folder.

my idea was something like this.

site/
   index.php
   content/
      frontpage.php
      products.php
      contact.php
      products/
         product1.php
         product2.php


the HTML on the index.php is the same as above and then i would add the include() on the
products.php page, so its kinda the same thing, but one inside the other.

HTML inside the products.php folder

<div id="sub_menu">
    <ul>
          <li><a href="#">frontpage</a></li>
          <li><a href="#">frontpage</a></li>
          <li><a href="#">frontpage</a></li>
    </ul>         
</div               

<div id="sub_main">

<?php
     include('/content/products'.$_GET['#'].'.php');
?>

</div>

I dont know how to link to the new files so they will be included while the first include still stays on the page.

Any of you know how and if this can be done? Or maybe at better way to do it?

Hope this made sense, my first PHP question

Thanks

CanI put one INCLUDE statement INSIDE of another INCLUDE statement?

When I put this above all else in my document and test it offline, all I see is code in the browser. But when I test it on my web server, I can view the markup and whatnot.

Does anyone know why this is?

I am trying to allow the user to update a variable he chooses by radio buttons, which they will then input text into a box, and submit, to change some attributes. I really need some help here.  It works just fine until I add the second layer of variables on top of it, and I can't find the answer to this question anywhere.

<?PHP require('connect.php'); ?>

<form action ='' method='post'> <select name="id">

<?php
$extract = mysql_query("SELECT * FROM cars");
   
   while($row=mysql_fetch_assoc($extract)){
   $id = $row['id'];
   $make= $row['make'];
   $model= $row['model'];
   $year= $row['year'];
   $color= $row['color'];

echo "<option value=$id>$color $year $make $model</option>
";}?>

</select>

Which attribute would you like to change?<br />
<input type="radio" name="getchanged" value="make"/>Make<br />
<input type="radio" name="getchanged" value="model"/>Model<br />
<input type="radio" name="getchanged" value="year" />Year<br />
<input type="radio" name="getchanged" value="color"   />Color<br /><br />

   <br /><input type='text' value='' name='tochange'>
   <input type='submit' value='Change' name='submit'>

</form>

//This is where I need help...

<?PHP
if(isset($_POST['submit'])&&($_POST['tochange'])){
mysql_query("
   UPDATE cars
   SET '$_POST[getchanged]'='$_POST[tochange]'
   where id = '$_POST[id]'
         ");}?>

Hello all. I am very new to PHP, and I am not sure where to look or what I'm looking for in my current assignment.

My task is to take in two numbers between 0-100. Once I take in that number, it should state beside it "The __ was accepted."
The program should not accept any numbers greater than 100 or any characters.

Once I do this, I must take a second number and do a similar thing.

Finally, I must have a statement show up at the bottom stating which number is greater.

Essentially, I need help in determining what I should use to place parameters, and how I can keep the program from echo ing any statement until input has been taken and tested for parameters.

Any help you can provide will be greatly appreciated!

My login script stores the user's login name as $_SESSION[ 'name'] on login. For some unapparent reason, i'm getting errors stating that $user  and $priv are  undefined variables, though I've attempted to define $user as being equal to $_SESSION['name'], using $user to look up the the user's privilege level (stored as the su column ) in the SQL table, and then where the result of the sql query is $priv which is then evaluated in an if statement. I can't seem to figure out why this might not be working.

The code I'm using:

<?php
session_start();
function verify() {
	//verify that the user is logged in via the login page. Session_start has already been called. 
	if (!isset($_SESSION['loggedin'])) {
	header('Location: /index.html'); 
	exit;
	}
	//if user is logged in, we then lookup necessary privleges. $_SESSION['name'] was written with the login name upon login. Privleges   // are written in db as a single-digit integer of of 0 for users, 1 for administrators, and 2 for special users. 
        $user === $_SESSION['name'];
    //Connect to Databse
	$link = mysqli_connect("127.0.0.1", "database user", "password", "database");
	if (!$link) {
  	  echo "Error: Unable to connect to MySQL." . PHP_EOL;
    	echo "Debugging errno: " . mysqli_connect_errno() . PHP_EOL;
    	echo "Debugging error: " . mysqli_connect_error() . PHP_EOL;
    	exit;
        }
        //SQL Statement to lookup privlege information. 
       if ($result = mysqli_query($link, "SELECT su FROM accounts WHERE username = $user", MYSQLI_STORE_RESULT)) {
         //LOOP TO CYCLE THROUGH SQL RESULTS AND STORE Privlege information as vairable $priv.
            while ($row = $result->fetch_assoc()) {
           $priv === $row["su"];
            }
        }
        // close SQL connection.
        mysqli_close($link);

 // Verify privleges and take action. Only a privlege of "1" is allowed to view this page. A privlege of "2" indicates special 
//accounts used in other scripts that have certain indermediate additional functions, but are not trusted administrators. 

        if ($priv !== 1) {
        echo $_SESSION['name'];
        echo "you have privlege level of $priv";
        echo "<br>";
        echo 'Your account does not have the privleges necessary to view this page';
        exit;
        }
        
}
verify();
?>

 

I have just re-installed Xampp and suddenly my sites are now displaying lots of:

Notice: Use of undefined constant name - assumed 'name' in ...
Notice: Use of undefined constant price - assumed 'price' in ...

this is an example of the line its refering too:

$defineProducts[1001] = array(name=>'This is a product', price=>123);

I have a script that adds points together based upon the placing. This is the actual script:

Code: [Select]
<? $points = 0;

if($place === '1st') {$points = $points + 50;}
elseif($place === '2nd') {$points = $points + 45;}
elseif($place === '3rd') {$points = $points + 40;}
elseif($place === '4th') {$points = $points + 35;}
elseif($place === '5th') {$points = $points + 30;}
elseif($place === '6th') {$points = $points + 25;}
elseif($place === '7th') {$points = $points + 20;}
elseif($place === '8th') {$points = $points + 10;}
elseif($place === '9th') {$points = $points + 10;}
elseif($place === '10th') {$points = $points + 10;}
elseif($place === 'CH') {$points = $points + 50;}
elseif($place === 'RCH') {$points = $points + 40;}
elseif($place === 'TT') {$points = $points + 30;}
elseif($place === 'T5') {$points = $points + 30;}
elseif($place === 'Champion') {$points = $points + 50;}
elseif($place === 'Reserve Champion') {$points = $points + 40;}

echo "Total HF Points: $points";
?>What it *should* do (my friend's script works the same way and it works) it starts at points = 0, than if there is a first place, it adds 50, and so forth until it reaches the end.

It is included into a file, in this area:

Code: [Select]
<div class="tabbertab">
<h2>Records</h2>
<? $query92 = "SELECT * FROM THISTABLE WHERE VARIABLE='$id' OR VARIABLE = '$name' ORDER BY ABS(VARIABLE), VARIABLE";
$result92 = mysql_query($query92) or die (mysql_error());

echo "<table class='record'>
<tr><th>Show</th> <th>Class</th> <th>Place</th></tr>
";

while($row92 = mysql_fetch_array($result92)) {
$class = $row92['class'];
$place = $row92['place'];
$entries = $row92['entries'];
$race = $row92['show'];
$purse = number_format($row92['purse'],2);

echo "<tr><td>$race</td> <td>$class</td> <td>$place</td></tr>";
}
?>
<tr><td colspan='3'><div align='right'><? include('includes/points.php'); ?></div></td></tr>
</table>
</div>

This is the code that is relevant. When ended here, it echoes the last place that appears in the results (such as a 5th place echoing 30 points). When I move it to be included in the while loop, it shows Total Points: 50 Total Points: 25 Total Points: 10 (depending on the results displayed on that page). What am I doing wrong?

Hello everyone,

I can get Test 2 to successfully operate the if statement using a variable variable.

But when I try the same method using a session variable (Test 1) the if statement is not executed. Please could you tell me why the if statement in Test 1 is not being executed?

Code: [Select]

<?php
# TEST 1
$_SESSION[test_variable] = "abcd";
$session_variable_name = "_SESSION[test_variable]";
if ($$session_variable_name == "abcd")
{
echo "<br>line 373, abcd<br>";
}

# TEST 2
$test_variable = "efgh";
$test_variable_name = "test_variable";
if ($$test_variable_name == "efgh")
{
echo "<br>line 379, efgh<br>";
}

?>
Many thanks,

Stu

I have a form that creates rows of data input textboxes depending on a user input number of things.  I have a naming convention for all these textboxes that basically just keeps incrementing a number suffix for each row.  All this is working fine.

My problem is I need to get the data inserted into this table of textboxes into an array.

Here's my code where I attempt to to this (it does not work):

Code: [Select]
$temp = $_SESSION['Num_Part'];
$count = 1;
while ($count <= $temp){
  $temp2[$count] = "'Participant_P".$count."'";
  //echo $temp2[$count]."<br/>";
  $temp3[$count]=$_POST[$temp2[$count]];  //here's the problem
  $temp4[$count] = "'Result_P".$count."'";
  $temp5[$count]=$_POST[$temp4[$count]];  //here's the problem
  //echo $temp4[$count]."<br/>";
  $count++;
}

The problem is that the $_POST does not work with the variable in the argument position - even though the argument is formatted with single quotes.

Can a variable be used in a POST argument and if so what is the correct syntax?

If not, is there some other simple solution to harvest the data into an array.  I understand I can harvest by explicitly accessing each key in the post assoc array.  But this could be dozens of rows of input fields.

Thanks in advance for your help here.  I couldn't find anything online re this topic.

Quote

i need to store a variable from database like if i have "copies" in one of my column in my database then i have to store a particular value for copies store it to $copies
here i want that i can store value of copies into $copies




$update_book="update book set copies=copies-1 where bookid='$bookid'";
        $result=mysql_query($update_book,$linkID1);
            if($result)
            {
            print "<html><body background=\"header.jpg\">
            <p>book successfully subtracted from database</p></body></html>";
            }
            else {
            print "<html><body background=\"header.jpg\">
            <p>problem occured</p></body></html>";
            }

    }