Using fwrite file system

kopuk1234

Hi every one, First I like to say Hello to every one for the first time here as I just joined the form.

I wonder if anyone could help me with this. I am here in front of my computer past 7 days days and nights trying to work this out.

I am at the beginin of building a php web program to keep track of payments, I am a window cleaner and I like to beable to send numbers like "10" to a php web page from a html form then I like the php script to:

Read the number I saved in a .txt file on my domain server.

GET the number I submit from html form

Then add two numbers together, like 15+10=25, and overwrite number stored
.txt file on the server and store the new result.

Disply .txt files content on a web page.

Similar to this

Mr: M.Ertu
Balance: 25

Or like this

Please help in detail
Thanks
Muyo

cretaceous

I think Halojoy (on this forum) is master of writing to flat text files..

but, imho, it may seem like more hassle to use a database... but using a database is actually not a big deal, you will find more resources on that and you will find it more flexible in the long run (and in the short term come to that)..

so look up how to save and retrieve values to a mySql database and it will all become clear.
(like your cleaned windows)

jay6390

$number = $_POST['number'];
$current = file_get_contents('filename.txt');
file_put_contents('filename.txt', $number + $current);

laserlight

I agree with cretaceous: use a database, even a lightweight one like SQLite will do. Chances are, you are going to want to associate the payment amount with the person who made payment, and for such situations a database will come in handy.

jay6390

Yup, if you're wanting to use more than just one person, consider the DB option. associative tables are the way to go. I'm guessing you are wanting to use this for storing payments etc (ie accounts). It would make more sense to use a pre-built script if you're not capable of making it yourself. There are lots out there

kopuk1234

Thank you people, I managed to write a script "It's much longer than the one posted here but I managed" then I decided to go in to writing a script in php and MySql, the only problem is to insert data in to my table, spent 3 days now to correct the php script I wrote but no luck so far.

<?php
$db=mysql_connect("adapazari.eu.mysql", "adapazari_eu", "xxxxxxxx");
mysql_select_db( "adapazari_eu", $db);
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_query("INSERT INTO Table_1
DueDate,
Notes,
Street,
Area,
City,
County,
PostCode,
Tel,
Mobile,
Email,
Price,
Balance,
Payments,
Refresh)

VALUES (
'$POST['DueDate']',
'$POST[Notes]',
'$POST[Street]','
$POST[Area]',
'$POST[City]',
'$POST[County]',
'$POST[PostCode]',
'$POST[Tel]',
'$POST[Mobile]',
'$POST[Email]',
'$POST[Price]',
'$POST[Balance]',
'$POST[Payments]',
'$POST[Refresh]'");

if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "1 record added"/COLOR];
mysql_close($con);
?>

kopuk1234

Sorry like this 🙂

VALUES (
'$POST['DueDate']',
'$POST[Notes]',
'$POST[Street]',
'$POST[Area]',
'$POST[City]',
'$POST[County]',
'$POST[PostCode]',
'$POST[Tel]',
'$POST[Mobile]',
'$POST[email]',
'$POST[Price]',
'$POST[Balance]',
'$POST[Payments]',
'$POST[Refresh]'");

if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "1 record added"/COLOR];
mysql_close($con);
?>

cretaceous

VALUES (
$_POST['DueDate'],
$_POST['Notes'],
etc...
");

....

echo '<span color="Lime">1 record added</span>';

note quote mark usage on first insert values..

note echo structure with single quotes wrapping entire output and double quotes for any html tags (or could be other way round with double quote outside and single quotes within)
and don't use square braces for html!

be very clear : php and html are two different things

fyi: this is still rough and could be done more nicely

kopuk1234

Hi, cretaceous the <span color tag apeared from the post I send it's not actually in my script.

cretaceous

this is in your script:

echo "1 record added"/COLOR];
- that echo structure is wrong...

it should be:
echo '<span color="Lime">1 record added</span>';

kopuk1234

It,s not my script as I didnt use any style in any way, writin the script, it apears from form text box.