PHP - Can't Use Method Return Value In Write Context

I am trying to do the following. Except I know that 'return' is not the right method to use, as it stops the script, so what ends up happening is only one row is returned, instead of the three that are there. With return, the data is being passed without being immediately printed, and I end up with the data (but not all of it, because the script stops) in correct place in the page.

If I replace return () with echo(), it works fine, in terms of returning the correct data.

However, with the way things are setup, if I use echo, the results print at the head of my page. I am using function CreateSideMenu to establish the values for content, and then another function, later on the index.php page, actually creates the page. So what I need is to have something, similar to return (), that passes the information on, but does not immediately print it.

Do I make sense?

see code below:


function CreateSideMenu ()

{ // open CreateSideMenu function

include ('/Users/max/Sites/rdbase-llc/hidden/defin/kinnect01.php');

$query = "SELECT content_element_title, content_element_short_text FROM content_main";

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

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

{

return ("<p>" . $row[content_element_title] . "</h2>\n<p>" . $row[content_element_short_text] .  "</p>");

}


Thanks ahead of time.

I've done pretty much everything I can come up with.
The method itself works fine, if I print_r(); just before returning it, it successfully returns the array.
But once returned, it's empty.
Heres my code:

Code: [Select]
<?php
include_once $_SERVER['DOCUMENT_ROOT'] . "/includes/class_database.php";
include_once $_SERVER['DOCUMENT_ROOT'] . "/includes/values.php";

?>



<?php

class User {

    private $database;

    public    function __construct(MySqlDatabase $database) { //Type Hinting
    $this->database = $database;
}
    
    public function hash_password($password) {
        $result = hash(sha512, $password . SUOLA);
        return $result;
}
    
    public function find_all() {
    $result = $this->database->db_query("SELECT * FROM users");
    $final = mysqli_fetch_array($result);
    return $final;    
}
    
    public function find_by_id($id=1) {
    $result = $this->database->db_query("SELECT * FROM users WHERE id={$id}");
    $final = mysqli_fetch_array($result);
    return $final;    
}
    
    public function check_required($array) { // this method gets called first
    if (empty($array['username']) || empty($array['first_name']) 
        || empty($array['last_name']) || empty($array['password'])
        || empty($array['email']) || empty($array['secret_question']) 
        || empty($array['password2']) || empty($array['secret_answer']) 
        || !($array['email'] === $array['email2'])
        || !($array['password'] === $array['password2'])) {
        die("Fill required fields!" . "<br />" 
            . "<a href='javascript:history.go(-1)'>Go back</a>");
        
        } else {
            $this->database->array_query_prep($array); // it then continues to the next method automatically
        }
    
    }
    
    public function create_user($array) {
    $date = date('d-m-Y H:i:s');
    
    $sql = "INSERT INTO users (username, first_name, ";
    $sql .= "last_name, password, email, secret_question, ";
    $sql .= "secret_answer, create_time) VALUES ";
    $sql .= "('{$array['username']}', '{$array['first_name']}', '{$array['last_name']}', ";
    $sql .= "'{$array['password']}', '{$array['email']}', '{$array['secret_question']}', '{$array['secret_answer']}', ";
    $sql .= "'{$date}');";
    
    $this->database->db_query($sql);
    }
}
?> Code: [Select]
<?php
include_once $_SERVER['DOCUMENT_ROOT'] . "/includes/values.php";
include_once $_SERVER['DOCUMENT_ROOT'] . "/includes/class_user.php";
?>

<?php
class MySqlDatabase extends MySQLi {
    
    function __construct() {
        //Check if constants are missing
        if (!defined("DB_USERNAME") || !defined("DB_SERVER") || 
            !defined("DB_PASSWORD") || !defined("DB_NAME")) {
            die("One or more of the database constants are missing!");
            }
            
        //Establish connection if constants are present using the parent class
        parent::__construct(DB_SERVER, DB_USERNAME, DB_PASSWORD, DB_NAME);
        
        //Echo error message if connection has failed
        if ($this->connect_errno) {
            die("Database connection has failed: " . $this->connect_errno);
            }    
    }

    public function db_query($sql) {
    $result = $this->query($sql);
        if (!$result) {
            die("Database query failed: " . $this->errno);
        }
}

    public function array_query_prep($array) { // continues to this method
    $result = array_map(array($this, 'real_escape_string'), $array);
        if (!$result) {
            die("Preparing query failed: " . $this->errno);
        }
// if i print_r here, it returns the array as it should
    return $result;
} 
}
?> Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<link rel="stylesheet" type="text/css" href="../stylesheets/main.css"/>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body class="main_body">
<div id="container">
<div id="header">
    <div id="top">
      <div id="login">
        <form action="" method="post" target="/login/">
          <label for="username">Username:</label><br />
          <input name="username" type="text" class="text" maxlength="20" /><br />
        <label for="password">Password:</label><br />
        <input name="password" type="password" class="text" maxlength="30" /><br />
        <input name="submit" type="submit" class="loginbtn" value="Login" /></form>
      </div>
    </div>
<div>
  <h1>Welcome to _________ website!</h1>
</div>

<?php
include_once $_SERVER['DOCUMENT_ROOT'] . "/includes/values.php";
include_once $_SERVER['DOCUMENT_ROOT'] . "/includes/functions.php";
include_once $_SERVER['DOCUMENT_ROOT'] . "/includes/class_database.php";
include_once $_SERVER['DOCUMENT_ROOT'] . "/includes/class_user.php";
?>
<?php

$database = new MySqlDatabase();
$user = new User($database);




if (isset($_POST['submit'])) {
    $result = $user->check_required($_POST); //this is where I get nothing back
    $user->create_user($result);
    die("Registration was successful!");
    } else {
    $username = "";
    $first_name = "";
    $last_name = "";
    $password = "";
    $email = "";
    $email2 = "";
    $secret_question = "";
    $secret_answer = "";
    unset($_POST);
    }


    
?>
<form action="" method="post" target="_self">
Username: <input type="text" name="username" class="text" maxlength="20" value="<?php echo htmlentities($username); ?>" /><br />
First Name: <input type="text" name="first_name" class="text" maxlength="20" value="<?php echo htmlentities($first_name); ?>" /><br />
Last Name: <input type="text" name="last_name" class="text" maxlength="20" value="<?php echo htmlentities($last_name); ?>" /><br />
Password: <input type="password" name="password" class="text" maxlength="30" value="<?php echo htmlentities($password); ?>" /><br />
Enter again: Password: <input type="password" name="password2" class="text" maxlength="30" value="<?php echo htmlentities($password2); ?>" /><br />
Email: <input type="text" name="email" class="text" maxlength="30" value="<?php echo htmlentities($email); ?>" /><br />
Enter again: Email: <input type="text" name="email2" class="text" maxlength="30" value="<?php echo htmlentities($email2); ?>" /><br />
Secret Question: <input type="text" name="secret_question" class="text" maxlength="35" value="<?php echo htmlentities($secret_question); ?>" /><br />
Secret Answer: <input type="text" name="secret_answer" class="text" maxlength="35" value="<?php echo htmlentities($secret_answer); ?>" /><br />
<input type="submit" name="submit" class="submitbtn" value="Submit" />
<?php




?>
</div>
</div>
</body>
</html>
[/quote]

Any ideas?

 

My script has 3 classes (that are relevant to this discussion): DB, User and Validate. They are all in independent files and loaded automatically, when required, by an autoloader.
Both the User class and the Validate class have a private variable $_db which is instantiated by their class constructor: $this->_db = DB::getInstance();
At the top of the script I declare new instances: $user = new User(); and $validate = new Validate();
I then call a method in $user: $found = $user->findInUsers ( .... )
From within the findInUsers method I then want to call the query method in the DB class. My problem is that I can't find a way to do this that works.
I have tried $this->_db->query( ... ), $_db->query( ... ), but neither works.

The error messages I am getting a
An error occurred in script '/srv/http/classes/User.php' on line 42: Undefined variable $_db
Uncaught Error: Call to a member function query() on null in /srv/http/classes/User.php:42

Any pointers as to what I am doing wrong, or what I should be doing, would be most welcome.

Hello.
I am now dumbfounded (once again).
I am using $this inside a class.
I honestly have no idea what is going on. If anyone could give me a pointer that would be brilliant.
Code: [Select]
/*
  * List of functions in this class in order (construct and destruct are the only functions not in alphabetical order)
  * Construct
* BooleanValue
* BuildColumns
* Connect
* Clean
* Delete
* Disconnect
* EndTransaction
* Error
* Insert
* IsConnected
* Kill
* LastInsertID
* Log
* Query
* RollbackTransaction
* RowCount
* Select
* StartTransaction
* Update
* Where
* Destruct
*/

class MySQL extends MySQLi {
private $host = HOST;
private $user = USER;
private $pass = PASS;
private $data = DATA;
private $port = PORT;
private $charset = CHARSET;

const quote = "'"; // what quote to use

/* Internal vars */
private $lastID = "";
private $lastResult = "";
private $queries = "";
private $link = 0;
private $timeStart = 0;
private $timeEnd = 0;
private $timeTotal = 0;
private $errorString = "";
private $errorNo = 0;
private $in_transaction = false;
private $queryQueue = "";


/*
* Construct
* Starts the connection unless autoconnect = false
*/
public function __construct($autoconnect = true) {
$autoconnect === true ? $this->Connect() : false;
}
/*
* End construct
***************************************************************************************************/

/*
* BooleanValue
* Determins whether the input is a boolean value, or can be converted into a boolean value
*/
static function BooleanValue($value) {
$value = self::Clean($value);
if(gettype($value) == "boolean") {
if($value == true) {
return true;
} else {
return false;
}
} elseif(is_numeric($value)) {
if($value > 0) {
return true;
} else {
return false;
}
} else {
$str = strtoupper(mysqli_real_escape_string($this->link, trim($value)));
if($str == "ON" || $str == "SELECTED" || $str == "CHECKED" || $str == "YES" || $str == "Y" || $str == "TRUE" || $str == "T") {
return true;
} else {
return false;
}
}
}
/*
* End BooleanValue
***************************************************************************************************/

/*
* BuildColumns
* Builds columns for use with SQL statements
*/
static function BuildColumns($columns, $addQuotes = true, $showAlias = true) {
if($addQuotes) {
$quote = self::quote;
} else {
$quote = "";
}
switch(gettype($columns)) {
case "array":
$sql = "";
$i = 0;
foreach($columns as $key => $value) {
$key = self::Clean($key);
$value = self::Clean($value);
if($i == 0) {
$sql = $quote.$value.$quote;
$i = 1;
} else {
$sql .= ", ".$quote.$value.$quote;
}
if($showAlias && is_string($key) && (!empty($key))) {
$sql .= " AS ".$quote.$key.$quote."'";
}
}
break;
case "string":
$columns = self::Clean($columns);
return $quote.$columns.$string;
break;
default;
return false;
break;
}

return $sql;

}
/*
* End BuildColumns
***************************************************************************************************/

/*
* Connect
* Connects to the database
*/
public function Connect() {
$this->link = @mysqli_connect($this->host, $this->user, $this->pass, $this->data, $this->port);
$this->IsConnected();
}
/*
* End Connect
***************************************************************************************************/

/*
* Clean
* Cleans input
*/
static function Clean($value) {
$this->IsConnected();
$value = ltrim($value);       
  $value = rtrim($value);
  $value = mysqli_real_escape_string($this->link, $value);
  return $value;
}
/*
* End Clean
***************************************************************************************************/

/*
* Delete
* Deletes a record from the database
*/
public function Delete($table, $whereArray) {
$sql = "DELETE FROM ".$table;
$sql .= self::Where($whereArray);
}
/*
* End Delete
***************************************************************************************************/

/*
* Disconnect
* Disconnects from the database
*/
public function Disconnect() {
if($this->IsConnected()) {
mysqli_close($this->link);
}
}
/*
* End disconnect
***************************************************************************************************/

/*
* EndTransaction
* Ends the transaction, saving all data to the database
*/
public function EndTransaction() {
$this->IsConnected();
if($this->in_transaction) {
if(!mysqli_query($this->link, "COMMIT")) {
$this->RollbackTransaction();
} else {
$this->in_transaction = false;
return true;
}
} else {
$this->Error("Not in a transaction", -1);
return false;
}
}
/*
* End EndTransaction
***************************************************************************************************/

/*
* Error
* Handles Errors
*/
public function Error($errstr = "", $errno = 0) {
try {
if(strlen($errstr) > 0) {
$this->errorString = $errstr;
} else {
$this->errorString = @mysqli_error($this->link);
if(!strlen($this->errorString) > 0) {
$this->errorString = "Unknown error";
}
}
if($errno <> 0) {
$this->errorNo = $errno;
} else {
$this->errorNo = @mysqli_errno($this->link);
}
} catch(Exception $e) {
$this->errorString = $e->getMessage();
$this->errorNo = -999;
}
$this->Kill();
}
/*
* End Error
***************************************************************************************************/

/*
* Insert
* Inserts a record into the database
*/
public function Insert($table, $valuesArray) {
$columns = self::BuildColumns(array_keys($valuesArray), false);
$values  = self::BuildColumns($valuesArray, true, false);
$sql = "INSERT INTO ".$table." (".$columns.") VALUES (".$values.")";
$this->queryQueue .= $sql;
}
/*
* End Insert
***************************************************************************************************/

/*
* IsConnected
* Checks if there is a connection
*/
public function IsConnected() {
if(@mysqli_ping($this->link)) {
return true;
} else {
$this->Error();
return false;
$this->RollbackTransaction();
$this->Kill("No connection present");
}
}
/*
* End IsConnected
***************************************************************************************************/

/*
* Kill
* Rollsback anychanges and kills the script
*/
public function Kill() {
$this->RollbackTransaction();
if(!$this->errorString) {
$this->errorString = "Unknown";
}
if(!$this->errorNo) {
$this->errorNo = -999;
}
die("<br /><br /><strong>An error has occured.<br />".$this->errorString."<br />".$this->errorNo);
}
/*
* End Kill
***************************************************************************************************/

/*
* LastInsertID
* Returns the last inserted ID
*/
public function LastInsertID() {
return $this->lastID;
}
/*
* End LastInsertID
***************************************************************************************************/

/*
* Log
* Logs all MySQL queries
*/
static function Log($page, $utime, $wtime, $mysql_time, $sphinx_time, $mysql_count_queries, $mysql_queries) {
/*$table = "mysql-".date("Ymd");
$sql = "INSERT DELAYED INTO ".$table." (ip, page, utime, wtime, mysql_time, sphinx_time, mysql_count_queries, mysql_queries, user_agent) VALUES ("self::quote.$_SERVER['REMOTE_ADDR'].self::quote.", ".self::quote.$page.self::quote.", */
}
/*
* End Log
***************************************************************************************************/

/*
* Query
* Exectues all queries
*/
public function Query($sql) {
$this->IsConnected();

$this->timeStart = microtime(true);

$this->queries = $sql;
$this->StartTransaction();
$this->lastResult = @mysqli_query($this->link, $sql);
if(!$this->lastResult) {
$this->RollbackTransaction();
$this->Error();
}
$this->EndTransaction();
if(strpos(strtolower($sql), "insert") === 0) {
$this->lastID = mysqli_insert_id($this->link);
if($this->lastID === false) {
$this->Error();
} else {
return $this->lastResult;
//$this->queryQueue = "";
}
} elseif(strpos(strtolower($sql), "select") === 0) {
$this->LastID = 0;
}

$this->timeEnd = microtime(true);
$this->timeTotal = ($this->timeEnd - $this->timeStart);
$removeE = explode('E', $this->timeTotal);
$this->timeTotal = $removeE[0];
echo $this->queryQueue;
}
/*
* End Query
***************************************************************************************************/

/*
* RollbackTransaction
* Un-does the changes made
*/
private function RollbackTransaction() {
$this->IsConnected();
if(!mysqli_query($this->link, "ROLLBACK")) {
$this->Error("Rollback failed. Manual cleanup required");
return false;
} else {
$this->in_transaction = false;
return true;
}
}
/*
* End RollbackTransaction
***************************************************************************************************/

/*
* RowCount
* Returns the amount of rows effected from the last query
*/
public function RowCount() {
return mysqli_num_rows($this->lastResult);
}
/*
* End RowCount
***************************************************************************************************/

/*
* Select
* Selects rows
* USAGE:
* $result = $sql->Select("users", array("username" => "james"));
* while($row = mysqli_fetch_array($result)) {
* echo $row['password'];
* }
*/
public function Select($table, $whereArray = null, $columns = null, $sortColumns = null, $sortAscending = true, $limit = null) {
if(!is_null($columns)) {
$sql = self::BuildColumns($columns);
} else {
$sql = "*";
}
$sql = "SELECT ".$sql." FROM ".$table;
if(is_array($whereArray)) {
$sql .= self::Where($whereArray);
}
if(!is_null($sortColumns)) {
$sql .= " ORDER BY ".self::BuildColumns($sortColumns, true, false). " ".($sortAscending ? "ASC" : "DESC");
}
if(!is_null($limit)) {
$sql .= " LIMIT ".$limit;
}
self::Query($sql);
$return = "";
return $this->lastResult;
}
/*
* End Select
***************************************************************************************************/

/*
* StartTransaction
* Starts the transaction
*/
private function StartTransaction() {
if(!$this->IsConnected()) {
die();
}
if(!$this->in_transaction) {
if(!mysqli_query($this->link, "START TRANSACTION")) {
$this->Error();
return false;
} else {
$this->in_transaction = true;
return true;
}
} else {
$this->Error("Already in a transaction");
}
}
/*
* End StartTransaction
***************************************************************************************************/

/*
* Update
* Updates the rows
*/
public function Update($table, $valuesArray, $whereArray = null) {
$sql = "";
$i = 0;
foreach($valuesArray as $key => $value) {
$key = self::Clean($key);
$value = self::Clean($value);
if($i == 0) {
$sql = $key." = ".self::quote.$value.self::quote;
$i = 1;
} else {
$sql .= ", ".$key." = ".self::quote.$value.self::quote;
}
}
$sql = "UPDATE ".$table." SET ".$sql;
if(is_array($whereArray)) {
$sql .= self::Where($whereArray);
}
self::Query($sql);
return $this->lastResult;
}
/*
* End Update
***************************************************************************************************/

/*
* Where
* Select rows where X
*/
public function Where($whereArray) {
$where = "";
foreach($whereArray as $key => $value) {
$key = self::Clean($key);
$value = self::Clean($value);
if(strlen($where == 0)) {
if(is_string($key)) {
$where = " WHERE ".$key." = ".self::quote.$value.self::quote;
} else {
$where = " WHERE ".self::quote.$value.self::quote;
}
} else {
if(is_string($key)) {
$where .= " AND ".$key." = ".self::quote.$value.self::quote;
} else {
$where .= " AND ".self::quote.$value.self::quote;
}
}
}
return $where;
}
/*
* End where
***************************************************************************************************/

/*
* Destruct
* Closes the connection and cleans up
*/
public function __destruct() {
if($this->queryQueue) {
$this->Query($this->queryQueue);
}
$this->Disconnect();
}
/*
* End destruct
***************************************************************************************************/
}
The code I am using to get the error is this:
Code: [Select]
$sql = new Mysql;
$sql->Insert("users", array("username" => "James"));
$sql->Insert("users", array("username" => "fds"));
$sql->Insert("users", array("username" => "le"));

Thanks.
EDIT: Added code to call the error.

Hello!
This is my code:
$postdata = http_build_query(
    array(
        'version' => '1.0',
        'username' => 'YBthebest',
'password' => 'MYPASSWORD'
    )
);
$username = 'YBthebest';
$opts = array(
  'http'=>array(
    'method'=>"POST",
    'header'=>"User-Agent: APIClient:YBthebest\r\n"
  )
);

$context  = stream_context_create($opts);
$result = file_get_contents('https://ocrterminal.com/api/user.cgi', false, $context);

Warning: file_get_contents(https://ocrterminal.com/api/user.cgi): failed to open stream: HTTP request failed!
I get that error! What is failing?

And yes, I need to send my username through User_agent !( // User Agent
string userAgent = "APIClient:" + username;, taken from C example)

Thanks !

[Edit: Sorry I found my answer by searching for "period", then finding out that it is a string operator, then read about that. Doesn't seem easy to search for ".=" in Google. Thanks]

I got some help here earlier, and I can pretty much understand everything, except I don't understand why there is Code: [Select]
$recordOptions .= "<option value=\"{$row['id']}\">";
        $recordOptions .= " {$row['firstname']} {$row['lastname']}, {$row['gender']}, {$row['dob']}";
        $recordOptions .= "</option>\n";
Why does this whole thing break without .= ? I am new to PHP so, sorry if the answer is really obvious.

Code: [Select]
$recordOptions = '';
$query = "SELECT * FROM people";
$result = mysql_query($query);
if(!$result)
{
    $recordOptions = "<option>Error Retrieving Records</option>\n";;
}
else
{
    while($row=mysql_fetch_assoc($result))
    {
        $recordOptions .= "<option value=\"{$row['id']}\">";
        $recordOptions .= " {$row['firstname']} {$row['lastname']}, {$row['gender']}, {$row['dob']}";
        $recordOptions .= "</option>\n";
    }
}

?>
<html>
<body>

<?php echo $confirmMsg; ?><br />

<form action ='' method='post'>

I'm trying to build a Wordpress plugin where all the archives are nicely listed in a tabular form. I'm reading the book Wordpress Plugin Development - A Beginner's Guide

And I'm having an error when trying to call the function to display the archives on a separate page.


Here's the function:


function display()
{
global $wpdb;
// these variables store the current year, month and date
// processed
$curyear='';
$curmonth='';
$curday='';

// the beginning of our output
$result='
<div class="snazzy">
<table cellspacing="15" cellpadding="0" border="0">
<tbody>
<tr>';


// query to get all published posts
$query=  "SELECT * FROM $wpdb->posts WHERE post_status =
'publish' AND post_password='' ORDER BY post_date_gmt DESC ";
$posts = $wpdb->get_results($query);


foreach ($posts as $post)
{
// retrieve post information we need
$title = $post->post_title;
$excerpt= $this->get_excerpt($post->post_content);
$url=get_permalink($post->ID);
$date = strtotime($post->post_date);
// format the date
$day = date('d', $date);
$month = date('M', $date);
$year = date('Y', $date);


// look for image in the post content
$imageurl="";
preg_match('/<\s*img [^\>]*src\s*=\s*[\""\']?([^\""\'>]*)
/i' , $post->post_content, $matches);
$imageurl=$matches[1];


// get comments for this post
$comcount = $wpdb->get_var("
SELECT COUNT(*)
FROM $wpdb->comments
WHERE comment_approved = '1'
AND comment_post_ID=$post->ID
AND NOT (comment_type = 'pingback'
OR comment_type = 'trackback')");


// additional formatiing
if ($year!=$curyear)
{
// close the previous day/month
if ($curday)
$result.="</div></div></td>";
$curday='';
$curmonth='';
// year start in a new column (<td>)
$result.= '<td valign="top"><div class="sz_date_yr">'
.$year.'</div><div class="sz_cont">';
$result.= '</div></td>';
$curyear=$year;
}
if ($month!=$curmonth)
{
// close the previous day/month
if ($curday)
$result.="</div></div></td>";
$curday='';
// month starts in a new column (<td>)
$result.= '<td valign="top"><div class="sz_date_mon">'
.$month.'</div><div class="sz_month">';
$curmonth=$month;
}
if ($day!=$curday)
{
// close previous day
if ($curday)
$result.="</div>";
$result.= '<div class="sz_date_day">'.$day.'
</div><div class="sz_day">';
$curday=$day;
}


// retrieve the archive entry representation
ob_start();

include('snazzy-layout-1.php');
$output = ob_get_contents();
ob_end_clean();
$result.=$output;
}


// close the previous day/month
if ($curday)
$result.="</div></div></td>";
// close the main page elements
$result.="</tr></tbody></table></div>";
// return the result
return $result;
}



This is the part to which the error message is referring to:


// retrieve post information we need
$title = $post->post_title;

$excerpt= $this->get_excerpt($post->post_content);

$url=get_permalink($post->ID);
$date = strtotime($post->post_date);
// format the date
$day = date('d', $date);
$month = date('M', $date);
$year = date('Y', $date);


The error message says that I'm using $this when not in "object context". The part where $this is used is needed to display an excerpt of the post content. This is the same way how it's shown in the book, for some reason it doesn't work for me.

What would be an alternative way that I could do to make it work, any ideas?

I have php code that searched for results of properties from my MYSQL database, but how can i position it and style it with font and colours etc? any help will be appreciated,thanks.

I get the error code "Fatal error: Using $this when not in object context in /home/feenetwo/public_html/language/english/mails/sale_third_party_notification.php on line 7" when I complete the form from the link in the screenshot atached...

the site is feenetwork.com and im getting really fustrated with it....

Can anyone help?

First i will show the code that activates the error:

Code: [Select]
if($current_host != null) {
print_r2("1");
print_r2($current_host);
print_r2($current_foundResult);
print_r2("2");
$current_host::addFoundResult($current_foundResult);
}

this is the output:

Quote

1

Host Object
(
    [hostname] => www.google.nl
    [foundResults] => Array
        (
        )

)

FoundResult Object
(
    [url] =>
    [title] =>
    [visits] =>
)

2


Fatal error: Using $this when not in object context in ~~~~~~~~~~~~~ on line 385



the error comes from this line:
      $this->foundResults[] = $foundResult;


Code: [Select]
class Host {

public $hostname;
public $foundResults;

public function __construct($hostname) {
$this->hostname = $hostname;
$this->foundResults = array();
}

public function addFoundResult($foundResult) {
$this->foundResults[] = $foundResult;
}
}
what i don't get about it is that both the Host Object and the FoundResult Object exist...

here is what i am trying to do. i have a url in my browser like this: http://localhost/jmla/index.php?option=com_content&view=article&id=1295:sovereign-a-country-risk-workshop

as usuall we get elements form the url using the $_GET method, but here when i try to get id from the above url. i can get 1295:sovereign-a-country-risk-workshop. whereas the id is only 1295 and the other part is alias which i want to get seperately.

is there a way to do so?

Hi There,

I am trying to implement a facebook plugin into my website. When the user posts a link to my site on their wall it will redirect them back to my page with some GET info in the URL eg. www.example.com/download.php?post_id=43221. I don't need to know the Post Id number, I just need to know if they went to the facebook page. So my question is, how would I make it s that if there is a Post ID number it displays the page and if not it directs them to another page?

Please help me with this, i'm totally stumped.

Thanks

George Bates 

Hi there,

I want to allow the ability for DJ's to turn on and off radio requests.

Now obviously I've encorporated a check box and submit button within a PHP login. But I was wanting to know if this can be done with PHP or is a database required as the option will need to be remembered for a period of time.

I'd probably look to do it by making it display on a page 'requests enabled' if enabled and a blank page if disabled. therefore I could encorporate:

<?php
if(!empty($requests))
{
//requests template
}
else  
{
//radio requests disabled template
}
?>

What's the best method for this?

Thanks

Hi,

I have a problem and can't seem to figure out how to do it..

Basically i have these 2 tables:

Quote

People
Pid
Pname
Pdateadded
Pdeleted


And..

Quote

Quote:
PeopleCon
PCid
Pid
PCorder
Pdateadded
Pdeleted


Now, currently i insert the data into a table "People".. like you guys have helped me with..

But what i need to do is, first check to see if the author already exists in the People table, if so then just INSERT into PeopleCon, ELSE INSERT into both People and PeopleCon...

Also if there are 4 authors, and 2 exist in People, and 2 do not. What needs to happen is the first 2 are simply inserted into PeopleCon, but the last 2 are INSERTED into both People and PeopleCon. When the authors are inserted into PeopleCon, the PCorder row needs to increment by the number of authors byt order of author.

So this is the logic:

Multiple authors are entered in textboxes Fire the script Check to see if author already exists in "People" table IF it does exist, INSERT into PeopleCon table ELSE do the insert into the People AND PeopleCon table, first it will INSERT into the People, and GET the MAX (ID) and insert into the PeopleCon
So i currently have this, but as 3 separate methods:


class People {

    public function checkNameExists(){

       $query = "SELECT * FROM People WHERE Pname = '". mysql_real_escape_string($_POST['author'])."'";

        $result = mysql_query($query);
        if(mysql_num_rows($result) > 0):
            $row = mysql_fetch_array($result);
            return true;
        else:
            return false;
        endif;
    }

    public function insertAuthor(){
        $callback = create_function('$author','return "(\'".mysql_real_escape_string($author)."\',NOW(),0)";');
        $sql = sprintf(
            'INSERT INTO People (Pname, Pdateadded, Pdeleted) VALUES %s'
            ,implode(',',array_map($callback,$_POST['author']))
        );
        $result = mysql_query($sql);
        return "Successfully added NEW author";
    }

    public function insertAuthorCon(){

        $sql = "INSERT INTO PeopleCon
                    (Pid, PCorder, PCdateadded, PCdeleted) VALUES
                    (
                    'MAX ID WILL GO HERE',
                    'INCREMENT OF ORDER GOES HERE',
                    now(),
                    0
                    )";
        $result = mysql_query($sql);
        return "Successfully added existing author";
    } 


But obviously i need to combine these together into one method to match what i am trying to achieve..

Can anyone point me in the right direction?

Thanks again...

I know I'm posting this inside the PHP coding board but I'm curious on how most handle this situation. I have a page that uses php to retrieve data from my database and I want to have it place a | in between each of the returned data which it does but it still places one after the last returned row. I'm wondering if I should do this with jquery load and then have it place that character in between each of the data or if there's a way to do it with php or what? Any ideas?

Code: [Select]
<?php require ("../header.php"); ?>

<div id="titlehistory" class="content">
 
<h1 class="pageheading">Title History</h1>

<?php 
$titlesQuery ="
SELECT 
    titles.titleName, 
    titles.shortName
FROM
    titles
WHERE
    titles.statusID = 1 
ORDER BY      
    titles.ID";
$titlesResult = mysqli_query($dbc,$titlesQuery);

?>
     
    <p><span class="minilinks">
   
        <?php
        while ( $row = mysqli_fetch_array ( $titlesResult, MYSQLI_ASSOC ) ) {
            $fieldarray=array('titleName','shortName');     
            foreach ($fieldarray as $fieldlabel) {         
                ${$fieldlabel} = $row[$fieldlabel];     
            }
             
            echo '<a href="/titlehistory/'.$shortName.'">'.$titleName.'</a>&nbsp; |';
        }
        ?>
    </span></p>
   
    <p class="nohistory">Please select a title to view.</p>

</div>

<?php require ("../footer.php"); ?>