functions

[Superteddy]

I have thins function im trying to make but im not sure im doing it right.

  <?php

function raidName()
{
    global $db;
    
    $select = "SELECT raidName FROM raid WHERE raidName = $raidName";
    $result = $db->sql_query("$select");
    $result = $db->sql_fetchrow();
    
    return $result[0];
}

?>

and then im trying to get it to work by doing

                <h1><?php $raidName;?></h1>

i have been trying to work this out for over 2hours now but since im 100% new to php im lost here. If anyone could explain what im doing wrong it would be nice.


Im not sure, but im guessing that //global $db; // is calling the database. i already get that from the header witch gets it from the sessions file. Remove ing the global $db; dosnt do anything at all so i dont think it has to stay there but i keept it there.

/cheers

[simplecode]

 echo raidName(); 

[simplecode]

if u dont know whts global $db is doing in ur code then u r really lost... http://www.samspublishing.com/articl...&seqNum=7&rl=1

$db needs to defined some where to get access in function else u need to pass the values to the function to do the connection....
i think $db needs to be an object

wht kinda err u r getting

[simplecode]

whts the o/p for following

<?php

function raidName()
{
    global $db;
    
    $select = "SELECT raidName FROM raid WHERE raidName = $raidName";
    $result = $db->sql_query("$select");
    $result = $db->sql_fetchrow();
    
    echo $result[0];
    
}

raidName();

?>

[kyberfabrikken]

$raidName is a variable. A variable is like a container, which holds a value.
raidName() is a function. When a function is called, it returns a value, which can be assigned to a variable. When you call functions, you can also pass variables to the function, but this is optional.
echo is a statement, which works a bit like a function. When you call echo, it will output the values of a variable. For example, look at the following:

$some_variable = "Hello, World";
echo $some_variable; 

$some_variable is a variable, which is first assigned the value of "Hello, World". In the following line, the variable is passed to echo, which outputs the value of the variable.
Functions are called by writing their name. Before they can be called, they must be declared. Have a look at this:

function someFunction() {
    return "Hello again";
} 

This declares a function, someFunction. Declaring the function doesn't do anything in itself. You have to call the function, to actually do anything:

$some_variable = someFunction();
echo $some_variable; 

In this example, you call the function previously declared. The function returns the value "Hello again", which is then assigned to the variable $some_variable. You can then call echo as before, passing the variable to it.

Hope that clears up a few things.

[Superteddy]

thanks for the help guys but im still stuck.

<?

  include("include/header.php");
 
function raidName() 
{
    global $MySQLDB;
    
    $select = "SELECT 'raidName' FROM 'raid'";
    $result = $db->sql_query("$select");
    $request_data = $db->sql_fetchrowset();
    $num_requests = $db->sql_numrows();
    
    return $result[0];
}

?>
 <div id="primary" class="single-post">
        <div class="inside">
            
            <div class="primary">
                <h1><?php echo raidName(); ?></h1>

Im getting a error in line 17 ( $result = $db->sql_query("$select"); )

Fatal error: Call to a member function sql_query() on a non-object in \view.php on line 17

Im guessing that it is because of the $db and that it should be an object but im not sure what i would put there.

the function is from the old version of the tool im trying to make a new from. so im not the owner and im just learning php/mysql ( nice way to learn btw )

[kyberfabrikken]

You're right - the problem is that $db is undefined. Judging from the syntax, it's supposed to be an object. If you stick the line global $db back in, I would guess that it'll work. What this line does is to make the global variable $db available to the function. Without that, the variable doesn't exist inside the function.

To illustrate how global variables works, you can try the following two examples:

<?php
$foo = "Hello, World";
function bar() {
    echo $foo;
}
bar();
?>

<?php
$foo = "Hello, World";
function bar() {
    global $foo;
    echo $foo;
}
bar();
?>

[simplecode]

where is $db is defined ? its an object....
where is sql_query function is defined , its not a complete code to solve ur err.
is all thses things are in header.php then please post ur code of header.php here.

[Superteddy]

view.php

<?

  include("include/header.php");

function raidName()
{
    global $MySQLDB;
    
    $select = "SELECT 'raidName' FROM 'raid'";
    $result = $db->sql_query("$select");
    $request_data = $db->sql_fetchrowset();
    $num_requests = $db->sql_numrows();
    
    return $result[0];
}

?>
<div id="primary" class="single-post">
        <div class="inside">
            
            <div class="primary">
                <h1><?php echo raidName(); ?></h1>

database.php

      
class MySQLDB
{
   var $connection;         //The MySQL database connection
   var $num_active_users;   //Number of active users viewing site
   var $num_active_guests;  //Number of active guests viewing site
   var $num_members;        //Number of signed-up users
   /* Note: call getNumMembers() to access $num_members! */

   /* Class constructor */
   function MySQLDB(){
      /* Make connection to database */
      $this->connection = mysql_connect(DB_SERVER, DB_USER, DB_PASS) or die(mysql_error());
      mysql_select_db(DB_NAME, $this->connection) or die(mysql_error()); 

called like this : header -> sessions -> database

[simplecode]

sounds good but still few things are missing
$db
and method sql_query()

[Superteddy]

there is no $db, its called $MySQLDB

and method sql_query() - seems like this is what i dont understand.

no matter what i try i always get an error to this line : $result = $db->sql_query("$select");

[simplecode]

look into ur code

$request_data = $db->sql_fetchrowset(); 

here $db it is an object which is u r using in ur function if it is $mysqldb then replace $db vth that

Method sql_query() -- its a calss method which u r calling so it needs to be defined somewhere in ur calss.

[kyberfabrikken]

There is no $MySQLDB. There's a MySQLDB, which is a class. A class is not a variable.

Your database.php file is missing something. I guess that there is a line somewhere, perhaps near the end, which spells:

$db = new MySQLDB(); 

[simplecode]

$db = new classname() ;

class classname 
{
var .....

   function sql_query ()
   {
        some code here
   }
} 

the code ur posting if u ve only that part then u r not going 2 pass this err, never

[Superteddy]

There is no $MySQLDB. There's a MySQLDB, which is a class. A class is not a variable.

Your database.php file is missing something. I guess that there is a line somewhere, perhaps near the end, which spells:

$db = new MySQLDB(); 

yes there way *blush*,

$database = new MySQLDB(); 

getting
Fatal error: Call to undefined method MySQLDB::sql_query() in view.php on line 10 still

$result = $database->sql_query("$select"); 

[simplecode]

use $database instead of $db and locate the function sql_query

[Superteddy]

<?

  include("include/header.php");

function raidName()
{
    global $database;
    
    $select = "SELECT 'raidName' FROM 'raid'";
    $result = mysql_query($select, $this->connection);
    $request_data = $MySQLDB>sql_fetchrowset();
    $num_requests = $->sql_numrows();
    
    return $result[0];
}

?>
<div id="primary" class="single-post">
        <div class="inside">
            
            <div class="primary">
                <h1><?php echo raidName(); ?></h1>

now im getting
Parse error: parse error, unexpected T_OBJECT_OPERATOR, expecting T_VARIABLE or '$' in view.php on line 12

line 12:

$num_requests = $->sql_numrows(); 

[simplecode]

no u r doing some mistakes
http://us2.php.net/zend-engine-2.php

global $database;
    
       $request_data = $MySQLDB>sql_fetchrowset(); 

whatever u r define obejct use that name
$MySQLDB whts this ????????

[simplecode]

why dont u post ur whole code or just have a look at this http://us2.php.net/zend-engine-2.php u 'll be able to find and track the problem

[simplecode]

http://www.phpclasses.org/browse/package/1285.html