PHP - References With Functions General Question

Bear with me, as I'm still quite new at PHP.

I'm trying to figure out the best way to build a search function for a database that will eventually be quite large.

The path of the search I'm building is to go from a straight-forward javascript and html search page, to a paginated search result. Then the user can narrow down those query results based on a new search of their results.

In trying to get the pagination to work across several pages(unsuccessfuly, I might add), I've been learning about sessions and temporary tables. But, because the database will be very large, I'm wondering if they are the wrong way. Sessions have a time limit, and temporary tables delete once the connection is closed.

Is it possible/feasible to build a permanent table that puts in the search variables, with a unique id and use this to manage the searches, pagination and all that? Then, at some point in the process, I can put code to delete the corresponding row (or even make it a saveable search). Maybe somebody sees where I'm going with this and  can describe it better than me? I'm just thinking off the cuff at the moment. Maybe there's some terminology that will help me find a tutorial. Any bit helps.
thanks!

Hi All:
I have general question on php...

 if I have an "includes" folder, and on IE somebody goes directly to it, like:
http://www.site.com/includes
on IE, they can see the folder-tree- directory. So, files like config.php, or mysql.php could be visible.
My question is, is this safe?? couldnt people then just drag-copy the file over into their system? or somehow open it, view its contents?
I dragged-copied a .php file into my desktop, but nothing shows up when I open in in notepad. As opposed to opening another file that was also .php but which only had javascript code in it, and the javascipt did show up.
So, I take it, it should be ok?? as it seems like it works as if the .php page actually had been loaded on a web-browser... doesnt show the php code...

well, appreciate comments, feedback on this...
what woudl be the best way to protect files like this? htaccess-protect? or is this not something to be overly concerned about??
From what I can tell looks like a lot of site are setup this way... so must be ok... ha?

Thanks!

Can someone give me an actual time when functions would become handy?

Thanks!

Hi i have a function strored in a seperate file (included in my main php page for use), my question is a simple one but i cannot seem to find the answer on the web to this:

I call the function as follows passing the variable $name


<?php
myfunction($name)
?>

The function does somehting simple such as:

<?php
function myfunction ($name)
{
   if ($name = 'bob')
  {
     return true;
  }
else return false;
}
?>


How do i then obtain the true or false value of the function from back with my main php page?

Hi everyone,


Until now i didnt use classes and functions for sql related actions and now i would like to start.

I started out with this :

class.php
--------------------------------------------------- class db { 
    
    public function connect($database,$user,$password) { 
        $db = mysql_connect("localhost",$user,$password) or die (mysql_error());
        mysql_select_db($database);
    }
    
    
    static function fetch() {
    
         function getresults($query) { 

        $resultArray = array();
        $fetch = mysql_query($query) or die (mysql_error());
        
        while ($row = mysql_fetch_assoc($fetch)){
            $resultArray[] = $row;
          
            }
        
            return $resultArray;
    
        mysql_free_result($fetch);
                
        }
        

    }

        
}         and index.php
----------------------------

  <?php
require('class.php');

$connection = new db();
$connection->connect("testdb","root","root");

$connection->fetch()->getresults("SELECT * FROM users");

foreach (getresults() as $user) { 
    echo "<div>{$user['user_first_name']}</div>";
}

I have asked this question in 3 different places but I get no answers lol. I hope to find some help here.   i want to only display user role for keymaster and moderator users. I don't want every participant to have their role shown , only the keymaster and moderators are important enough to me to show their role next to their avatar. The following function code i found, and used... It worked but has some issues:

function role_show () {
$displayed_user = bbp_get_reply_author_id() ;
$role = bbp_get_user_role( $displayed_user);
if ( bbp_is_user_keymaster($displayed_user) ||$role == 'bbp_moderator') $args['show_role'] = true ;
else $args['show_role'] = false ;
return $args ;
}
add_filter ('bbp_before_get_reply_author_link_parse_args', 'role_show' )

Code Issues: On the Forums topic post lists, This code also removes the avatar from showing in the same cell section as the “last post by” . And it removes the “last post by” name in this same section. How can I fix this ? If needed, I could implement this code again and provide a link to the error so you can see. Thank you for any help.       Side notes: Someone told me to try

function role_show ($args) {

As my first line , but it did not work. It resulted in the following screenshot :   as

Attached Files  functions-picture.png   35.46KB   0 downloads

Actually i have a very large object thats persistent using sessions. That object have two large arrays, and other things. I have to extract each time that arrays.

Now im using:
  $configuracion = $_SESSION['reg']->GetInvConfig();
  $categorias = $_SESSION['reg']->GetInvCategorias();

But if i get it well, this is copying all the array each time, no? i can use a reference to that array in the object easily to improve performace?

I can not seem to get this to work so wondered if I can do this or not.

Code: [Select]
$_SESSION['ref123'] = "my item";

for some reason it is not storing when i try this, how do I allow letters ?

I have been searching for a few weeks now and decided to get a little help on this on.

I am after a database like that which I found for the UK postcode, but one for the USA but it needs to have the North and East references.

Has anyone come across a site that offers a basic zipcode, state, Grid_N and Grid_E references ? if so please can you let me know what sites you have used.
 

I have a script I am putting together that simulate a cricket game. The only issue is, that there are a huge number of functions because there doesn't seem to be any other way to do this properly. As well as this, there a while() loop and all this seems to be leading to the page reaching a max 30 second timeout when generating the result.

My code is attached below, it is quite messy at the moment because i've just be working on it, but I was wondering if anyone has any solutions of how I can speed this up or change to prevent a timeout:

<?php
// Error reporting
error_reporting(E_ALL);

// Connect DB
mysql_connect("wickettowicket.adminfuel.com", "rockinaway", "preetha6488") or die(mysql_error());

// Select DB
mysql_select_db("wickettowicket") or die(mysql_error());

// MySQL queries to find batsmen and bowlers 
$array_batsmen = mysql_query('SELECT id, name, ability, strength FROM wtw_players WHERE team_id = 1 ORDER BY id ASC');
$array_bowlers = mysql_query('SELECT id, name, ability, strength FROM wtw_players WHERE team_id = 2');

// Start table for data 
$data = '<table width="600px">';

// Create blank scorecard
while ($array_bat = mysql_fetch_array($array_batsmen))
{
$data .= '<tr><td>'.$array_bat['name'].'</td><td></td><td></td><td>0</td></tr>';
}

// Set up arrays for players 
$current_batsman = $current_bowler = array();

// Reset query
mysql_data_seek($array_batsmen,0);

$in_one = $in_two = $it = '';

function currentBatsman($id, $name, $ability, $strength, $out, $in, $runs)
{
global $current_batsman;


$current_batsman = array (
'id' => $id,
'name' => $name,
'ability' => $ability,
'strength' => $strength,
'out' => $out,
'in' => $in,
'runs' => $runs
);

echo 'set current';
}

// Set up arrays of batsmen
while ($array = mysql_fetch_array($array_batsmen))
{

if ($it < 3 && $in_one == '') 
{
currentBatsman($array['id'], $array['name'], $array['ability'], $array['strength'], 0, 1, 0);

$batsmen[$array['id']] = array (
'id' => $array['id'],
'name' => $array['name'],
'ability' => $array['ability'],
'strength' => $array['strength'],
'out' => 0,
'in' => 1,
'runs' => 0
);

$in_one = $array['id'];
$current = $array['id'];
$it++;
}
else if ($it < 3 && $in_two == '') 
{
$batsmen[$array['id']] = array (
'id' => $array['id'],
'name' => $array['name'],
'ability' => $array['ability'],
'strength' => $array['strength'],
'out' => 0,
'in' => 1,
'runs' => 0
);

$in_two = $array['id'];
$it++;
}
else 
{
$batsmen[$array['id']] = array (
'id' => $array['id'],
'name' => $array['name'],
'ability' => $array['ability'],
'strength' => $array['strength'],
'out' => 0,
'in' => 0,
'runs' => 0
);
}

}

// Bowler Array
while ($array = mysql_fetch_array($array_bowlers))
{
$bowlers[] = array (
'name' => $array['name'],
'ability' => $array['ability'],
'strength' => $array['strength']
);

}

// Reset both queries
mysql_data_seek($array_bowlers,0);
mysql_data_seek($array_batsmen,0);



function changeBatsman($just_out)
{
global $array_batsmen, $batsmen; 

//Update array
$batsmen[$just_out] = array (
'in' => 1,
'out' =>  1
);

while ($array = mysql_fetch_array($array_batsmen))
{
if ($just_out != $array['id'] && $batsmen[$array['id']]['out'] != 0) currentBatsman($array['id'], $array['name'], $array['ability'], $array['strength'], 0, 1, 0);
}

// Reset query
mysql_data_seek($array_batsmen,0);

echo 'change batsman';
}

function swapBatsman($other_batsman)
{
global $array_batsmen, $batsman; 

while ($array = mysql_fetch_array($array_batsmen))
{
if ($other_batsman != $array['id'] && $batsman[$array['id']]['out'] != 0 && $batsman[$array['id']]['in'] == 1) currentBatsman($array['id'], $array['name'], $array['ability'], $array['strength'], 0, 1, 0);
}

// Reset query
mysql_data_seek($array_batsmen,0);

echo 'swap batsman';
}

$runs = $outs = $balls = $overs = 0;

$played = array();

function selectBowler()
{
global $bowlers, $current_bowler;

// Select random bowler
$choose_bowler = array_rand($bowlers, 1);

$current_bowler = array (
'name' => $bowlers[$choose_bowler]['name'],
'ability' => $bowlers[$choose_bowler]['ability'],
'strength' => $bowlers[$choose_bowler]['strength']
);

 

}

/*
function selectBatsman();
{
global $array_batsmen;

while ($array_batsmen[]['out'] != 1)
{


}*/

function bowl()
{
global $batsmen, $bowlers, $current_bowler, $current_batsman, $data, $balls, $outs, $runs;

if ($current_batsman['out'] == 0)
{
echo 'bowling';
// Set the initial number
$number = rand(0, 190);

// Ability of batsman
if ($current_batsman['ability'] > 90) $number += 30;
else if ($current_batsman['ability'] > 70) $number += 15;
else if ($current_batsman['ability'] > 50) $number += 2;
else $number = $number;

// Strength of batsman
if ($current_batsman['strength'] > 90) $number += 15;
else if ($current_batsman['strength'] > 70) $number += 10;
else if ($current_batsman['strength'] > 50) $number += 5;
else $number = $number;

// Depending on overs
if ($balls > 270) $number += 30;
else if ($balls > 120) $number -= 10;

// Ability
if ($current_bowler['ability'] > 90) $number -= 30;
else if ($current_bowler['ability'] > 70) $number -= 15;
else if ($current_bowler['ability'] > 50) $number -= 2;
else $number = $number;

// If batsman has made a huge total of runs, we need to knock some numbers off - more likely to get out
if ($current_batsman['runs'] > 200) $number -= 70;
else if ($current_batsman['runs'] > 100) $number -= 30;

// Finally sort out runs
if ($number > 190) $run = 6;
else if ($number > 170) $run = 4;
else if ($number > 160) $run = 3;
else if ($number > 100) $run = 2;
else if ($number > 50) $run = 1;
else if ($number > 10) $run = 0;
else if ($balls > 120 && $number > 0) $run = 0;
else $run = -1;

// Increase number of balls
$balls += 1;

// Are they out?
if ($run == -1)
{
$current_batsman['out'] = 1;

$played[] = $current_batsman['id'];
$find = '<tr><td>'.$current_batsman['name'].'</td><td></td><td></td><td>0</td></tr>';
$replace = '<tr><td>'.$current_batsman['name'].'</td><td></td><td>'.$current_bowler['name'].'</td><td>'.$current_batsman['runs'].'</td></tr>';

$data = str_replace($find, $replace, $data);


changeBatsman($current_batsman['id']); 



echo 'out';

}
else
{
$current_batsman['runs'] += $run;
$runs += $run;

if ($run == 1 || $run == 3)
{
swapBatsman($current_batsman['id']);
echo 'time to swap';
}

echo $run;


}

// Count outs
if ($current_batsman['out'] == 1)
$outs += 1;


}
}

function game()
{
global $main, $batsmen, $bowlers, $data, $batted, $balls, $outs, $current_batsman;

// Check if possible
while ($balls <= 295 && $outs < 10)
{

selectBowler();

// Actually bowl now

bowl();


}


}


game();



echo $data;

Hi to all the members of this great community,

This is my first post here and I am new in PHP and in general web programming, my background is in C and C++ programming languages that's why I want to make some comments with regards to PHP and getting your feedbacks.

In C++ one exercise considered that someone knows the basics of the language is to implement a general dynamic queue that is the client programmer can put an arbitrary number of objects into a queue and using templates you can instantiate different queues holding different kind of objects.

I have grasped the most important parts of the language and I am pondering if you can effectively implement something like the above using PHP.

I have googled this, and I have seen so far just a very simple implementation in PHP.
He has defined his queue using an array having a fixed size and he just moved an index up and down through the array while inserting and poping elements from the queue.

if you want to implement a dynamic queue the only way it comes to my mind just off the top of my head is to
use the the construct [] to add dynamically element at the end of the queue and when you want to pop up an element you just have to
unset(your current queue which is an array)
create another array (smaller by one element than the previous one)
copy the elements at the appropriate positions

I just wanted, people with a C++ programming experience to give me some feedback about this topic and to give me some basic idea how could we implement a general queue in PHP.
For example could we implement a queue w/o using an array?

I would appreciate any comment.

Greetings from Greece

Hello, I went through the forum, its geat but I think missing one feature,   There should be a forum about having general conversations and if someone wanted to talk about taking suggestions to help him/her across the world of programming, that would be very great.   Thanks.

This topic has been moved to PHP Regex.

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

My current function for checking over user inputs is below, email and phone numbers work just fine.

I'm more worried about the insufficiency of text and textarea, this isn't being used live anywhere atm while i remake it and i'm out of ideas on how to scan general data.

Fields passing through text, textarea might be full names, addresses, subjects basically general things. I've been stumbling on ideas of what would be best practice to do this.

Any ideas?


# $tbc = data to be cleaned
# $type = email, phone, text, textarea
function escape_data($tbc, $type='text') {
switch($type) {
case 'email':
if(preg_match('/(\w+\.)*\w+@(\w+\.)*\w+(\w+\-\w+)*\.\w+/', $tbc)){
$op = $tbc;
} else {
$op = false;
}
break;
case 'phone':
if (!empty($tbc)) { 
preg_match_all('/[0-9\(\)+.\- ]/s', $tbc, $cleaned); 
foreach($cleaned[0] as $k=>$v) { 
$ready .= $v; 
}
if ((strlen($ready) > 10) && (strlen($ready) <=25)) {
$op = $ready;
} else {
$op = false;
}
 } else {
$op = false;
 }
break;
case 'text':
case 'textarea':
if (!empty($tbc)) { 
$op = strip_tags($tbc);
} else {
$op = false;
}
break;
default:
$op = false;
}
return $op;
}

Hi

I am currently mostly learning procedural PHP but had a question about security.

 

Are hackers able to see connections to databases in procedural programming?

Would connections to databases need to be called from classes and methods instead? Or does it not matter that much?