PHP - Multiple Queries Issue When Included In Another File.

I'm working on a Stats page that will need to run multiple queries to access the information needed to dislpay on the page. Rather than running 30+ queries to get the user's Stats, is there a better method?
Any tips that you suggest I further research?

Thanks

Hi all,

I would like to perform two queries in a mysqli statement before closing the connection. I'm using prepared statements and I've read on the php.net you can perform a multi-query using mysqli->multi_query.
My problem is that I'm only finding useful examples on how to select and fetch results not using prepared statements. I'm a bit lost with how to do this to update two tables. Currently i'm using two seperate connections to do the queries but want to combine these together:

Query one (updates their password and resets number of logins to force password change on next login):

Code: [Select]
                //reset logins to force the user to change password upon next login
$loggedin = '0';

// connect to db for mysqli
require('../db/db.php');

// updates password and number of logins
$insert_stmt = $mysqli->stmt_init();
if ($insert_stmt->prepare("UPDATE users SET their_password=?, loggedin=? WHERE their_username=?")) {
$insert_stmt->bind_param('sss', $their_password, $time, $user_email);
$insert_stmt->execute();
$insert_stmt->close();
}
// if query errors sends an email
if ($mysqli->error) {
try {   
throw new Exception("MySQL error $mysqli->error <br> Query:<br> $query", $mysqli->errno);   
} catch(Exception $e ) {
$mess = "Error No: ".$e->getCode(). " - ". $e->getMessage() . "<br >";
$mess .= nl2br($e->getTraceAsString());
$contact_email = "webmaster@website.com";
$message_sub = "Mysqli Forgotten Password Query Error [UPASSWORD01]";
$hdrs = "From: " . $contact_email . "\r\n";
$hdrs .= "Reply-To: ". $contact_email . "\r\n";
$hdrs .= "MIME-Version: 1.0\r\n";
$hdrs .= "Content-Type: text/html; charset=UTF-8\r\n";
mail($contact_email, $message_sub, $mess, $hdrs);
}
header("refresh: 10; forgotpass.php");
die('ERROR: Unable to reset password. Please check you details and try again or report this error to us using our contact us form.<br><br>We will redirect you back to the forgotten password form in 10 seconds.');
exit();
}
$mysqli->close();

Query two (updates a reset log - to keep track on our user password resets):

Code: [Select]
// change status
$resetstatus = "Successful Reset";

// connect to db for mysqli
require('../db/db.php');

// inserts a new record
$null = NULL;
$insert_stmt = $mysqli->stmt_init();
if ($insert_stmt->prepare("INSERT INTO passwordresets VALUES (?, ?, ?, ?, ?)")) {
$insert_stmt->bind_param('issss', $null, $user_email, $time, $userip, $resetstatus);
$insert_stmt->execute();
$insert_stmt->close();
}

// if query errors sends an email
if ($mysqli->error) {
try {   
throw new Exception("MySQL error $mysqli->error <br> Query:<br> $query", $mysqli->errno);   
} catch(Exception $e ) {
$mess = "Error No: ".$e->getCode(). " - ". $e->getMessage() . "<br >";
$mess .= nl2br($e->getTraceAsString());
$contact_email = "webmaster@website.com";
$message_sub = "Mysqli Forgotten Password Query Error [UARESETLOG01]";
$hdrs = "From: " . $contact_email . "\r\n";
$hdrs .= "Reply-To: ". $contact_email . "\r\n";
$hdrs .= "MIME-Version: 1.0\r\n";
$hdrs .= "Content-Type: text/html; charset=UTF-8\r\n";
mail($contact_email, $message_sub, $mess, $hdrs);
}
header("refresh: 10; forgotpass.php");
die('ERROR: Unable to reset password. Please check you details and try again or report this error to us using our contact us form.<br><br>We will redirect you back to the forgotten password form in 10 seconds.');
exit();
}
$mysqli->close();

Any ideas would be greatly appreciated. Thank you

how to get the name of the file including a file from the included file,

This one has me mixed up a bit.. I am trying to record site activity information from a common.php file using a user object. But since the file is included into different php files based on different situations I need a dynamic way of finding the file name that is including it. I could be over complicating things but right now this seems like the best solution other wise I'll have to rewrite the code on every page i write. Is there a function for doing this? Or if someone gets what I'm trying to do if they could point me to the direction of some more information on it.

Thanks.

I understand that this is a header error but i still do not know how to fix it.
I am trying to create a login box that is in the top right corner of my site. Once the user uses it to log in they need to be redirected to the account page. i include the login_box.php file in the appropriate div. however the file uses header("Location: account.php"); to redirect the user. because this file is included after the header i receive Warning: Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\index.php:17) in C:\xampp\htdocs\layout_inc\login_box.php on line 76
What would be the correct way to do this. My code is bellow. Thank you in advance
<?php 
//Forms posted

if(!empty($_POST))
{
$errors = array();
$username = trim($_POST["username"]);
$password = trim($_POST["password"]);
$remember_choice = trim($_POST["remember_me"]);

//Perform some validation
//Feel free to edit / change as required
if($username == "")
{
$errors[] = lang("ACCOUNT_SPECIFY_USERNAME");
}
if($password == "")
{
$errors[] = lang("ACCOUNT_SPECIFY_PASSWORD");
}

//End data validation
if(count($errors) == 0)
{
//A security note here, never tell the user which credential was incorrect
if(!usernameExists($username))
{
$errors[] = lang("ACCOUNT_USER_OR_PASS_INVALID");
}
else
{
$userdetails = fetchUserDetails($username);

//See if the user's account is activation
if($userdetails["Active"]==0)
{
$errors[] = lang("ACCOUNT_INACTIVE");
}
else
{
//Hash the password and use the salt from the database to compare the password.
$entered_pass = generateHash($password,$userdetails["Password"]);

if($entered_pass != $userdetails["Password"])
{
//Again, we know the password is at fault here, but lets not give away the combination incase of someone bruteforcing
$errors[] = lang("ACCOUNT_USER_OR_PASS_INVALID");

}
else
{
//Passwords match! we're good to go'

//Construct a new logged in user object
//Transfer some db data to the session object
$loggedInUser = new loggedInUser();
$loggedInUser->email = $userdetails["Email"];
$loggedInUser->user_id = $userdetails["User_ID"];
$loggedInUser->hash_pw = $userdetails["Password"];
$loggedInUser->display_username = $userdetails["Username"];
$loggedInUser->clean_username = $userdetails["Username_Clean"];
$loggedInUser->remember_me = $remember_choice;
$loggedInUser->remember_me_sessid = generateHash(uniqid(rand(), true));
//Update last sign in
$loggedInUser->updateLastSignIn();

if($loggedInUser->remember_me == 0)
$_SESSION["userCakeUser"] = $loggedInUser;
else if($loggedInUser->remember_me == 1) {
$db->sql_query("INSERT INTO ".$db_table_prefix."Sessions VALUES('".time()."', '".serialize($loggedInUser)."', '".$loggedInUser->remember_me_sessid."')");
setcookie("userCakeUser", $loggedInUser->remember_me_sessid, time()+parseLength($remember_me_length));
}

//Redirect to user account page

header("Location: account.php");
die();
}
}
}
}
}

if(!isUserLoggedIn()) {?><form name="newUser" action="<?php echo $_SERVER['PHP_SELF'] ?>" method="post">
                <table>
<tr>
<td>
<label>Username:</label>
</td>
<td>
<input type="text" name="username" />
</td>
</tr>
<tr>
<td>
<label>Password:</label>
</td>
<td>
<input type="password" name="password" />
</td>
</tr>
<tr>
<td>
<label>&nbsp;</label>
<input type="submit" value="Login" class="submit"/>
</td>
<td>
<input type="checkbox" name="remember_me" value="1" /> <label style="font-size:12px">Remember Me?</label>
</td>
</tr>
</table>
<div style="text-align:center;">
<a href="register.php" class="info">Register</a> | <a href="forgot-password.php" class="info">Forgot Password?</a>
</div>
</form><?php }
else{?><h1>Welcome <?php echo $loggedInUser->display_username; ?> </h1>
 <br/>

<a href="account.php" class="info">Dashboard</a> | <a href="logout.php" class="info">Logout</a><?php }

?>

Hello:

I have this code in an included file:
myNav.php
Code: [Select]
function spLeftMenu() {
$spLeftMenu =
"
<p>
<div id=\"myLeftNavPaper\">
<img src=\"images/sidePaperTop.png\" alt=\"\" />

<div id=\"myLeftNavPaper2\">

echo \". $mySideBarPageData .\"

</div>

<img src=\"images/sidePaperBottom.png\" alt=\"\" />
</div>

</p>

";
return $spLeftMenu;
}

I can not get:
Code: [Select]
echo \". $mySideBarPageData .\"

To display the results on this page:
Page.php
Code: [Select]
<html>
...

<?php echo spLeftMenu(); ?>

...
</html>


What am I missing ??

Say I have...

Code: [Select]
<?
echo("do something");
include("include_file.php");
echo("do something else");
?>

include_file.php
Code: [Select]
<?
$a_$string = "a string";
echo($a_string);
?>

I have put an error in the include_file.php  an extra $ in the variable name.

The first script would kick up an error that there is a problem with file   include_file.php  as line 3 or what ever the line may be.

How can I have it so I can choose what the error message is, say a cryptic code and the line number without having the file names show as this is showing up my hidden includes folder and the file name which means that someone may try to visit this page alone and this can cause security issues.

Adding in extra lines to every file to see if it is being use correctly a bit like sessions is not an option although I have looked at it as I have houndreds of files to alter in this case.


I have just tried this instead of the top script but I does not show the secret code on error
Code: [Select]
<?
echo("top");
@include("dummy.php") or die("secreterrorcode123");
echo("bottom");
?>

Hi,
My issue here is that I cant get my if/else statement to work on my secondary page. I include my secondary page (fine.php) from my index page. However, I have an if/else statement in fine.php that keeps reverting back to the index.php and, therefore, outputs the else statement (404.php)

here is the if/else on index.php (these links work fine):

<?php
if($_SERVER['QUERY_STRING']=='/index.php' || $_SERVER['QUERY_STRING']=='')
{
include 'port.php';
}

elseif (isset($_GET['pos'])){
include 'pos.php';
}

elseif (isset($_GET['web'])){
include 'web.php';
}

elseif (isset($_GET['fine'])){
include 'fine.php';
}

        else {include '404.php';}






here is the if/else on my secondary page (fine.php). These links are supposed to alert the if/else in the next table cell. However, they instead alert the if/else in index.php.


<td><br/>
<a href="?backset"><img src="fine/thumbs/x-backset.jpg" border="0"></a><br/><br/> 
<a href="?backside"><img src="fine/thumbs/x-backside.jpg" border="0"></a><br/><br/> 
<a href="?bannerprint"><img src="fine/thumbs/x-bannerprint.jpg" border="0"></a><br/><br/> 
<a href="?chopu"><img src="fine/thumbs/x-chopu.jpg" border="0"></a><br/><br/> 
</td>
<td><br/>
<div id="DivPiece" align="left">
<?PHP 

if (isset($_GET['backset'])){
       include 'fine/backset.php';
}

elseif (isset($_GET['backside'])){
     include 'fine/backside.php';
}

elseif (isset($_GET['bannerprint'])){
     include 'fine/bannerprint.php';
}

elseif (isset($_GET['chopu'])){
include 'fine/chopu.php';
}

?>
</div>
</td>



How can I get the links on the secondary page to only alert the if/else statement on that page, and BLOCK the if/else statement on index.php from seeing them? I still want to use the query string though.

Thanks!

This topic has been moved to MySQL Help.

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

Hello I have a question. I'm trying to perform multiple queries based off the results from a query.  Is this possible ?

$result = mysql_query("SELECT id FROM sometable");

for each id returned

$result1 = mysql_query("SELECT * FROM someothertable WHERE id=result from $result query");

Any help would be GREAT

Hello,
In m script, I need to get the content of another php file as a string, including the content of all the files which are included in it and in lower levels.
Any idea how to do it?
I tried output buffer+include but it doesn't get the content of the included files.

Thanks

Hello. Trying to learn MVC better by creating my own little framework to understand how it works.

Things were going OK til now.

I have a base class:

<?php

/**
 * Base class most classes will extend from.
 * Simply put, this class just has methods that
 * most, if not all, classes will need.
 */

class Application {

public function includer($path) {

if (is_readable($path) == true) {
include_once($path);
} else {
die("404 not found =[");
}
}




}
?>


So the above method 'includer' just sees if a file exists/is readable and if so, include it.

Here's where I am using said method.


class Index extends Application {

function __construct($method = 'view') {
// load the index model
include(ROOT . '/app/models/model.index.php');

// Invoke requested method.
$this->$method();
}

public function view() {

$name = 'Smith';
$this->includer(ROOT . '/app/views/view.index.php'); # Problem here, i think
}


}


view.index.php just contains
<?php echo $name; ?>


All that is called from the index page, with this line of code
Application::includer($controller_path);


Now, in line
$this->includer(ROOT . '/app/views/view.index.php'); # Problem here, i think

If i get rid of $this->includer, the script will work and say 'Smith'.

If i have $this->includer(...) or parent::includer(...), it doesn't work.

why?

I have a snippet of code like this below.  If I have it directly on my page, it works fine.  But if I move this snippet of code into an include file and use "require_once('thefile.php');", the code no longer works properly.  How is that possible? FYI, this snippet is in the middle of a for loop on the regular page.  Maybe you can't use includes when in a loop? I don't know.  Makes no sense that it works when on the page, but not when included using require once.

Any thoughts how this could be possible?  I imagine there is some rule with include files that I'm missing???

This is the code and I don't think it matters exactly what its doing so I won't bother you with that.  This is how it looks on the page itself...

Code: [Select]
    if ($type=="one") {
$_SESSION['cluenum']=1; //so clue #1 begins as the selected clue
echo "<script type='text/javascript'>document.getElementById('clue1').style.border = '1px solid red';</script>";  //sets the styling on clue #1
$allcode = "onclick='setnumber($i);'";
} else {
// type must be equal to all, so don't do anything special
$allcode="";
}




This is how it looks in the include file... Code: [Select]
<?php
    if ($type=="one") {
$_SESSION['cluenum']=1; //so clue #1 begins as the selected clue
echo "<script type='text/javascript'>document.getElementById('clue1').style.border = '1px solid red';</script>";  //sets the styling on clue #1
$allcode = "onclick='setnumber($i);'";
} else {
// type must be equal to all, so don't do anything special
$allcode="";
}

?>

I'm using paypal PDT, so when the user has made payment he gets directed back to my site, on that page it executes a special sql query. I noticed I can refresh the page to make duplicate sql queries. How can I avoid this??

So, I feel like I am running up against some beginner's problem. So I am hoping this should be an easy fix. I have had a bit of trouble finding the right search terms to find a fix for this, so I am sorry ahead of time if there is already a post on this, please point me towards it.

I am running PHP 4.4.9 and MySQL client API 4.1.22, in case that is of use.

I can get the following to work and provide the appropriate output. Note in this first case that the connection info is in the same file as the call to it.


<?php
// set database access information
define ('DB_USER', "*****");
define ('DB_PASSWORD', "*****");
define ('DB_HOST', "localhost");
define ('DB_NAME', "content");

// database connection protocol
$dbc = mysql_connect (DB_HOST, DB_USER, DB_PASSWORD) or die ('Could not connect to MySQL: Error #' . mysql_errno() . ' - ' . mysql_error());

mysql_select_db (DB_NAME) or die ('Could not connect to MySQL: Error #' . mysql_errno() . ' - ' . mysql_error());


$query = "SELECT content_element_title FROM content_main";

$result = mysql_query ($query);

while ($row = mysql_fetch_array ($result, MYSQL_ASSOC))

{

echo ("<p>" . $row[content_element_title] . "</p>");

}
unset($dbc);


?>


My problem is, however, that when I separate the connection info into a separate file, I have been having problems. I think I got past the method calling the connection info not being able to see it, but now it isn't returning anything - should be returning

"<p>" . $row[content_element_title] . "</p>", 

for which there are three rows in the db.

Here is what the two files look like separated:

kinnect.php

<?php

// set database access information
define ('DB_USER', '*****');
define ('DB_PASSWORD', '*****');
define ('DB_HOST', 'localhost');
define ('DB_NAME', 'content');

//// database connection protocol
$dbc = mysql_connect (DB_HOST, DB_USER, DB_PASSWORD) or die ('Could not connect to MySQL: Error #' . mysql_errno() . ' - ' . mysql_error());

mysql_select_db (DB_NAME, $dbc) or die ('Could not connect to MySQL: Error #' . mysql_errno() . ' - ' . mysql_error());

?>
file.php



<?php

require_once ("correctpathto/kinnect.php");

$query = "SELECT content_element_title FROM content_main";

$result = mysql_query ($query, $dbc);

while ($row = mysql_fetch_array ($result, MYSQL_ASSOC))

{

echo ("<p>" . $row[content_element_title] . "</p>");

}
unset($dbc);
?>


So what am I doing wrong? I am getting these error messages now.

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /Users/max/Sites/rdbase-llc/preliminary/connecttroubleshoot.php on line 18

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /Users/max/Sites/rdbase-llc/preliminary/connecttroubleshoot.php on line 20

Thanks ahead of time for any help!

In querying my database, I'm Selecting nameFirst and nameLast, and it produces a name like Joe Smith.  I'm trying to match a photo with the name.  Right now I'm uploading photos into a folder naming the file (e.g. SmithJoe.jpg). 

For reasons that involve writers being able to upload and access photos, I'm trying to use an image plugin.  When uploading photos, it strips capital letters, so SmithJoe,jpg goes in as smithjoe.jpg, and it's not matching my database query. 

Here is the code I'm working with that works quite well with this one exception:


$query = 'SELECT * FROM wp_playerRank';
$results = mysql_query($query);
while($line = mysql_fetch_assoc($results)) {

if ($line['wpID'] == $wp_tagID)  {

echo '<div class="player">';


// Here is the code that produces the image.  I need to get rid of capital letters for ease of use

echo '<div><img src="/wp-content/uploads/' . $line['nameLast'] . $line['nameFirst'] . '.jpg"></div>';



echo '<div class="playerData">' . $line['height'] . ' ';
if ($line['position'] == 'PG')  {echo 'Point Guard';}
elseif ($line['position'] == 'SG')  {echo 'Shooting Guard';}
elseif ($line['position'] == 'SF')  {echo 'Small Forward';}
elseif ($line['position'] == 'PF')  {echo 'Power Forward';}
elseif ($line['position'] == 'C')  {echo 'Center';}
echo '</div>';
echo '<div class="playerData">' . $line['hschool'] . '</div>';
echo '<div class="playerData">' . $line['summer'] . '</div>';
echo '<div class="playerData">Class of ' .$line['year'] . '</div>';

if ($line['committed'] == 'y') {
echo '<div>
<br>Committed to <strong>'. $line['college'] . '</strong></div>
';}

}
}