PHP - If Statement, How To Include Variable For Empty

Hello can anyone help with my code, it bombs out if I dont add in a file for attachment but i want to be able to add to the database with just comments (sometimes without a file) Any help appreciated!!!


$timestamp = time();
$tbl_name="guestbook"; // Table name
$email = $_REQUEST["email"];
$name = $_REQUEST["name"];
$comment = $_REQUEST["comment"];
$datetime = date("dmy");
$uploaddir = "upload/";
$filename = $timestamp.$file['file']['name'];
$filename = strtolower($filename);
$final_location = "$uploaddir$filename";
$pathinfo = pathinfo($_FILES['userfile1']['name']);
if ((($_FILES["file"]["type"] == "image/gif")
|| ($_FILES["file"]["type"] == "image/jpeg")
|| ($_FILES["file"]["type"] == "image/pjpeg"))
&& ($_FILES["file"]["size"] < 2000000))
{
if ($_FILES["file"]["error"] > 0)
{
echo "Return Code: " . $_FILES["file"]["error"] . "<br />";
}
else
{
echo "Upload: " . $filename . "<br />";
echo "Type: " . $_FILES["file"]["type"] . "<br />";
echo "Size: " . ($_FILES["file"]["size"] / 1024) . " Kb<br />";
echo "Temp file: " . $_FILES["file"]["tmp_name"] . "<br />";

if (file_exists($final_location))
{
echo $filename . " already exists. ";
}
else
{
move_uploaded_file($_FILES["file"]["tmp_name"],
$final_location);
echo "Stored in: " . $final_location . "<br>";

mysql_connect("$host", "$username", "$password")or die("cannot connect server ");
mysql_select_db("$db_name")or die("cannot select DB");

$sql="INSERT INTO $tbl_name(name, email, comment, datetime, upload)VALUES('$name', '$email', '$comment', '$datetime', '$final_location')";
$result=mysql_query($sql);
}
}
//}
else
{
echo "Invalid file";
}

if($result){
echo "Successful added update to the Board";
echo "<BR>";
echo "<a href='HomePage4.php'>View Bulletin Board</a>"; }

else {
echo "ERROR";
}

mysql_close();
?>

I am trying to insert a record into a mysql database which has a $ as part of the value of a field.  But it seems that when the INSERT query is processed its actually looking for a variable with that name and not just inserting the raw text.  Here is the insert query


$query = "INSERT mytable SET myfield='I would like to have this field contain this information with a $matches[1] showing in the field value as well'";


$matches[1] has no value.  Its not a variable which is in this script.  I am not trying to insert the value of it.  I just want to insert the actual text characters $matches[1]

How can I do that?

This topic has been moved to CSS Help.

http://www.phpfreaks.com/forums/index.php?topic=332328.0

I'm trying to create a INSERT query statement that makes use of the content of 'include' files. When I call up the include it simply echos it to the screen but I can't seem to capture the text string and actually make it function as part of the query. I've tried setting the include as a variable but again it only outputs to the screen. Help please! Here's a portion of the code...

if (($_POST['sched_templates']) == "sched_TestingOnly.htm") {
   $query = include 'sched_TestingOnlyQuery1.htm';   
   }
      if (@mysql_query ($query)) {
         mysql_close(); // End adding Registration to the database
         header ('Location: redirectfile.htm');
         exit();
      } else {
      print "<p><b>Sorry, your entry could not be entered.
      }

I have this line in my code

$result2 = mysqli_query($link, 'Select * from categories where cat_loc ='.$nav['id']);

how do I say "if $result2 is empty or false"? (basically if it didn't find any cat_loc = to $nav['id'])

 to echo '</li>';

i am pulling the login date from the databases and i want it to check if the variable is empty and if it is echo Never Loged In and if it not empty echo the date
          <?php
          include'db.php';
  $id=$_GET['id'];
  $sql=mysql_query("SELECT * FROM admin WHERE id='$id'")or die(mysql_error());
  while($row=mysql_fetch_array($sql))
  {
  $date=$row['login_date'];
  if($date > 0)
  {
  echo"Never Loged In";
  }
  else
  {
  echo"$date";
  }
  }
  ?>

I'll try to explain this as easily as possible. 
I'm working on making a little link shortener site just for fun/practice as a beginner with php.
I originally used the source code 'lilurl' as a base to start out, but now I'm adding stuff to it for actual practice.
I need some help though.
I have two files, my index and my external php file.  The external file is called on at the beginning of the index with require_once.
The user submits a url into the PHP_SELF form and a url is returned, and it works all great.  Now I'm trying to add the option to make a custom url suffix. 
Code: [Select]
<form action="<?php echo $_SERVER['PHP_SELF']?>" method="post">

<fieldset>
<label for="longurl">Enter a URL:</label>
<input type="text" name="longurl" id="longurl" />
<input type="text" name="suffix" id="suffix" />
<input type="submit" name="submit" id="submit" value="Shrink!" />
</fieldset>

</form>[/code]
The form looks like this.  I added the 'suffix' textbox. 

So after the user submits the code, it goes back up to the top (phpself).
A variable is set for the url the user has inputted as "$longurl", like this.
Code: [Select]
$longurl = trim(mysql_escape_string($_POST['longurl']));So I added this.
Code: [Select]
    $suffix = ($_POST['suffix']);And to check if it worked, I went down the the bottom of the index and had it echo the suffix variable.  When I entered in code into the suffix text box, it would be echoed at the bottom of the page, so the variable did receive the value. 

So here's where the external file comes in. 
It is called on by require_once at the very beginning of the index.  It is full of functions.  One of the functions generates a random string of numbers (that I coded) to be used as the url suffix (uses the $id variable).  So my plan was to erase the $id = $rand1 . blah blah stuff and put $id = $suffix.  $suffix being the variable from the index that the user inputted.  Make sense?  Well whenever I try it, it always acts the like the variable is empty, even when I echo it on the index it returns the value of the textbox.  Does anyone know what I'm doing wrong?  Could it be because since I call on $suffix in the external file, and it's only been declared in the index that it's treating it like a new/empty variable? 

[spoiler]
Someone also explained it to me like this.
-I call upon the external file.
-I declare the variable is the value of the text box.  (Which means it's currently empty because the form has not been submitted.)
-Then, the form is submitted as PHP_SELF.

-The external file is called upon again.
-The variable is then assigned a value. 
It's hard to explain, but basically that the variable in the external file is not told about the new value of the variable because they are declared after the external file is called upon? :\

So I tried moving the  $suffix = ($_POST['suffix']); before the external file is called upon, but the same thing happens.  It's hard to explain the situation, but I've tried a lot of things and can't get it to work.[/spoiler]

How would I write this in php?:

Code: [Select]
If $url does not begin with 'http://'
$url = ''
I want to assign nothing to the variable if it doesn't begin with http://

Thanks! 

I know the following simple demonstration fails and what to do to rectify it (though with a lot of additional code is necessary), but I don't know why this is the behaviour. It would be great if someone could explain to me why, and what the neatest way of fixing it would be.

Code: [Select]
+----------+--------------+------+-----+---------+
| Field    | Type         | Null | Key | Default |
+----------+--------------+------+-----+---------+
| Id       | int(11)      | NO   | PRI | NULL    |
| Name     | varchar(45)  | YES  |     | NULL    |     
| Number   | int(9)       | YES  |     | NULL    |         

Code: [Select]
$name = "Bradley Cooper";
$number = "";

$query = "INSERT INTO table (Id, Name, Number) VALUES (1, '$name', $number)";
mysql_query($query);

Because the $number variable is empty, this simple query fails. Logically, one would think that nothing or NULL gets inserted to that field since the MySQL structure rule states that default is NULL, and since nothing is fed to it in the query, I think that it would automatically be NULL since if the column is omitted, that is exactly the value that will be inserted.

Enclosing the variable with quotes is not preferable since this field accepts integers. Also, converting the variable to an integer by (int)$number results in a 0, which is not what I want either. Checking if the variable is empty of not, and if it is, assign $number = "''" so that the query would succeed by enclosing the empty string with single quotes. But this creates a lot of unnecessary code (some of my tables are 80 columns wide and the query therefore have equal amount of variables).

So to summarise, why is this happening and how do I neatly avoid assigning quotes to the empty strings? In other words, how do I insert nothing when variables that usually contain an integer is on occation empty?

Hi all

I am writing a code to update customer details. It all works great until I get to the last line of code that directs the user to the next page:

include ('profile-success.php');

I need it to be the following page:

profile-success.php?username=$username

Can anyone show me how to edit the line to include the url variable?

I keep getting this error:

Warning: include() [function.include]: Failed opening 'profile-success.php?username=$username' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/cndvizp/public_html/prints2impress.co.uk/upload/update-profile.php on line 96

Thanks
Pete.

Is if($variable) the same as if(!empty($variable)), just different syntax?

 

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.

My catalog uses a template file to list product details.  One part of it is responsible for putting these details into nifty little tabs:

<?php
$template = '{magictabs style=black_rounded, tabwidth=110px}';
   $template .= 'Technical Specifications';
   $template .= '::';
   $template .= '<table colspan="3"><tr><td>';
   $template .= $details;
   $template .= '</td></tr></table>';
   $template .= '||||';
?>


I don't want it to output $details, I want it to output a separate script instead.

How do I include this separate file as a variable? I want this:
<?php include('specs.php'); ?>
to replace the $details variable.

Hello
I have a website that I am trying to upgrade so that all the data can be placed into a MySql database.
I know what I need but I do not know if it is possible with PHP and MySql.

I need to insert into a Href link a variable so that when the link is clicked it would initiate a MySql search for data.

The variable would contain the Key id of the person whose name was clicked. This is very difficult to explain so a visit to the static website may help understand what I am trying to achieve, www.westonheritage.co.uk
If you go to the second page by clicking the key then click on any of the surnames listed.

I have the database setup on localhost and can get out the data I require.

Kind regards

SOLVED