Read File Name With PHP?

Buck

First of all, let me apologize for sounding ignorant. I'm very new to PHP =).

I have hundreds of files in a directory on my website that pull data from MySQL. The files are named 1.php, 2.php, etc and the filename directly corresponds to the ID of the record in the MySQL database. For each file, I've been setting the ID manually to a variable (ie $ID = 1, etc). What I'd like to do instead is use some PHP code to check the file name and pull that number automatically into the $ID variable code.

So, if the file is 158.php, the code inside the file would automatically set the $ID = 158. That way, I can just copy/paste as many files as I need and not have to edit any of them manually to change the IDs.

Anyone know how this could be done?

Xoid

well... there are a couple of ways but I would personally try this method.

<?php

/ assuming you get something like this from PHP_SELF /
/ /PHPscripts/158.php /

$get_filename = explode("/",$_SERVER['PHP_SELF']);

$get_id = explode(".",$get_filename[2]);

/ then use casting to convert to integer /
print (integer)$get_id[0];

it shouldn't be problem to customize it for your own needs.

please forgive me if this code doesn't work but I haven't slept for quite a few hours and I'm OVERdue a coffee break, LOL

Hope this helps anyway!

Buck

Thanks Xoid!

How do I assign the ID to my own variable then? For example, if I need to assign the number of the file to $GameID, what extra code would I need?

Buck

Hmmm... I still can't get this to work. Anyone know of a way to check the filename and set it to a variable? or how to make Xoid's code work?

Xoid

post the code and I'll try and get it working for you 🙂

Xoid

just copy and paste this code and save the file as 158.php to see if it works!

Hope it helps!

<?php

/ assuming you get something like this from PHP_SELF /
/ /PHPscripts/158.php /

$get_filename = explode("/",$_SERVER['PHP_SELF']);

$get_id = explode(".",$get_filename[2]);

/ then use casting to convert to integer /
$grabid = (integer)$get_id[0];

print "<a href='http://www.somepage.com/index.php?id=$grabid'>[url]www.somepage.com/index.php?id=[/url]$grabid</a>";

Buck

Hmmm... I'm still not getting it to work. Here's my code, for my 1.php file. Keep in mind every profile will have a static page, I won't be using .php?ID=1.

$get_filename = explode("/",$_SERVER['PHP_SELF']);
$get_id = explode(".",$get_filename[2]);
$grabid = (integer)$get_id[0];
$table = "mytablename";
$db = mysql_connect("localhost","userid","password");
mysql_select_db("webdata",$db);
$sql_query = "select from $table where ID = $grabid";
$query_result = mysql_query("select from $table where id = $grabid");

Xoid

well... I can see no reason why the script doesn't work, have you named the id correct, is it ID or id?

check all your field names etc...

Buck

Sorry for my ignorance, but what is PHP_SELF? Is it something I need to install?

Buck

The code works good until I add yours to it. I just have to replace $getid with the number, such as 1. Like so:

$table = "mytablename";
$db = mysql_connect("localhost","userid","password");
mysql_select_db("webdata",$db);
$sql_query = "select from $table where ID = 1";
$query_result = mysql_query("select from $table where id = 1");

This works fine, but I don't want to have to change the "1" to "2" for 2.php, on up to 1000.php and so on.

Xoid

well... PHP_SELF grabs the name of the file your currently executing, so if you run 158.php, PHP_SELF will grab 158.php.

as I stated in the first example assuming $_SERVER['PHP_SELF']; results in something like '/PHPscripts/158.php' you can then use my code to grab 158 or you could modify my code to accomodate what value you receive from PHP_SELF.

try this:

<?php
  print $PHP_SELF;
  print $_SERVER['PHP_SELF'];
?>

I've tried my code together with yours and it works without problems, so you may be receiving a different value from PHP_SELF.

run the script above and tell me what you see.

quick explaination of the code:

  // Assuming you get something like '/PHPscripts/158.php'
  // from PHP_SELF.

  // this puts the path and filename into an array
  // e.g. $get_filename[1] = "PHPscripts";
  // e.g. $get_filename[2] = "158.php";
  $get_filename = explode("/",$_SERVER['PHP_SELF']); 

  // this puts the value from $get_filename[2]="158.php"
  // into a further array such as;
  // $get_id[0] = "158"
  // $get_id[1] = "php"
  $get_id = explode(".",$get_filename[2]); 

  // then we use casting to convert $get_id[0]="158" to
  //  an integer value
   $grabid = (integer)$get_id[0];

  // then $grabid will store the value 158

HTH

Buck

With just those two lines of code, my directory structure gets displayed twice. Part of the problem might be that I'm within two directories instead of your example of just one (/PHPScripts/)

/directory1/directory2/1.php/directory1/directory2/1.php is exactly what gets displayed with just those two lines of code.

Xoid

ok, so try this:

it should work now;

$get_filename = explode("/","/directory1/directory2/1.php"); 

$get_id = explode(".",$get_filename[3]); 

$grabid = (integer)$get_id[0];

print $grabid;

Buck

$get_filename = explode("/","/directory1/directory2/1.php");

What should I put in this line for 2.php, 3.php, etc?

Xoid

// $get_filename = explode("/","/directory1/directory2/1.php");  

$get_filename = explode("/",$_SERVER['PHP_SELF']);  

$get_id = explode(".",$get_filename[3]);  

$grabid = (integer)$get_id[0]; 

print $grabid;

Buck

Thanks Xoid, I think I finally got it =).

Xoid

Glad I could be of service 😃