PHP - Having Trouble With Include / Get Statement. Help!

hi guys
i am including a function in my main script, and i'm calling it aftwerwards. except i cannot echo successfully the data in the $result variable, why?


function echoResult(){
  $result = 'dan';
  return $result;
}
// 1
echo echoResult(); // don't work. i get empty data.
// 2
$fnResult = echoResult();
echo $fnResult; // don't work. get empty data.


i have ran get_included_files and the include is being made successfully.
i read on php.net and these are the examples they use (user comments!)
how do i get the data out of the function and echo it, using this way?

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 as my code:


if(!empty($stipulation)){
if($stipulation == "Championship Title Match"){
print "<h3 class=title>".$title." Match</h3>";
}
else{
 print "<h3 class=stipulation>".$stipulation."</h3>";
}
}


however I'm wanting to make it to where if it $stipulation has a value then it echos it and nothing if it doesn't have a value then don't nothing else happens. I also need a similiar if statement that will check to see if there is a value for $title and if there is then it echos $title Championship Match and again if no value exists it does nothing.

I'm trying to figure out why my entire if statement is not working properly. What is happening when I run my form is that it puts it into the first if statement regardless of what the value of $style is and I don't know why. The other parts of the for submission works BUT my if statement. And inside of firebug it is passing the RIGHT post data so it has the correct value for style each time.

<?php

// Include the database page
require ('../inc/dbconfig.php');

if (isset($_POST['submitcharacter'])) {
    $charactername = mysqli_real_escape_string($dbc, $_POST['charactername']);
    $charactershortname = mysqli_real_escape_string($dbc, $_POST['charactershortname']);
    $sortorder = mysqli_real_escape_string($dbc, $_POST['sortorder']);
    $style = mysqli_real_escape_string($dbc, $_POST['style']);
    $status = mysqli_real_escape_string($dbc, $_POST['status']);
    $alignment = mysqli_real_escape_string($dbc, $_POST['alignment']);
    $division = mysqli_real_escape_string($dbc, $_POST['division']);

    $query = "INSERT INTO `characters` (charactername, charactershortname, status_id, style_id, division_id, alignment_id, sortorder, creator_id, datecreated) VALUES ('$charactername','$charactershortname','$status','$style','$division', '$alignment', '$sortorder', 1, NOW())";
    mysqli_query($dbc, $query);
    $query_id = mysqli_insert_id($dbc); 
    $query1 = "INSERT INTO `allies` (character_id) VALUES (".$query_id.")";
    mysqli_query($dbc, $query1);  
    $query2 = "INSERT INTO `rivals` (character_id) VALUES (".$query_id.")";
    mysqli_query($dbc, $query2);  
    if ($style = 1) {
        $query3 = "INSERT INTO `singles` (character_id) VALUES (".$query_id.")";
        mysqli_query($dbc, $query3);  
     } elseif ($style = 2) {
        $query4 = "INSERT INTO `tagteams` (character_id) VALUES (".$query_id.")";
        mysqli_query($dbc, $query4);
     } elseif ($style = 3) {       
        $query5 = "INSERT INTO `managers` (character_id) VALUES (".$query_id.")";
        mysqli_query($dbc, $query5);        }       
     } elseif ($style = 4) {
        $query6 = "INSERT INTO `stables` (character_id) VALUES (".$query_id.")";
        mysqli_query($dbc, $query6);  
     } elseif ($style = 5) {
        $query7 = "INSERT INTO `referees` (character_id) VALUES (".$query_id.")";
        mysqli_query($dbc, $query7);  
     } else {
        $query8 = "INSERT INTO `staff` (character_id) VALUES (".$query_id.")";
        mysqli_query($dbc, $query8);   
     }
        
?>

Hey guys, I'm trying to get this working... No errors right now, but I'm not returning any results :/ been messing with it for days.

Code: [Select]
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post" />
<label for="search_by">Search By</label>
<select name="search_by">
    <option value"player">Player</option>
    <option value"city">City</option>
    <option value"alliance">Alliance</option>
    <option value"browse">Browse</option>
    </select>
    <input type="text" name"search">
    <input type="submit" value="search" name="search">
 <?php
  $search_by = $_POST['search_by'];
$search = $_POST['search'];

  echo "<table><tr><td>Player</td><td>city</td><td>alliance</td><td>x</td><td>y</td><td>other</td><td>porters</td><td>conscripts</td><td>Spies</td><td>HBD</td><td>Minos</td><td>LBM</td><td>SSD</td><td>BD</td><td>AT</td><td>Giants</td><td>Mirrors</td><td>Fangs</td><td>ogres</td><td>banshee</td></tr>" ; 

$dbc = mysqli_connect('xx', 'xx', 'xx', 'xx') or die ('Error connecting to MySQL server');

$sql = "SELECT * FROM players WHERE ('$search_by') LIKE ('$search') ";
//problem is here^^?? 
$result = mysqli_query($dbc,$sql)
  or die("Error: " .mysqli_error($dbc));
Not sure, any help would be greatly appreciated.

Having update statement trouble... The error I'm getting is...

"Could not query the database - : "

Not sure what I'm missing, I had this working before also, but now it's not.


Here is my code for the update page...



Code: [Select]
<html>
<head>
<title>Update User</title>
</head>
<body>

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

<?php
$dbc = mysqli_connect('localhost', 'se266_user', 'pwd', 'se266') 
or die(mysql_error());
//delete users
echo '<b>Delete or Update User</b>.<br />';
if (isset($_POST['remove']))
{          
foreach($_POST['delete'] as $delete_id)
{             
$query = "DELETE FROM users WHERE course_id = $delete_id";             
mysqli_query($dbc, $query) or die ('can\'t delete user');          
}        
echo 'user has been deleted.<br />';   
}

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

$course_id  = $_POST['course_id'];
$course_name = $_POST['course_name'];
$student_id = $_POST['student_id'];

 

$query = "UPDATE users SET course_name ='". $course_name ."' WHERE course_id = $course_id";             
$updres = mysqli_query($query);
if(!$updres)
{   die(" Could not query the database - : <br/>". mysqli_error() ); }
else
{ echo 'course has been updated.<br />';   } 

}


//display users info with checkbox to delete  
$query = "SELECT * FROM users";  
$result = mysqli_query($dbc, $query);  
while($row = mysqli_fetch_array($result))
{      
echo '<input type="checkbox" value="' .$row['course_id'] . '" name="delete[]" />'; 
echo ' ' .$row['course_name'] .' '. $row['student_id'];
echo '<br />';  
}
mysqli_close($dbc);

?>

<form method="POST" action="update_user2.php">
<label for="course_id">Course ID:</label>
<input type="text" id="course_id" name="course_id" />
<br />
<label for="course_name">Course Name:</label>

<input type="text" id="course_name" name="course_name" />
<br />
<label for="course_name">Student ID:</label>

<input type="text" id="student_id" name="student_id" />
<br />
<input type="submit" name="remove" value="Remove" />
<input type="submit" name="update" value="Update" />
<br><br>
</form>



</body>
</html>

I have the following code which seems to be in error in the conditional statement.
The queries to the database produce the expected results, and the echo statements work OK.
I want to make a selection based on whether data exists in the database for passState when passState=1.

Can anyone tell me what is wrong with the conditional statement?

Code: [Select]
<?php
$query1 = mysql_query("SELECT DISTINCT quizTitle, userId, passState, userScore, totalScore, DATE_FORMAT(userDate,'%b %e, %Y') AS userDate FROM quiz WHERE managerId = '$managerId' AND userId = '$userId' AND passState = 1 ORDER BY quizTitle ASC, passState DESC, userDate DESC ");

$query2 = mysql_query("SELECT DISTINCT quizTitle, userId, passState, userScore, totalScore, DATE_FORMAT(userDate,'%b %e, %Y') AS userDate FROM quiz WHERE managerId = '$managerId' AND userId = '$userId' AND passState = 0 ORDER BY quizTitle ASC, passState DESC, userDate DESC "); 
 ?>
                <table width="778" style="font-size:16px">
                  <tr>
 <?php
if ($query1) {
while ($row1 = mysql_fetch_array($query1))
{
           echo'<td width="13"></td>
                    <td width="137" style="vertical-align:middle; text-align:left;">' ?> <?php echo "{$row1['quizTitle']} <br />\n"; ?> <?php echo '</td>
                    <td width="13"></td>
                    <td width="132" style="vertical-align:middle; text-align:left;;">' ?> <?php echo "{$row1['userDate']} <br />\n"; ?> <?php echo '</td>
                    <td width="22"></td>
                    <td width="112" style="text-align:center; text-align:center;">' ?> <?php if ("{$row1['passState']}" == 1) {echo "<img src=' ../wood/wood_tool_images/tick2.png' /><br />\n";}?> <?php echo '</td>
                    <td width="30"></td>
                    <td width="103" style="text-align:center; text-align:center;">' ?> <?php if ("{$row1['passState']}" == 0) {echo "<img src=' ../wood/wood_tool_images/cross2.png' /><br />\n";} ?> <?php echo '</td>
                    <td width="19"></td>
                    <td width="126" style="vertical-align:middle; text-align:center;">' ?> <?php echo "{$row1['userScore']}".'/'."{$row1['totalScore']} <br />\n"; ?> <?php 
  echo '</td>
                    <td width="23"></td>
                    </tr>';                  
}
}else{
while ($row2 = mysql_fetch_array($query2))
{

              echo '<td width="13"></td>
                    <td width="137" style="vertical-align:middle; text-align:left;">' ?> <?php echo "{$row2['quizTitle']} <br />\n"; ?> <?php echo '</td>
                    <td width="13"></td>
                    <td width="132" style="vertical-align:middle; text-align:left;;">' ?> <?php echo "{$row2['userDate']} <br />\n"; ?> <?php echo '</td>
                    <td width="22"></td>
                    <td width="112" style="text-align:center; text-align:center;">' ?> <?php if ("{$row2['passState']}" == 1) {echo "<img src=' ../wood/wood_tool_images/tick2.png' /><br />\n";}?> <?php echo '</td>
                    <td width="30"></td>
                    <td width="103" style="text-align:center; text-align:center;">' ?> <?php if ("{$row2['passState']}" == 0) {echo "<img src=' ../wood/wood_tool_images/cross2.png' /><br />\n";} ?> <?php echo '</td>
                    <td width="19"></td>
                    <td width="126" style="vertical-align:middle; text-align:center;">' ?> <?php echo "{$row2['userScore']}".'/'."{$row2['totalScore']} <br />\n"; ?> <?php 
  echo '</td>
                    <td width="23"></td>
                    </tr>';
                  
}
}
 ?>
                </table>

Can't figure out why my form is not deleting a user from database anymore. It was working a hour ago. Now it's not working, and I have no idea why. I've tried everything. Am I missing something?


Here is the delete page...



Code: [Select]
<html>
<head>
<title>Update User</title>
</head>
<body>

<?php
$dbc = mysqli_connect('localhost', 'se266_user', 'pwd', 'se266') 
or die(mysql_error());
//delete users
echo '<b>Delete or Update User</b>.<br />';
if (isset($_POST['remove']))
{          
foreach($_POST['delete'] as $delete_id)
{             
$query = "DELETE FROM users WHERE course_id = $delete_id";             
mysqli_query($dbc, $query) or die ('can\'t delete user');          
}        
echo 'user has been deleted.<br />';   
}

if (isset($_POST['update']))
{          
foreach($_POST['update'] as $update_id)
{             
$course_id  = $_POST['course_id'];
$course_name = $_POST['course_name'];
$student_id = $_POST['student_id'];

$query = "UPDATE `users` SET `course_name` = '$course_name' WHERE `course_id` = '$course_id' AND 'student_id' = '$student_id'";        
mysqli_query($dbc, $query) or die ('can\'t update course');     

$update_count = $db->exec($query);

}
echo 'course has been updated.<br />';   
}


//display users info with checkbox to delete  
$query = "SELECT * FROM users";  
$result = mysqli_query($dbc, $query);  
while($row = mysqli_fetch_array($result))
{      
echo '<input type="checkbox" value="' .$row['course_id'] . '" name="delete[]" />'; 
echo ' ' .$row['course_name'] .' '. $row['student_id'];
echo '<br />';  
}
mysqli_close($dbc);

?>

<form method="POST" action="update_user2.php">
<label for="course_id">Course ID:</label>
<input type="text" id="course_id" name="course_id" /><br />
<label for="course_name">Course Name:</label>
<input type="text" id="course_name" name="course_name" /><br />

<label for="course_name">Student ID:</label>

<input type="text" id="student_id" name="student_id" /><br />



</form>
<form method="post" action="update_user2.php">
<input type="submit" name="remove" value="Remove" />
<input type="submit" name="update" value="Update" />
<br>
<br>
</body>
</html>

I have this simple form that registers schools. This year I have decide to upgrade and include a feature that checks if the school is already registered or not based on the imputed name. Here is the code (that is the only way I know how):


mysql_connect("", "", "") or die(mysql_error( '' ));
mysql_select_db("") or die(mysql_error( '' ));

$query  = "SELECT * FROM School_Registrations WHERE School_Name= '$_POST[SchoolName]' ";
$result = mysql_query($query);
if (mysql_numrows($result) > 0) {
while($row = mysql_fetch_array($result))

echo" error code here";} 

else {mysql_query("INSERT INTO `database`.`School_Registrations` (all the variables here);") 
or die(mysql_error( '' ));  
 
echo "Success Code";}



I am trying to incorporate this code somewhere into the 'else' statement but I have no luck. I am constantly getting some errors and when I fix one there is one more to take its place. I am lost. The last one I can not fix and I am not sure what it wants from me:

Fatal error: Call to undefined function getPage()

It works by itself without the if/else statement but not in the code listed above


$url = 'http://www.otherpage.com/page.php?';
$url .= 'email='.urlencode($_POST['email']);
 
$result2 = getPage('', $url, '', 15);
 
function getPage($proxy, $url, $header, $timeout) {
    $ch = curl_init();
    curl_setopt($ch, CURLOPT_URL, $url);
    curl_setopt($ch, CURLOPT_HEADER, $header);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
    curl_setopt($ch, CURLOPT_PROXY, $proxy);
    curl_setopt($ch, CURLOPT_HTTPPROXYTUNNEL, 1);
    curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, $timeout);
    curl_setopt($ch, CURLOPT_REFERER, 'http://azsef.org');
    curl_setopt($ch, CURLOPT_USERAGENT, 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.8) Gecko/2009032609 Firefox/3.0.8');
    $result2['EXE'] = curl_exec($ch);
    $result2['INF'] = curl_getinfo($ch);
    $result2['ERR'] = curl_error($ch);
    curl_close($ch);
    return $result2;
}



Can you tell me why doesn't it work?
Thanks

I am trying to create a query to insert data into a table in my Access database.  I have the following query:

INSERT INTO Issues (DateRequested, CustomerID, ComputerID, Issue, ItemsIncl, ImageName) VALUES (#1/14/2015#, 1, 1, "Computer freezes while I'm on the internet.", "AC Adapter", "none.gif")

which should be performed from within my PHP page.  However, when I check the database afterward, the new record isn't there.  I then tried performing the query directly in Access and it worked fine.  Why would it work in Access, but not when I run the same query in PHP?     Chris

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

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.