PHP - Undefined Method Error

I have a class called cid which contains these functions:

Code: [Select]
public function UpdateDeliveryAddress($orderNumber, $deliveryaddress) {

$sql = "UPDATE `CIDOrders`

SET `DeliveryAddress` = '" . mysql_real_escape_string($deliveryaddress) . "'

WHERE `CIDOrderNumber` = " . $orderNumber . ";";

mysql_select_db(DB_DATABASE_NAME, $this->conn);

return mysql_query($sql, $this->conn);

}





               public function UpdateInvoiceAddress($orderNumber, $invoiceAddress) {

$sql = "UPDATE `CIDOrders`

SET `InvoiceAddress` = '" . mysql_real_escape_string($invoiceaddress) . "'

WHERE `CIDOrderNumber` = " . $orderNumber . ";";

mysql_select_db(DB_DATABASE_NAME, $this->conn);

return mysql_query($sql, $this->conn);

}



It is called in a page called create order.

Code: [Select]


/ Add a new delivery address to the order

        $cid->UpdateDeliveryAddress($_POST['orderNumber'], $_POST['deliveryaddress']);

 

               // Add invoice address to the order

       $cid->UpdateInvoiceAddress($_POST['orderNumber'], $_POST['invoiceaddress']);



I get a call to undefined method error. Can anyone help me.

thank you


 

So i read the docs on this and it said to create a callback function and use ini_set to set the function. I am trying to serialize an array with the class inside the array

Code: [Select]
$dd_normal_button = array (
        'dd_normal_button_display' =>
        array (
                'dd_button_digg' =>
                __PHP_Incomplete_Class::__set_state(array(
                '__PHP_Incomplete_Class_Name' => 'DD_Digg',
                'buttonLayout' =>
                array (
                        'Wide' => 'DiggWide',
                        'Normal' => 'DiggMedium',
                        'Compact' => 'DiggCompact',
                        'Icon' => 'DiggIcon',
                ),
               )
              )
             )
            );

So then I try

Code: [Select]
serialize($dd_normal_button);
and I get the error.

Any ideas/suggestions.

Thanks

HI guys,
 i am using 'Spreadsheet excel writer' to write form data into an excel sheet.

 below is my code snippet, uses to add worksheets, iam getting an error, which is really breaking me.
can u please have a look at this, and help me.
Code: [Select]
<?php
$xml = simplexml_load_file("featureDetail.xml");
require_once 'Spreadsheet/Excel/Writer.php';
$excel = new Spreadsheet_Excel_Writer();
$sheet =& $excel->addWorksheet('Home');
$sheet->setColumn(0,0,29);
foreach($xml->FEATURE as $feature)
{
global $excel;
$value=html_entity_decode($feature->NAME);
echo " Value = $value";
echo "<br>";
$sheet123 =& $excel->addWorksheet('$value');
$sheet123->setColumn(0,0,29);
}
foreach($xml->FEATURE as $feature)
{
$sheet =& $excel->addWorksheet(html_entity_decode($feature->NAME));
$sheet->setColumn(0,0,29);
}
?>

Fatal error: Call to undefined method PEAR_Error::setColumn() in D:\xampp\htdocs\Release9.0\example.php on line 14

Well I have a library file class_database.php which defines a class called 'database' and a method called 'get' to retrieve database info. It was originally designed to return a two-dimensional array with the format of $array['index']['associative']. Right now I want to change this so as to return a result, which can then be used in other script files to retrieve data by using the fetch_array() method after getting this result. It doesnt work though, and I got this error 'Call to undefined method mysqli_stmt::get_result()', which confuses me...

The two methods get() and _buildQuery are shown below, please help me figure out how to return an Mysql result so that I can use while($row = $db->get()->fetch_array()) on it with flexibility...

The method get()
Code: [Select]
public function get($tableName, $numRows = NULL)
{

$this->_query = "SELECT * FROM $tableName";
$stmt = $this->_buildQuery($numRows);
$stmt->execute();
                $results = $stmt->get_result();

$this->reset();
return $results;
}

The method  _buildQuery is shown below:
Code: [Select]
protected function _buildQuery($numRows = NULL, $tableData = NULL)
{
(gettype($tableData) === 'array') ? $hasTableData = true : $hasTableData = false;
(!empty($this->_where )) ? $hasConditional = true : $hasConditional = false;

// Did the user call the "where" method?
if (!empty($this->_where)) {

// if update data was passed, filter through and create the SQL query, accordingly.
if ($hasTableData) {
$i = 1;
$pos = strpos($this->_query, 'UPDATE');
if ( $pos !== false) {
foreach ($tableData as $prop => $value) {
// determines what data type the item is, for binding purposes.
$this->_paramTypeList .= $this->_determineType($value);

// prepares the reset of the SQL query.
($i === count($tableData)) ?
$this->_query .= $prop . ' = ?':
$this->_query .= $prop . ' = ?, ';

$i++;
}
}
}

//Prepair the where portion of the query
$this->_query .= ' WHERE ';
$i = 1;
foreach ($this->_where as $column => $value) {
// Determines what data type the where column is, for binding purposes.
$this->_whereTypeList .= $this->_determineType($value);

// Prepares the reset of the SQL query.
($i === count($this->_where)) ?
$this->_query .= $column . ' = ?':
$this->_query .= $column . ' = ? AND ';

$i++;
}

}

// Determine if is INSERT query
if ($hasTableData) {
$pos = strpos($this->_query, 'INSERT');

if ($pos !== false) {
//is insert statement
$keys = array_keys($tableData);
$values = array_values($tableData);
$num = count($keys);

// wrap values in quotes
foreach ($values as $key => $val) {
$values[$key] = "'{$val}'";
$this->_paramTypeList .= $this->_determineType($val);
}

$this->_query .= '(' . implode($keys, ', ') . ')';
$this->_query .= ' VALUES(';
while ($num !== 0) {
($num !== 1) ? $this->_query .= '?, ' : $this->_query .= '?)';
$num--;
}
}
}

// Did the user set a limit
if (isset($numRows)) {
$this->_query .= " LIMIT " . (int) $numRows;
}

// Prepare query
$stmt = $this->_prepareQuery();

// Prepare table data bind parameters
if ($hasTableData) {
$this->_bindParams[0] = $this->_paramTypeList;
foreach ($tableData as $prop => $val) {
array_push($this->_bindParams, &$tableData[$prop]);
}
}
// Prepare where condition bind parameters
if($hasConditional) {
if ($this->_where) {
$this->_bindParams[0] .= $this->_whereTypeList;
foreach ($this->_where as $prop => $val) {
array_push($this->_bindParams, &$this->_where[$prop]);
}
}
}
// Bind parameters to statment
if ($hasTableData || $hasConditional){
call_user_func_array(array($stmt, 'bind_param'), $this->_bindParams);
}

return $stmt;
}

This topic has been moved to Third Party PHP Scripts.

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

Hello,

I have no idea where to post this but basically I am trying to create a facebook application using a "Building Facebook Applications For Dummies" book but I am stuck on the first paragraph! This is the appinclude.php file:

Code: [Select]
<?php
require_once '../client/facebook.php';

// *** Add your Facebook API Key, Secret Key, and Callback URL here ***
$appapikey = '<xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>';
$appsecret = '<xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>';
$appcallbackurl = '<http://projectstratos.com/facebook/live/>';  

// Connect to Facebook, retrieve user 
$facebook = new Facebook($appapikey, $appsecret);
// $user = $facebook->require_login(); OLD 
$user = $facebook->get_loggedin_user(); 
$is_logged_out = !$user; 

// Exception handler for invalid session_keys 
try {
  // If app is not added, then attempt to add 
  if (!$facebook->api_client->users_isAppAdded()) {
    $facebook->redirect($facebook->get_add_url());
  }
} catch (Exception $ex) {
  // Clear out cookies for app and redirect user to a login prompt
$facebook->set_user(null, null);
$facebook->redirect($appcallbackurl);
}
?>
And this is the index.php file:
Code: [Select]
<h1>Watch Project Stratos Live!</h1>
<?php
require_once 'appinclude.php';

echo "<p>Your user id is: $user</p>";
echo "<p>Your name is: <fb:name uid=\"$user\" useyou\"false\" /></p>";

echo "<p>You have several freinds: </p>";
$friends = $facebook->app_client->friends_get();
echo "<ul>";
foreach ($friends as $friend) {
echo "<li><fb:name uid=\"$freind\" useyou\"false\" /></li>";
}
echo "</ul>";
?>
The facebook.php is the current fbml version (v2.1.2-4 I think) and the content in the h1 tag is echoed however after that there is the following errror message:

Code: [Select]
Fatal error: Call to undefined method Facebook::get_loggedin_user() in /xxxxxx/xxxxxx/xxxxxx/xxxx/xxxxxxxxxxxxxxxxxxxxxx/facebook/live/appinclude.php on line 12
I have mo idea what the problem could be! I have tried changing get_loggedin_user to getUser() but I just get another error, this is aparently (according to another forum) because I "forgot" to add get_loggedin_user.

Thanks in advance,
Cameron

Hello,

I've been following google maps with php/mysql turorial http://code.google.com/apis/maps/articles/phpsqlajax.html

I've come to my phpsqlajax_genxml.php file which as the google code has it like this:

<?php
require("phpsqlajax_dbinfo.php");

// Start XML file, create parent node
$doc = domxml_new_doc("1.0");
$node = $doc->create_element("markers");
$parnode = $doc->append_child($node);

// Opens a connection to a MySQL server
$connection=mysql_connect (localhost, $username, $password);
if (!$connection) {
  die('Not connected : ' . mysql_error());
}

// Set the active MySQL database
$db_selected = mysql_select_db($database, $connection);
if (!$db_selected) {
  die ('Can\'t use db : ' . mysql_error());
}

// Select all the rows in the markers table
$query = "SELECT * FROM markers WHERE 1";
$result = mysql_query($query);
if (!$result) {
  die('Invalid query: ' . mysql_error());
}

header("Content-type: text/xml");

// Iterate through the rows, adding XML nodes for each
while ($row = @mysql_fetch_assoc($result)){
  // ADD TO XML DOCUMENT NODE
  $node = $doc->create_element("marker");
  $newnode = $parnode->append_child($node);

  $newnode->set_attribute("name", $row['name']);
  $newnode->set_attribute("address", $row['address']);
  $newnode->set_attribute("lat", $row['lat']);
  $newnode->set_attribute("lng", $row['lng']);
  $newnode->set_attribute("type", $row['type']);
}

$xmlfile = $doc->dump_mem();
echo $xmlfile;

?>


I started with this but was getting errors at line 1!! I looked around abit on the net and found i should change

$doc = domxml_new_doc("1.0");

to this

$doc = new DOMDocument('1.0');

Then i got errors abour creating the elements, i looke on php.net and it looked like i needed to change

$node = $doc->create_element("markers");
$parnode = $doc->append_child($node);
$newnode->set_attribute("name", $row['name']);


To this:

$node = $doc->createElement('markers');
$parnode = $doc->appendChild($node);
$newnode->setAttribute ('name', $row['name']);

This at least got my code further down the page until the very last statment:

$xmlfile = $doc->dump_mem();

Here i'm getting this error "Fatal error: Call to undefined method DOMDocument::dump_mem()" along with "Warning: Cannot modify header information - headers already sent"

I havent even looked at the warning i just tried to fix the fatal error. Again i looked around the web and forums and php.net and thought maybe i need to set the value to "true" but it still got a fatal error.

I looked on php.net and in there examples for dump_mem() and they had the nodes set_attribute create_element and append_child.

Which confused me as that was what i used originally just following the google script and that got me the error right away "Fatal error to undefined method DOMDocument::create"


Can anybody point out whats going wrong? This is my script that I am using

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

<!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>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
<title>phpsqlajax_genxml.php</title>
</head>

<body>
<?php
// Start XML file, create parent node
$doc = new DOMDocument('1.0');
$node = $doc->createElement('markers');
$parnode = $doc->appendChild($node);

// Select all rows in markers table
$query = "SELECT * FROM markers WHERE 1";
$result = mysql_query($query);
if (!$result) {
die ('Invalid query: ' . mysql_error());
}
header('Content-type: text/xml');

// Iterate through the rows, addind xml nodes for each
while ($row = mysql_fetch_assoc($result)) {
// Add to XML document node

$node = $doc->createElement('marker');
$newnode = $parnode->appendChild($node);

$newnode->setAttribute ('name', $row['name']);
$newnode->setAttribute ('address', $row['address']);
$newnode->setAttribute ('lat', $row['lat']);
$newnode->setAttribute ('lng', $row['lng']);
$newnode->setAttribute ('type', $row['type']);
}

$xmlfile = $doc->dump_mem();
echo $xmlfile;
?>

</body>

</html>


And the google code is on the link in posted in the messge also but this is theres both of which fail for Fatal errors either on the dump_mem() or new DOMDocument respecitvaley :

<?php
require("phpsqlajax_dbinfo.php");

// Start XML file, create parent node
$doc = domxml_new_doc("1.0");
$node = $doc->create_element("markers");
$parnode = $doc->append_child($node);

// Opens a connection to a MySQL server
$connection=mysql_connect (localhost, $username, $password);
if (!$connection) {
  die('Not connected : ' . mysql_error());
}

// Set the active MySQL database
$db_selected = mysql_select_db($database, $connection);
if (!$db_selected) {
  die ('Can\'t use db : ' . mysql_error());
}

// Select all the rows in the markers table
$query = "SELECT * FROM markers WHERE 1";
$result = mysql_query($query);
if (!$result) {
  die('Invalid query: ' . mysql_error());
}

header("Content-type: text/xml");

// Iterate through the rows, adding XML nodes for each
while ($row = @mysql_fetch_assoc($result)){
  // ADD TO XML DOCUMENT NODE
  $node = $doc->create_element("marker");
  $newnode = $parnode->append_child($node);

  $newnode->set_attribute("name", $row['name']);
  $newnode->set_attribute("address", $row['address']);
  $newnode->set_attribute("lat", $row['lat']);
  $newnode->set_attribute("lng", $row['lng']);
  $newnode->set_attribute("type", $row['type']);
}

$xmlfile = $doc->dump_mem();
echo $xmlfile;

?>



Thanks to anybody who can help me out 

Hi,

    I am very new to PHP and I am trying to execute the below code but getting these errors :


Notice: Undefined variable: mysql_query in C:\wamp\www\process.php on line 16

Fatal error: Function name must be a string in C:\wamp\www\process.php on line 16


Code:


<html><body>
<?php

mysql_connect("localhost","root","");
mysql_select_db("encryption") or die(mysql_error());

$username = $_POST['username'];
$password = $_POST['password'];

$mysql_query("INSERT INTO login (username,password) VALUES ('$username','$password')") or die(mysql_error());

?>
</body></html>
`
$_POST['username']   &
$_POST['password'] come from a previous page. I have no problem with that. Please help.. Thanks in advance.

i created an array like this

while{
$ir = 0;
$stud[$row_mrk['id_sub']][$ir]=$row_mrk['id_sub']; $ir++;
$stud[$row_mrk['id_sub']][$ir]=$row_mrk['seminar_topic']; $ir++;
$stud[$row_mrk['id_sub']][$ir]=$row_mrk['seminar_mark']; $ir++;
$stud[$row_mrk['id_sub']][$ir]=$row_mrk['attendance']; $ir++;
$stud[$row_mrk['id_sub']][$ir]=$row_mrk['internal_mark']; $ir++;
$stud[$row_mrk['id_sub']][$ir]=$row_mrk['external_mark']; $ir++;
}

echo "<input type='hidden' name='ar_std' id='ar_std' value='$stud' /> </table>" ;

and it is able to print in the same page using

foreach ($stud as $v1) {
echo "$v1\n<br>";
foreach ($v1 as $v2) {
echo "$v2\n<br>";
}
}

and in the next page

$ar_stud[]=$_POST["ar_std"];

I'm getting an error
PHP Warning:  Invalid argument supplied for foreach() in save.php on line 25
PHP Stack trace:

Undefined  error Why I am getting this error?   What I am trying archive -         I want to get the client location and stored in the database   Please advise me. Thank you.

<!DOCTYPE html>
<html>
<body>


<script>


function geoFindMe() {
  var output ;

  if (!navigator.geolocation){
     output.innerHTML = "<p>Geolocation is not supported by your browser</p>";
    return;
  } else {

  function success(position) {
    var latitude  = position.coords.latitude;
    var longitude = position.coords.longitude;

     return(output.innerHTML = '<p>Latitude is ' + latitude + '° <br>Longitude is ' + longitude + '°</p>');

  };

  function error() {
    output.innerHTML = "Unable to retrieve your location";
  };


  navigator.geolocation.getCurrentPosition(success, error);
  
  }
}

var x = geoFindMe();
alert(x);
</script>

</body>
</html>

Edited by thilakan, 03 October 2014 - 08:06 AM.

What causes this error??

Quote

Notice: Undefined index: firstname in /Users/user1/Documents/DEV/htdocs/index.php on line 2



TomTees

How do I get my session to be unset?

My form looks like this:

foreach ($joined as $i => $qty){
echo "<form action='' method='get' name='yourForm'>";
echo "<button type='submit' name='remove_" . $i . "' value='remove_" . $i . "' class='deletebtn' >X</button>";
echo "</form>";
}

My SESSION is defined like this:

for($i=0; $i<=5; $i++){
if (isset($_REQUEST["element_id_$i"]) ) {
$_SESSION["element_id_$i"] = $_REQUEST["element_id_$i"];
$id = $_SESSION["element_id_$i"];    
array_push($_SESSION["element_id"],$id);
}
$id = $_SESSION["element_id"];
}

and the form submits to:

if (isset($_REQUEST["remove_$i"]) ){

unset($_SESSION["quantity[$i]"]);
unset($_SESSION["element_id[$i]"]);
var_dump($_SESSION["element_id"]);
var_dump($_SESSION["quantity"]);
echo "Received variable " . $_REQUEST["remove_$i"];
echo 'TARGET INDEX TO BE REMOVED: ' . $_SESSION["element_id[$i]"] . '<br><br>';
}

The output is:

array(1) { [0]=> string(1) "1" } array(1) { [0]=> string(1) "1" } Received variable remove_1
Notice: Undefined index: element_id[1] in C:\xampp\htdocs\TopView\cart5.php on line 147
TARGET INDEX TO BE REMOVED: 
 

I get an undefined offset error when i try and call the array i made i know very little so I'm stuck and i don't know what to do
Code: [Select]
<?php
$file = fopen("playerstats.csv","r");

$data = array();
while (($csv_line = fgetcsv($file, 0, ";")) !== FALSE) {
  echo $csv_line;
    $number = $csv_line[0];
$name = $csv_line[1];
    $half = $csv_line[2];
$goals = $csv_line[3];
$assists = $csv_line[4];
$SOG = $csv_line[5];
$shots = $csv_line[6];
$fouls = $csv_line[7];
$yellow = $csv_line[8];
$yellowred = $csv_line[9];
$red = $csv_line[10];
$CK = $csv_line[11];
$saves = $csv_line[12];
    $data[] = array(
        'name' => $name,
        'half' => $half,
'goals' => $goals,
'assists' => $assists,
'sog' => $SOG, 
'shots' => $shots,
'fouls' => $fouls,
'yellow' => $yellow,
'yellowred' => $yellowred,
'red' => $red,
'ck' => $CK,
'saves' => $saves
    );
}

?>

<!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>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>
<table><tr><td>Number: </td><td><?php echo $data[0];?></td></tr></table>
</body>
</html>

I get this error 

Notice: Undefined index: loggedIn in C:\xampp\htdocs\Login\web_dir\index.php on line 6

The code for line 6 is 

if($_SESSION['loggedIn'] !== 1) {

Hey Everyone. I've been using a piece of code several times before and its worked fine but now (after updating my php version) I get an error.
Heres the code:

Code: [Select]
if(isset($_GET['id']) == TRUE){
if(is_numeric($_GET['id'])==FALSE) {
$error = 1;
}
if($error == 1){
header("Location: " . $config_basedir);
}
else{
$validentry = $_GET['id'];
}
}
else{
$validentry = 1;
}
The line with "if($error == 1){" gets flagged with an error saying:

Notice: Undefined variable: error in C:\xampp\htdocs\sites\smd\index.php on line 8

I've used the code before with no problems and uploaded to my web server I also have no errors. What did I do wrong. I hope it isn't a seriously stupid error.

Thanks in advance.