PHP - Need Some Help With Reading File And Assigning Variables

Hi everyone.
I am David and I am new to web design and php. I am following a Lynda.com tutorial on php and sql.
I have reached a certain point in the tutorial where I am reading values back from my database in to a php variable. The variable is holding an array data type and I am accessing the element within the array.

I want a HTML select control and 2 radios buttons to reflect the values in the database.
Therefore the Select control should read a numeric value of type int and the radio buttons are reflecting either a 1 or a 0.

Firstly the code for the Select control uses a for loop to count the array elements and load the count into the Select control. The example uses php mixed with html. The for loop will count the number of element and add a number to the select control. The an If statment is used to make a decision if the count variable equals the value in the array element $sel_subject['position'] then select that value. This does not happen, and I can not seem to get it to work.

                                           <p>Position:
                  <select name="position">
                     <!--use a php block so as to use some php variables -->
                     <!--Use these variables with the get_all_sublects function. -->
                     <!-- This function will return all the dataset -->
                     <?php
                        $sel_subject = get_all_subjects();
                        //Then use the mysql fuction to retuen the numberic value of all the rows.
                        $subject_count = mysql_num_rows($sel_subject);
                        //$subject_count + 1 becauce we are adding a subject
                        for($count=1; $count <= $subject_count+1; $count++)
                        {
                           echo "<option value=\"{$count}\"";

                           if ($sel_subject['position'] == $count)
                           {
                              echo " selected";
                           }
                           
                           echo ">{$count}</option>";
                        }
                     ?>
                  </select>
               </p>

Secondly the radio buttons do something similar in that i want them to reflect the value in the array element. If a 1 then True and so be checked or 0 and so false and so be unchecked.

                                             <p>Visible:

                  <input type= "radio" name= "visible" value= "0"
                  <?php if ($sel_subject['visible'] == 0)
                  {
                     echo 'checked=" checked"';
                  }
                  ?>
                  >No</input>
               &nbsp;
                  <input type= "radio" name= "visible" value= "1"
                  <?php if ($sel_subject['visible'] == 1)
                  {
                     echo 'checked=" checked"';
                  }
                  ?>
                  >Yes</input>
               </p>

Again this doesn't work either. So in summary, I cant get the php code to affect the html form controls and relay the stored data to the user.
I have been racking my brain for days and getting no where. Please can anyone help me with this.

I would be very grateful.
All the best Irish_Dave

I have this code where I add records:

Code: [Select]
<?php

ini_set('display_errors',1);
error_reporting(-1);

require_once ('./includes/config.inc.php');

require_once (MYSQL);

$add_cat_errors = array();

if ($_SERVER['REQUEST_METHOD'] == 'POST')
{
// Check for a name:
if (empty($_POST['product'])) {
$add_cat_errors['product'] = 'Please enter the name!';
}

// Check for a description:
if (empty($_POST['prod_descr'])) {
$add_cat_errors['prod_descr'] = 'Please enter the description!';
}

// Check for a category:
if (!isset($_POST['cat']) || !filter_var($_POST['cat'], FILTER_VALIDATE_INT, array('min_range' => 1))) {
$add_cat_errors['cat'] = 'Please select a category!';
}

// Check for a price:
if (empty($_POST['price']) || !filter_var($_POST['price'], FILTER_VALIDATE_FLOAT) || ($_POST['price'] <= 0)) {
$add_cat_errors['price'] = 'Please enter a valid price!';
}

// Check for a category:
if (!isset($_POST['directory']) || !filter_var($_POST['directory'], FILTER_VALIDATE_INT, array('min_range' => 1))) {
$add_cat_errors['directory'] = 'Please select a directory!';
}

// Check for an image:
if (is_uploaded_file ($_FILES['image']['tmp_name']) && ($_FILES['image']['error'] == UPLOAD_ERR_OK)) {

$file = $_FILES['image'];

$size = ROUND($file['size']/1024);

// Validate the file size:
if ($size > 512) {
$add_cat_errors['image'] = 'The uploaded file was too large.';
} 

// Validate the file type:
$allowed_mime = array ('image/jpeg', 'image/JPG', 'image/jpg');
$allowed_extensions = array ('.jpg', 'jpeg');
$image_info = getimagesize($file['tmp_name']);
$ext = substr($file['name'], -4);
if ( (!in_array($file['type'], $allowed_mime)) 
||   (!in_array($image_info['mime'], $allowed_mime) ) 
||   (!in_array($ext, $allowed_extensions) ) 
) {
$add_cat_errors['image'] = 'The uploaded file was not of the proper type.';
} 

// Move the file over, if no problems:
if (!array_key_exists('image', $add_cat_errors)) {

// Create a new name for the file:
$new_name = (string) sha1($file['name'] . uniqid('',true));

// Add the extension:
$new_name .= ((substr($ext, 0, 1) != '.') ? ".{$ext}" : $ext);
//$new_name = $dir . '/' . $new_name;
$dest =  "../db/images/$new_name";

// Move the file to its proper folder but add _tmp, just in case:

//$dest =  "../db/images/$new_name";
$dirs = array('full_heads', 'human_hair', 'lip_tattoos', 'ponytails', 'synthetic_hair');

if (move_uploaded_file($file['tmp_name'], $dest)) {

// Store the data in the session for later use:
$_SESSION['image']['new_name'] = $new_name;
$_SESSION['image']['file_name'] = $file['name'];

// Print a message:
echo '<h4>The file has been uploaded!</h4>';

} else {
trigger_error('The file could not be moved.');
unlink ($file['tmp_name']);
}

} // End of array_key_exists() IF.

} elseif (!isset($_SESSION['image'])) { // No current or previous uploaded file.
switch ($_FILES['image']['error']) {
case 1:
case 2:
$add_cat_errors['image'] = 'The uploaded file was too large.';
break;
case 3:
$add_cat_errors['image'] = 'The file was only partially uploaded.';
break;
case 6:
case 7:
case 8:
$add_cat_errors['image'] = 'The file could not be uploaded due to a system error.';
break;
case 4:
default: 
$add_cat_errors['image'] = 'No file was uploaded.';
break;
} // End of SWITCH.

} // End of $_FILES IF-ELSEIF-ELSE.



// Check for a stock:
if (empty($_POST['stock']) || !filter_var($_POST['stock'], FILTER_VALIDATE_INT, array('min_range' => 1))) {
$add_cat_errors['stock'] = 'Please enter the quantity in stock!';
}

if (empty($add_cat_errors))
{
$query = "INSERT INTO product (product, prod_descr, catID, price, dirID, image, stock) VALUES (?, ?, ?, ?, ?, ?, ?)";
// Prepare the statement:
$stmt = mysqli_prepare($dbc, $query);
// For debugging purposes:
// if (!$stmt) echo mysqli_stmt_error($stmt);

// Bind the variables:
mysqli_stmt_bind_param($stmt, 'ssssssi', $name, $desc, $_POST['cat'], $_POST['price'], $_POST['directory'], $_SESSION['image']['new_name'], $_POST['stock']);

// Make the extra variable associations:
$name = strip_tags($_POST['product']);
$desc = strip_tags($_POST['prod_descr']);
// Execute the query:
mysqli_stmt_execute($stmt);

if (mysqli_stmt_affected_rows($stmt) == 1) { // If it ran OK.

// Print a message:
echo '<h4>The product has been added!</h4>';

// Clear $_POST:
$_POST = array();

// Clear $_FILES:
$_FILES = array();

// Clear $file and $_SESSION['image']:
unset($file, $_SESSION['image']);

} else { // If it did not run OK.
trigger_error('The product could not be added due to a system error. We apologize for any inconvenience.');
unlink ($dest);
}

} // End of $errors IF.

} else { // Clear out the session on a GET request:
unset($_SESSION['image']);
} // End of the submission IF.

require_once ('./includes/form_functions.inc.php');
?>

<form enctype="multipart/form-data" action="add_product.php" method="post" accept-charset="utf-8">

<input type="hidden" name="MAX_FILE_SIZE" value="524288" />

Product<br /><?php create_form_input('product', 'text', $add_cat_errors); ?>
           
            Description<br /><?php create_form_input('prod_descr', 'textarea', $add_cat_errors); ?>
           
Category<br /><select name="cat"<?php if (array_key_exists('cat', $add_cat_errors)); ?>>
<option>Select One</option>
<?php // Retrieve all the categories and add to the pull-down menu:
$q = 'SELECT catID, cat FROM category ORDER BY cat ASC';
$r = mysqli_query ($dbc, $q);
while ($row = mysqli_fetch_array ($r, MYSQLI_NUM)) {
echo "<option value=\"$row[0]\"";
// Check for stickyness:
if (isset($_POST['cat']) && ($_POST['cat'] == $row[0]) ) echo ' selected="selected"';
echo ">$row[1]</option>\n";
}
?>
</select><?php if (array_key_exists('cat', $add_cat_errors)) echo $add_cat_errors['cat']; ?>
           
            Price<br /><?php create_form_input('price', 'text', $add_cat_errors); ?>
           
            Directory<br /><select name="directory"<?php if (array_key_exists('directory', $add_cat_errors)); ?>>
<option>Select One</option>
<?php // Retrieve all the categories and add to the pull-down menu:
$q = 'SELECT dirID, directory FROM directory ORDER BY directory ASC';
$r = mysqli_query ($dbc, $q);
while ($row = mysqli_fetch_array ($r, MYSQLI_NUM)) {
echo "<option value=\"$row[0]\"";
// Check for stickyness:
if (isset($_POST['directory']) && ($_POST['directory'] == $row[0]) ) echo ' selected="selected"';
echo ">$row[1]</option>\n";
}
?>
</select><?php if (array_key_exists('directory', $add_cat_errors)) echo $add_cat_errors['directory']; ?>
</select>
           
            Image<br /><?php

// Check for an error:
if (array_key_exists('image', $add_cat_errors)) {

echo $add_cat_errors['image'] . '<br /><input type="file" name="image"/>';

} else { // No error.

echo '<input type="file" name="image" />';

// If the file exists (from a previous form submission but there were other errors),
// store the file info in a session and note its existence:
if (isset($_SESSION['image'])) {
echo "<br />Currently '{$_SESSION['image']['file_name']}'";
}

} // end of errors IF-ELSE.
 ?>
          <br />

Stock<br /><?php create_form_input('stock', 'text', $add_cat_errors); ?>


<input type="submit" value="Add This Product" class="button" />


</fieldset>

</form>

What I want to achieve is this;

When a record is being inserted, a user will make a selection from the dropdown box with a list of directories. Then, a user will upload an image. When a image is uploaded and a directory is chosen, I want the image to be assigned to a specific directory from the list so when the record is inserted, that image will be placed in the specific directory. How do I achieve this please?

Well, im a n00b for php, and what i need is a php script which will read data from .xml file and write it into .txt file. Can someone help me?
Example of .xml file :

<?xml version="1.0" encoding="utf-8"?>
<tv generator-info-name="NeTXMLTV/1.0.0.0" source-info-url="http://www.net-tv.hr/" source-info-name="NeT TV XMLTV" source-data-url="http://www.net-tv.hr/xmltv/net-pregled-programa-xmltv.xml">
  <programme channel="NeT TV" start="20110413063000 +0200" stop="20110413080000 +0200">
    <title lang="hr">JUTARNJI EXPRESS</title>
    <category lang="hr">glazbeno-informativni program</category>
    <desc lang="hr">Glazbeno informativna emisija sa servisnim informacijama i jutarnjim temperaturama, idealna za jutarnje buđenje uz toplu kavu ili čaj....</desc>
  </programme>
</tv>

I need the .txt file to look like this:
201104130630 - 201104130800
JUTARNJI EXPRESS
glazbeno-informativni program
Glazbeno informativna emisija sa servisnim informacijama i jutarnjim temperaturama, idealna za jutarnje buđenje uz toplu kavu ili čaj....

Can someone please help me? thanks

I am trying to use this weeklyReport1Boles.html:
Code: [Select]
<html>
<head>
<title>Weekly Report</title>
<link rel ="stylesheet" type="text/css" href="sample.css" />
</head>

<body>
<h1>Weekly Report</h1>
<p>
<form action = "weeklyReport1Boles.php" method = "post" >
<p>
<input type = "submit" value = "Display the Report" />
</p>
</form>
</body>
</html>

TO PULL data from weeklyDataBoles.txt lines 1-8
1    236.00
2    284.00
3    148.00
4    128.00
5       0.00
6    110.00
7       0.00
8

THE RESULTING WEB PAGE SHOULD BE:

Weekly Report

TOTAL INCOME FROM PAINT CONTRACTS: $0.00

AVG DAILY INCOME FROM PAINT CONTRACTS: $0.00

NUMBER OF DAYS with NO INCOME: .

MY PHP CODE IS:


<?php
$total = $_POST['total'];
$avgDailyIncome = $_POST['avgDailyIncome'];
$badDays = $_POST ['badDays'];

$paintFile = fopen("weeklyDataBoles.txt","r");
$year = fgets($weeklyDataBoles);
$total = 0;
for ($count= 1; $count <=7; $count = $count +1)
{
      $nextDay = fgets($weeklyDataBoles);
      $total = $total + $nextDay;
}
fclose($weeklyData);
$avgDailyIncome = $total/7;

print("<p>TOTAL INCOME FROM PAINT CONTRACTS: ");
print("$".number_format($total, 2)."</p>");
print("<p>AVG DAILY INCOME FROM PAINT CONTRACTS: ");
print("$".number_format($avgDailyIncome, 2)."</p>");
print("<p>NUMBER OF DAYS with NO INCOME: $badDays.</p>");

?>

</body>
</html>
   
      
      
THE AVERAGES ARE BASED ON ONE WEEK OR SEVEN DAYS, WHY CANT I OPEN THE FILE AND GET THE PROGRAM TO READ IT, I AM A STUDENT AND VERY, VERY, VERY BAD AT THIS, MAKES ME CRAZY CAUSE I REALLY LOVE IT

      
      
   

i have this script where the user enters their name and their favorite quotes.  It adds their favorite quotes and their names to quotes.txt and prints out their name and their quotes on view_quote.php.  I need to use a foreach() loop to print out the name and the quotes, but I'm confused about how to set it up. Here's my files.
add_quote.php
Code: [Select]
<!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" xml:lang="en" lang="en">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>Add A Quotation</title>
</head>
<body>
<?php // add_quote.php
/* This script displays and handles an HTML form. This script takes text input and stores it in a text file. */

// Identify the file to use:
$file = 'quotes.txt';

// Check for a form submission:
if ($_SERVER['REQUEST_METHOD'] == 'POST') { // Handle the form.

if ( !empty($_POST['quote']) && ($_POST['quote'] != 'Enter your quotation here.'
 ) ){ // Need some thing to write.

if (is_writable($file)) { // Confirm that the file is writable.

file_put_contents($file, $_POST['quote'] . PHP_EOL, FILE_APPEND | LOCK_EX); // Write the data.
file_put_contents($file, $_POST['name'] . PHP_EOL, FILE_APPEND | LOCK_EX);
// Print a message:
print '<p>Your quotation has been stored.</p>';

} else { // Could not open the file.
print '<p style="color: red;">Your quotation could not be stored due to a system error.</p>';
}

} else { // Failed to enter a quotation.
print '<p style="color: red;">Please enter a quotation!</p>';
}

} // End of submitted IF.

// Leave PHP and display the form:
?>

<form action="add_quote.php" method="post">
<p>Name:<input type="text" name="name"/><br />
<textarea name="quote" rows="5" cols="30">Enter your quotation here.</textarea><br />
<input type="submit" name="submit" value="Add This Quote!" />
</form>

</body>
</html>view_quote.php
Code: [Select]
<!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" xml:lang="en" lang="en">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>View A Quotation</title>
</head>
<body>
<h1>View My Quotes</h1>
<?php // view_quote.php
/* This script displays and handles an HTML form. This script reads in a file and prints a random line from it. */

// Read the file's contents into an array:
$data = file('quotes.txt');

// Count the number of items in the array:
$n = count($data);

// Pick a random item:
$rand = rand(0, ($n - 1));

// Print the quotation:
print '<p>' . trim($data[$rand]) . '</p>';


?>
</body>
</html>and the quotes.txt file is blank until the user enters their names and quotes.  Im trying to get this done kind of quick so any help would be awesome.

I have 4 websites
http://www.mercurymagazines.com/pr1/101/101395
http://www.mercurymagazines.com/pr1/169/16000
http://www.mercurymagazines.com/pr1/101/101396
http://www.mercurymagazines.com/pr1/169/16001

I am trying to write a program that will open each webpage one at a time, look for a unique word such as 'FREE' and if it is found the write the URL to a file, if not then no output and the next webpage is opened. I know this word exists only on one of the pages above (http://www.mercurymagazines.com/pr1/101/101396).

When http://www.mercurymagazines.com/pr1/101/101396 appears last in the list located in source.txt the programs WORKS.
When http://www.mercurymagazines.com/pr1/101/101396 appears in any other position such as first, or second, the program does NOT work.

My head is sore from banging against my desk. Any assistance would be appreciated.

<?php

$file_source = fopen("source.txt", "r");
$file_target = fopen("targets.txt", "w");

while (!feof($file_source) ) {
$url = fgets($file_source);

echo '<br>'.$url;

$raw_text = file_get_contents($url);

mb_regex_encoding( "utf-8" );
$words = mb_split( ' +', $raw_text );
 
foreach ($words as $uniques) {
echo $uniques;
  if ($uniques == 'FREE') {
     fwrite($file_target, $url);
     
     }
}

}

?>

hey guys im tyring to read my directory (whole of the web server)...i want to be able to put the file name and root into an array...im just wanting to know whats the best function i need to do this please?...thank you

hi i tried to add this to my php file

Code: [Select]
<?php

$xfile = @file('banners.txt', "r");
$random_num = rand (0,count($xfile)-1);
$data = explode("::",$xfile[$random_num]); 
echo $data[1];

?>

i get no output

i then tried just including the txt file like

include 'banners.txt';

then everything in the txt file opens.

and if i use fopen like this
Code: [Select]
<?php

$xfile = fopen ('banners.txt', "r");
$random_num = rand (0,count($xfile)-1);
$udata = explode("::",$xfile[$random_num]); 
echo $udata[1];

?>

i get this error

Warning: fopen(banners.txt) [function.fopen]: failed to open stream: No such file or directory in /home/www/public_html/template/folder1/main.php on line 72

where as the txt file exist there


anyone could help solve my issue?

$tracking_file_location    =  "../dispatch-manager/logs/tracking_file.txt";
$tracking_file                 =  fopen("$tracking_file_location", "r") or die("Unable to open file!");
$tracking_file_size        =  filesize("$tracking_file_location");
$tracking_file_text        =  fread($tracking_file,$tracking_file_size);
fclose($tracking_file);

Hello,

I am trying to read data from a text file but also adding up the 4th column for example

'name' 'more' '1.00'  'evenmore'

so were the 1.00 is I want to add it up is there anyway ?

My user needs me to update the database on their server from data contained in a text file but do not want me to upload the text file to the server but rather read the file from wherever it exists. Across the intranet.
Uploading the file means that whomsoever needs to do this update requires write permission to a folder on the server & my user does not want that.
Suggestions on how I should solve this problem would be greatly appreciated.
BTW My code works fine if I upload the file and do the update in place on the server.

As per the client requirement he wants to read words from a file and want to insert them in database  one by one . ie a confirmation is required whether he wants to insert is or not. I have developed the thing but the problem is when i am retrieving the words it asks for all the words. i will show u wat the problem is. My main query is i want to pause the exectution until user's input.

Code: [Select]
<script type="text/javascript" src="jquery.js"></script>
<script type"text/javascript">
function show() {
document.getElementById('form#submit').fadeIn();
alert("Abhinav");
}
$(document).ready(function(){
$("form#submit").submit(function() {
// we want to store the values from the form input box, then send via ajax below
var word    = $('#word').attr('value');
var synonym     = $('#synonym').attr('value');

$.ajax({
type: "POST",
url: "ajax.php",
data: "word="+ word + "&synonym=" + synonym,
success: function(){
$('form#submit').hide();
//$('form#submit :input').val("");
$('div.success').fadeIn();
}
});
return false;
});
});
</script>

<?php 
$file=fopen("welcome.txt","r") or exit("Unable to open file!");
@$word="";
@$c="";
while (!feof($file))
{
  $c=fgetc($file);
if(strcmp($c," ")==0)
{ echo "".
 
"<form id='submit' method='post' name='submit' action='' >".  
        "<fieldset>  ".
            "<legend>Enter Information</legend>  ".
"            <label for='word'>Word:</label>  ".
"<input id='word' class='text' name='word' size='20' type='text' value='$word' >  ".
"            <label for='Synonym'>Synonym:</label>  ".
"<input id='synonym' class='text' name='synonym' size='20' type='text'>  ".
"            <button class='button positive' type='submit'>  Add Client </button>  ".
   " </fieldset>  ".
   " </form>  ".
"<div class='success' style='display:none;'>Client has been added.</div>  ".
"</div>";
 
$word="";
}
else
$word=$word.$c;
}
fclose($file);

?>



Now what i want is after user clicks add client then only next insertion box must be shown. please check the attached image to see the output. Guys pls help me over this. Thnx in advance

Hi, I have this text file with a 123mb size
then i ran my simple script to read it and render it via browser

$fh = fopen('worldcitiespop.txt',r);
while(!feof($fh))
{
  $content = fgets($fh);
  echo $content."<br />";
}
fclose($fh);

I was expecting the 'whole' output via browser but then it didn't show "all"
because when I opened the text file via a wordpad, it's really huge..
can you tell me what's wrong with my script ?...( btw, there's no max execution time error at all )

Where is the best to store the list of categories and menu? Obviously it is better to reduce mysql queries. From a plain list in file, we can create desirable list (menu) from an array. This is quite faster (though SELECT from an indexed table is fast too; but I do know if it is as fast as reading from a php file). Any idea how to code this to create the menu faster ?

Hi. I have text files in the directory that contain rapidshare.com links. Now what I need to do is take them one by one and check links inside them one by one using rapidshare API.

Everything works fine apart from one thing.

It reads files and deletes the ones containing dead links but the problem is that it only deletes the file if ALL links are dead, but not when only one link is dead or some of them.

Code:

Code: [Select]
<?php
function rs_check($url){
if (!$url) return false;
$files_pattern= '/\/files\/([^\/]*)\//';
$filename_pattern= '/\/files\/.*\/(.*)/';
preg_match($files_pattern, $url, $matches_id);
preg_match($filename_pattern, $url, $matches_name);
$res= file_get_contents("http://api.rapidshare.com/cgi-bin/rsapi.cgi?sub=checkfiles_v1&files={$matches_id[1]}&filenames={$matches_name[1]}");
list($fId,$fName,$fSize,$fServerId,$fStatus,$fShortHost,$fmd5) =explode(',',$res);
return ($fStatus==1 || $fStatus==2);
}   
$directory = "download/"; 
$linksfiles = glob("" . $directory . "*.txt"); 
foreach($linksfiles as $linkfile)
{
$lf = file_get_contents($linkfile);
$purefilename = str_replace($directory, "" , $linkfile); 
if($purefilename != "5100c00fdb545e12e8cb4f9c5f69ec21.txt"){
if(rs_check($lf) != 1){
unlink($directory . $purefilename);
echo("<br />");
}
} 
}
?>