PHP - Reading And Writing To Php File

Hi   I come from a desktop (vb.net) background and have used oridinary text files for my databases. I use file locking to prevent other processes from writing to the same file simultaneously.   Now I am moving over the PHP/MySQL - what precautions should I take to stop a simultaneous processes from writing to a table at the same time.?   Do I need to lock the table before writing to it?   Does MySQL deal with this automatically and just block my process until the table becomes free?   (I am talking about a single table here, not multiple dependant tables - I know that is another issue)   Thanks     Nigel

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

does anyone know how to decode this XML variable value into string values? I also need to know the oposite way: creating variable values into xml. I've tried several code examples but they did filter the requested data.

Code: [Select]
$xml='<?xml version="1.0" encoding="utf-8"?>
<elements>
<text identifier="ed9cdd4c-ae8b-4ecb-bca7-e12a5153bc02">
  <value/>
</text>
<textarea identifier="a77f06fc-1561-453c-a429-8dd05cdc29f5">
  <value><![CDATA[<p style="text-align: justify;">Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.</p>]]></value>
</textarea>
<textarea identifier="1a85a7a6-2aba-4480-925b-6b97d311ee6c">
  <value><![CDATA[<p style="text-align: justify;">Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy  eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed  diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum.  Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor  sit amet.</p>]]></value>
</textarea>
<image identifier="ffcc1c50-8dbd-4115-b463-b43bdcd44a57">
  <file><![CDATA[images/stories/red/cars/autobedrijf.png]]></file>
  <title/>
  <link/>
  <target/>
  <rel/>
  <lightbox_image/>
  <width><![CDATA[250]]></width>
  <height><![CDATA[187]]></height>
</image>
<text identifier="4339a108-f907-4661-9aab-d6f3f00e736e">
  <value><![CDATA[Kramer 5]]></value>
</text>
<text identifier="ea0666d7-51e3-4e52-8617-25e3ad61f8b8">
  <value><![CDATA[6000 RS]]></value>
</text>
<text identifier="90a18889-884b-4d53-a302-4e6e4595efa0">
  <value><![CDATA[Eindhoven]]></value>
</text>
<text identifier="410d72e0-29b3-4a92-b7d7-f01e828b1586">
  <value><![CDATA[APK Pick up and return]]></value>
</text>
<text identifier="45b86f23-e656-4a81-bb8f-84e5ea76f71f">
  <value><![CDATA[15% korting op grote beurt]]></value>
</text>
<text identifier="3dbbe1c6-15d6-4375-9f2f-f0e7287e29f3">
  <value><![CDATA[Gratis opslag zomerbanden]]></value>
</text>
<text identifier="2e878db0-605d-4d58-9806-8e75bced67a4">
  <value><![CDATA[Gratis abonnement of grote beurt]]></value>
</text>
<text identifier="94e3e08f-e008-487b-9cbd-25d108a9705e">
  <value/>
</text>
<text identifier="73e74b73-f509-4de7-91cf-e919d14bdb0b">
  <value/>
</text>
<text identifier="b870164b-fe78-45b0-b840-8ebceb9b9cb6">
  <value><![CDATA[040 123 45 67]]></value>
</text>
<text identifier="8a91aab2-7862-4a04-bd28-07f1ff4acce5">
  <value/>
</text>
<email identifier="3f15b5e4-0dea-4114-a870-1106b85248de">
  <value/>
  <text/>
  <subject/>
  <body/>
</email>
<link identifier="0b3d983e-b2fa-4728-afa0-a0b640fa34dc">
  <value/>
  <text/>
  <target/>
  <custom_title/>
  <rel/>
</link>
<relateditems identifier="7056f1d2-5253-40b6-8efd-d289b10a8c69"/>
<rating identifier="cf6dd846-5774-47aa-8ca7-c1623c06e130">
  <votes><![CDATA[1]]></votes>
  <value><![CDATA[1.0000]]></value>
</rating>
<googlemaps identifier="160bd40a-3e0e-48de-b6cd-56cdcc9db892">
  <location><![CDATA[50.895711,5.955427]]></location>
</googlemaps>
</elements>';

I need to add these lines to my .htaccess file via PHP

Code: [Select]
RewriteCond %{REQUEST_URI} checkout
RewriteRule ^(.*)$ https://myurl.com/checkout/$1 [R,L]
RIGHT after this line:
Code: [Select]
RewriteBase /
AND before this line:
Code: [Select]
RewriteCond %{REQUEST_FILENAME} !-f
This is how the current file looks w/o the new line addition:

Code: [Select]
RewriteEngine On

RewriteBase /

RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.+)$ index.php [L,QSA]
It needs to look like this when the new lines are added(extra line breaks not necessary):

Code: [Select]
RewriteBase /

RewriteCond %{REQUEST_URI} checkout
RewriteRule ^(.*)$ https://myurl.com/checkout/$1 [R,L]

RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.+)$ index.php [L,QSA]
The line numbers may not match up, so I cannot use the line number.

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

      
      
   

Hey Guys. I am trying to write to the file depending on which condition is met. The code works fine on my local machiene but not on my remote server.
  I have also tried to output any error messages to see if it would output anything, and I don't get anyting on my browser. Can anyone help me with this issue? Thanks

<?php
if($_SERVER['REQUEST_METHOD'] == "POST") {


isset($_POST['interfax']) ? $option= "interfax" : $option= "";
isset($_POST['metrofax']) ? $option= "metrofax" : $option= "";


switch ($option) {
	case 'interfax':
	$file = "fax.php";
	$fax_client = "interfax";
	if(file_put_contents($file, "<?php ".'$fax_client = "' . $fax_client . '"'." ?>"))
	{ echo "Successful"; } else {
			die("Can't write file");
		}
		break;
	
		


    // By defualt all the orders go to metrofax so by selecting the variable it resets it self 
	case 'metrofax':
	$file = "fax.php";
	$fax_client = "metrofax";
	file_put_contents($file, "<?php ".'$fax_client = "' . NULL . '"'." ?>");
		break;	

			}


		}
?>


<form action="#" method="POST"> 

 <input type="radio" name="interfax" value="interfax">Switch To Interfax<br>
<input type="radio" name="metrofax" value="metrofax">Switch To Metrofax<br>

<input type='submit' name="submit" >

Ok, I know how to write to a file, but what I'm looking for is to check if a line of code exists, and if it is, don't recreate it. It would also be nice to not recreate the file either.

Code: [Select]
$file = fopen("index.html", "w");
fwrite($file,"This is a line of text");
fclose($file);

Greetings,   I am new to these forums, I am working on this assignment, and these are the current issues I am running into.   Notice: Undefined variable: year in G:\EasyPHP-5.3.2i\www\PHP_Projects\ChineseZodiacs\zodiac_year_switch.php on line 77 ie. $year = validateInput($year,"Birth Year"); Notice: Undefined variable: year_count in G:\EasyPHP-5.3.2i\www\PHP_Projects\ChineseZodiacs\zodiac_year_switch.php on line 138 ie. echo "<p>You are person " . $year_count . "to enter " . $year . "</p>\n";   Honestly, I believe they are linked, because what should be happening, as the user enters the year, and hits submit, it should create a file called counts/$year.txt - $year should equal the entered data in the textbox, any help would be appreciated.   Thank you for your help.

<!DOCTYPE html>
<head>
<title>Write to and From a File</title>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />

<?php

$dir = "counts";
if ( !file_exists($dir)) {
	mkdir ($dir, 0777);
	}

function validateInput($year, $fieldname) {
	global $errorCount;
	if (empty($year)) {
		echo "\"$fieldname\" is a required field.<br />\n";
		++$errorCount;
		$retval = "";
	}
	else
	{ // if the field on the form has been filled in
		if(is_numeric($year))
		{
			if($year >=1900 && $year <=2014)
			{
				$retval = $year;
			}
			else
			{
			++$errorCount;
			echo "<p>You must enter a year between 1900 and 2014.</p>\n";
			}
		}
		else
		{
			++$errorCount;
			echo "<p>The year must be a number.</p>\n";
		}
		
	} //ends the else for empty
	return($retval);
} //ends the function
function displayForm() {
?>
<form action = "<?php echo $_SERVER['SCRIPT_NAME']; ?>" method = "post"> 
<p>Year of Birth: <input type="text" name="year" /></p>
<p><input type="reset" value="Clear Form" />&nbsp; &nbsp;<input type="submit" name="submit" value="Show Me My Sign" /></p> 
</form>
<?php
}

function StatisticsForYear($year) {
		global $year_count;
	$counter_file = "counts/$year.txt";
	if (file_exists($counter_file)) {
		$year_count = file_get_contents($counter_file);
		file_put_contents($counter_file, ++$year_count);
	} else {
		$year_count = 1;
		file_put_contents($counter_file, $year_count);
	}
return ($year_count);
}?>	
	
</head>
<body>
<?php

$showForm = true;
$errorCount = 0;
//$year=$_POST['year'];

$zodiac="";
$start_year =1900;
if (isset($_POST['submit'])) 
	$year = $_POST['year'];
	$year = validateInput($year,"Birth Year");

	if ($errorCount==0)
		$showForm = false;
	else
		$showForm = true;

if ($showForm == true)
{
		//call the displayForm() function
		displayForm();
}
else
{ //begins the else statement
	//determine the zodiac
	 
	$zodiacArray = array("rat", "ox", "tiger", "rabbit", "dragon", "snake", "horse", "goat", "monkey", "rooster", "dog", "pig");
	
	 switch (($_POST['year'] - $start_year) % 6) {
	case 0:
			$zodiac = $zodiacArray[0];
	break;		
	case 1:
			$zodiac = $zodiacArray[1];
	break;		
	case 2:
			$zodiac = $zodiacArray[2];
	break;		
	case 3:
			$zodiac = $zodiacArray[3];
	break;		
	case 4:
			$zodiac = $zodiacArray[4];
	break;		
	case 5:
			$zodiac = $zodiacArray[5];
	break;		
	case 6:
			$zodiac = $zodiacArray[6];
	break;		
	case 7:
			$zodiac = $zodiacArray[7];
	break;		
	case 8:
			$zodiac = $zodiacArray[8];
	break;		
	case 9:
			$zodiac = $zodiacArray[9];
	break;		
	case 10:
			$zodiac = $zodiacArray[10];
	break;		
	case 11:
			$zodiac = $zodiacArray[11];
	break;
	default:
		echo "<p>The Zodiac for this year has not been determined.</p>\n";
	break;
	} //ends the switch statement

	echo "<p>You were born under the sign of the " . $zodiac . ".</p>\n";
	echo "<p>You are person " . $year_count . "to enter " . $year . "</p>\n";
} //ends the else statement	
	
?>
</body>
</html>

Edited by mstevens, 16 October 2014 - 06:36 PM.

I'm trying to write to a file with the following code.

$fh = fopen("../inc/config.php", "a") or die("\r\nCan't open file.");
$write = "\$config['database_host'] = {$mysqlh};
\$config['database_user'] = {$mysqlu};
\$config['datbase_pass'] = {$mysqlp};
\$config['datbase_name'] = {$dbn};
\$config['table_prefix'] = {$tp};";

fwrite($fh, $write);
fclose($fh);


It is printing out "Can't open file", which I guess means it can't find the file or I've given the wrong path. The file that is executing this code is /install and the file I'm trying to write to is /inc/config.php. I thought .. put you up a directory so if I do .. I will be at the root and then do /inc I will be in inc.

Can someone please guide me on what I'm doing wrong?

Thanks.

I have a code for writing a log file...
The code is working fine but it inserts the new details at the bottom of the file but i want to insert in the top...

So what function should i use... Here is the file my_log.php

Code: [Select]
<?php

$usname = $_SESSION['usname'];
date_default_timezone_set('Asia/Calcutta');
$date = date("l dS \of F Y h:i:s A");
$file = "log.php"; 
$open = fopen($file, "a+"); 
fseek($open,289);
fwrite($open "<b><br/>USER NAME:</b>              ".$usname . "<br/>"); 
fwrite($open, "<b>Date & Time:</b>            ".$date. "<br/>"); 
fwrite($open, "<b>What have they done :</b>   ".$reason . "<br/><br/>"); 
fclose($open); 

?>

and here is my log.php file :

Code: [Select]
<?php
session_start();
if($_SESSION['stage']!=1 || $_SESSION['stage2']!=2)
{header('location:index.php');
die(" ");
}
?>
<?php
if($_GET['valu']=="view_log")
{
$reason=" ".$_SESSION['usname']." Viewed the LOG";
include('my_log.php');
header('location:log.php');
die("");
}
// bytes till here are 289

//LINE 1 : Log details have to insert here



I want to insert every detail from the top of the page but just below the php code..
What should i do...

ANy helo would be appreciated

Pranshu Agrawal
pranshu.a.11@gmail.com

I am using a script I adapted from a tutorial to print the contents of a text box to a txt file. Basically, it's a really simple way of seeing who has logged in. I only have a handful of users.

The problem is, although the text file is being created in the proper folder, it isn't being written to and just remains blank.

<div align="center">
<table width="300" border="2" bordercolor="#FFFFFF" style="-moz-border-radius: 18px;
-webkit-border-radius: 18px;" height="120" cellpadding="0" cellspacing="0">
<tr>
<form name="form1" method="post" action="checklogin.php">
<td>
<table width="100%" border="0" cellpadding="3" cellspacing="1" background="images/loginbg.jpg"  style="-moz-border-radius: 15px;
-webkit-border-radius: 15px;">
<tr align="center">
<td colspan="3"><font color="#FFFFFF"><strong>Family Login </strong></font></td>
</tr>
<tr>
<td width="78"><font color="#000000">Username</font></td>
<td width="6">:</td>
<td width="294"><input name="myusername" type="text" id="myusername">
<?php
$myusername = $_POST['myusername'];

$data = "$myusername\n";


//open the file and choose the mode
$fh = fopen("logs/login.txt", "a");

fwrite($fh, $data);

fclose($fh);

?></td>
</tr>
<tr>
<td><font color="#000000">Password</font></td>
<td>:</td>
<td><input name="mypassword" type="password" id="mypassword"></td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td><input type="submit" name="Submit" value="Login">
</td>
</tr>
</table>
</td>
</form>
</tr>
</table>
</div>

I'm not sure what's going wrong but I'm guessing it's the placing of the php, or at least some of it.
I'd quite like to add the time they logged in as well. Any idea's anyone? 

I need help! I cant get this to write the correct way!

What i need is based on the value of what is posted to the script it has to write it in the config file and also make a folder!

Please help


Code: [Select]
<?php
$start = '$uploadpath=\'';
$structure = '../banner/images/'.$_POST['FOLDER'].'\';\n';

$myFile = "PHP/confup.php";
$fh = fopen($myFile, 'w') or die("can't open file");
$stringData = "<?\n";
fwrite($fh, $stringData);
$stringData = "$start $structure";
fwrite($fh, $stringData);
$stringData = "?>\n";
fwrite($fh, $stringData);
fclose($fh);

// Desired folder structure


// To create the nested structure, the $recursive parameter
// to mkdir() must be specified.

if (!mkdir($structure, 0777, true)) {
    die('Failed to create folders...');
}

// ...
?>

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?

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

$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);