[Resolved] randum and limited records returned

rayzun

#
<?php
$lines = file('/AAACars.data');
foreach ($lines as $line) {
$parts = explode('|', $line);
if ($parts[0] == $_GET['db_id']) {
echo "$parts[51]";
}}?>
#
This works and Im able to work with it

Question:
How to add a rule to set limit of records returned to say 20?
& / or
How to make the returned records a randum 20 out of the full list?

TheDefender

For your first question (limiting to 20 records), you need to use a [man]for[/man] loop to loop through the first 20 results.

For the second issue, use the [man]shuffle[/man] function before you pull out your records, so you can mix 'em up a bit.

I am not going to give you the code. I am tired and going to bed, so you can play in the manual, try to figure it out for yourself, and if you have troubles, post your code here, and we can help you tweak it later.

rayzun

ok, your right im tired too. I did find the shuffle from the manual and got a working script, but the more complex part I think, limiting to a certain amount of records is tough!

any ideas:

<?php
$lines = file('/AAACars.data');

shuffle($lines);

foreach ($lines as $line) {

$parts = explode('|', $line);

$numElements = count($parts);

if ($parts[24] == $_GET['mk']) {

echo "<a href=\"/english/AAACars.$parts[0].html?db_id=$parts[0]&mk=$mk&cyl=";

include '/templates/cyl.php';

echo "$parts[51]</a> ";

}}
echo "$numElements";
?>

TheDefender

Instead of foreach, use for to loop through it...

for($i = 0; $i < 20; $i++) {
echo $lines[$i];
}

Once you get that, you should be able to see how to use the $lines[$i] to manipulate it just as you were doing with the defined $line variable.

rayzun

Im so in need of help, Im stumped on this webpage for half a week and all the help out there is amazing. Ive got these script which should return an output from a text data file.

I tried all sorts of different structures I can think of..
I did get a result which would show a randum SINGLE result.

data file example:
1234|orange|new|6 times
1235|red|old|1 times ... etc 50+ fields

URL:
domain.com/cs.1359.html?db_id=1359

####1 attempt

<?php
$lines = file('/AAACars.data');

for ($i = 0; $i <= 10; $i++)
{
$parts = explode('|', $lines[$i]);
if ($parts[0] == $_GET['db_id'])
{
echo $parts['51'];
}
}
?>

####2 attempt

<?php
$lines = file('/AAACars.data');

$i = 0;
foreach ($lines AS $items)
{
if ($i > 10)
{
continue;
}
else
{
$parts = explode('|', $items);
if ($parts[0] == $_GET['db_id'])
{
echo $parts['51'];
}
}
$i++;
}
?>

TheDefender

Well, if you make this if comparison:

if ($parts[0] == $_GET['db_id'])
{
echo $parts['51'];
}

Then you should only get one result (assuming the db_id variable is unique.)

Do you want everything in the line matching the db_id? Or are you expecting more than one row to be returned by this? Need more details as to exactly what you are expecting to be returned compared to what is actually being returned.

rayzun

the db_id is unique, one per line as a number & increases for every entry.

My second post, I learned to identify the field/part so the script would output all lines (fields) I echo, and this was the start of the search for a script to limit the result.

well, I guess I should be searching every line at field [24] for all
matches to the variable in the URL and limit to 20 or less:
mk=

<?php
$lines = file('/AAACars.data');

foreach ($lines as $line) {

$parts = explode('|', $line);

$numElements = count($parts);

if ($parts[24] == $_GET['mk']) {

echo "$parts[51]</a> ";

}}
?>

sidney

try this

  <?php 
$num_results=20;
$lines = file('/AAACars.data'); 
$count=0;
shuffle($lines);
foreach ($lines as $line) { 
$parts = explode('|', $line); 
if ($parts[24] == $_GET['mk']) { 
echo "$parts[51]<br>"; 
$count++;
if($count>=$num_results)
break;
}
}

edit forgot to make it random added shuffle

rayzun

Wow, you have actually done it!
I have to say Im soooo impressed!!

However thanks!!!

It works It works

I can see it working and limiting the output too!

question
Would you happen to know about

$num = count($parts);

to count how many records in total are stored?

sidney

$num = count($parts); would count the number of records in a line

while $num = count($lines); would count the nuber of records in your data file

rayzun

Not sure where to use count($lines);

<?php

$lines = file('/cs.data');
foreach ($lines as $line) {
$parts = explode('|', $line);

$num = count($lines);

if ($parts[24] == $_GET['mk']) {
}}
echo "$num ";

sidney

all depends where you want to display it but you can count it any where after file()

  <?php 
$num_results=20;
$lines = file('/AAACars.data'); 
$num=count($lines);
$count=0;
shuffle($lines);
foreach ($lines as $line) { 
$parts = explode('|', $line); 
if ($parts[24] == $_GET['mk']) { 
echo "$parts[51]<br>"; 
$count++;
if($count>=$num_results)
break;
}
}
echo $count.' records of '.$num;

rayzun

thanx again sidney
Im seeing your eamples working, and its great!

The counting is counting all records,
to count only records from : parts[24]

if ($parts[24] == $_GET['mk']) {

-
best regards

sidney

<?php  

$num_results=20; 
$lines = file('/AAACars.data');  

$num=count($lines); 
$count=0; 
shuffle($lines); 
foreach ($lines as $line) {  

$parts = explode('|', $line);  

if ($parts[24] == $_GET['mk']) {  

$count++; 
if($count<=$num_results) 
echo "$parts[51]<br>";  

} 
} 
echo $count.' records of '.$num;

rayzun

You Rock

TheDefender

Thanks for following up Sidney... I've been tied up in meetings all day, and by the time I could intervene, you already had rayzun steering toward home on it, so I figured I would bail out...

rayzun

Thats good, I have an PHP include ' '
this makes the script not work as it was nicely coded.

<?php

$num_results=3;

$lines = file('/data/cs.data');

$num=count($lines);

$count=0;

shuffle($lines);

foreach ($lines as $line) {

$parts = explode('|', $line);

if ($parts[24] == $_GET['mk']) {

$count++;

if($count<=$num_results)

echo "<a href=\"/english/cs.$parts[0].html?db_id=$parts[0]&mk=$mk&cyl=";
include '/cyl.php';
echo "$parts[51]</a> ";

} }

echo '3 randum '.$count.' Total ';
echo 'All '.$num;

sidney

the if($count<=$num_results) need {} because theres more han one line

 
$num_results=3; 
$lines = file('/data/cs.data'); 
$num=count($lines); 
$count=0; 
$randcount=0;
shuffle($lines); 
foreach ($lines as $line) { 
$parts = explode('|', $line); 
if ($parts[24] == $_GET['mk']) { 
$count++; 
if($count<=$num_results) 
{
echo "<a href=\"/english/cs.$parts[0].html?db_id=$parts[0]&mk=$mk&cyl="; 
include '/cyl.php'; 
echo "$parts[51]</a><br>"; 
$randcount++;
}
} 
} 
echo $randcount.' randum<br>'.$count.' Total<br>'; 
echo 'All '.$num; [code=php]

rayzun

This is really good stuff

without grabbing a variable from the URL
how would I one replace

mk=Jaguar

$_GET['mk']

with actual text in PHP itself??

-
Best regards

TheDefender

Depends if you want to define the $mk variable, or the $GET array variable using the mk index... so either of these will work for you.

$mk = "Jaguar";
// OR
$_GET['mk'] = "Jaguar";