[RESOLVED] View/Write/Delete To File

[monarch_684]

Ok this what I am trying to do. I have looked but can't find a good tutorial on how to do this. Here it is.

I am building a web page that the user can access to update portions of their site. One particular spot is a scrolling text box that displays lines from a javascript file which the user does not edit the actual javascript, just the line that they want displayed. I have it set up so that the user can write to this file, but I also want the user to be able to delete or edit a line in the .js file. Basically this is how I want it set up:

The user enters the data and submits it. When they go to a dedicated page they can see the line they just wrote along with the other lines that have already been written. Each one should display 'delete | edit'.

Is there a way to do this?

Thanks

[temp.user123]

Sure, just not a real easy one. I've done this with CSV files. The .js file is a flat file -- thus, you cannot just insert or delete lines in the middle of it. Two ways -- all based on sequential line number (or a line tag which is part of the data): Read it all into memory and write it all out -- including or minus the inserted, updated, or deleted lines. Or, read a line at a time from one file and write a line at a time to a new file -- including or minus the inserted, updated, or deleted lines -- then delete the old file and rename the new file back to the old file name.

[monarch_684]

English please

[Sheldon]

You could do this easily with php and a mysql database.

[bluestars]

That was pretty simple, actually. You could read the file (to an array) a line at a time until you found the line before or after which you wanted to add another line. Then, you'd add it to the array and continue reading. Once you reached the end of the file, you could pump it all back out to a different file, then delete the original and rename the new one to the same name.

Why do you want to do things with Javascript, anyway?

[MrCoder]

Just read the whole file in to a multiline <textarea> then save the edited version to the file, newlines and all.

That way you can insert lines anywhere you want by just pressing enter?

[monarch_684]

Ok so I been reading and since everybody is saying I am going to use mysql. So now this question goes away from the original:

When ever I write to my table it shows up as blank data. Here's my script can some help me find the problem.

<?php
    $username = "username";
    $password = "password";
    $database = "test";

    $line = "10";
    $information = $_POST['description'];
        
    mysql_connect(localhost,$username,$password);
    @mysql_select_db($database) or die( "Unable to select database");

    $query = "INSERT INTO info_scroller VALUES ('$_POST[$line]', '$_POST[$information]')";
    if (mysql_query($query)) {
        print "successfully inserted record";
    }
    else {
      print "Failed to insert record";
    }
    mysql_close();
?>

[temp.user123]

Seems you want to change this:

$query = "INSERT INTO info_scroller VALUES ('$_POST[$line]', '$_POST[$information]')"; 

to this:

$query = "INSERT INTO info_scroller VALUES ('" . $_POST['line'] . "', '" . $_POST['information'] . "')"; 

However, for protection, you really want to scrub your form data before sticking it straight into an SQL query like that.

[monarch_684]

What do you mean??

and

$query = "INSERT INTO info_scroller VALUES ('" . $_POST['line'] . "', '" . $_POST['information'] . "')"; 

didn't work.

[temp.user123]

What do you mean??

and

$query = "INSERT INTO info_scroller VALUES ('" . $_POST['line'] . "', '" . $_POST['information'] . "')"; 

didn't work.

OK, based on this you posted:

    $line = "10"; 
    $information = $_POST['description']; 

You would use this:

$query = "INSERT INTO info_scroller VALUES ('" . $line . "', '" . $information . "');"; 

or this:

$query = "INSERT INTO info_scroller VALUES ('{$line}', '{$information});"; 

[monarch_684]

Ok still not working. I even went and got my book out of the car and did it's tutorial except it has me adding the values directly in :

<?php
        
    $connection = mysql_connect("localhost", "username", "password");
    @mysql_select_db("produce", $connection) or die( "Unable to select database" . mysql_error());
    
    $query = "INSERT INTO fruit (name, number) VALUES('apricots', '203')";
    $result = mysql_query($query)
        or die ("Couldn't query data" . mysql_error());
        
    $query = "SELECT * FROM fruit";
    $result = mysql_query($query)
        or die ("Couldn't query data" . mysql_error());    
        
    echo "<table border='1'>";
    echo "<tr>";
    echo "<th>Name</th><th>Number</th>";
    echo "</tr>";
    
    while ($row = mysql_fetch_array($result)) {
        echo "<tr>";
        echo "<td>", $row['name'], "</td><td>", $row['number'], "</td>";
        echo "</tr>";
    }
    
    echo "</table>";
    
    mysql_close();
?>

I am wanting the values to be user selected using a form. I add this to the script:

$name1 = $_POST["fruit"];
$number1 = $_POST["fnumber"];
.
.
.
$query = "INSERT INTO fruit (name, number) VALUES('$name1', '$fnumber1')"; 

This you would think is the same thing but the first example adds it ok, the second adds a field but nothing there. Even adding the double quotes does not work.

[temp.user123]

What does the HTML look like for these fields?

[monarch_684]

<form method="post" action="rewrite.php">
        </p><input type="text" name="name1"> <input type="text" name="fnumber1"></p>
	<p><input type="submit" value="Submit"><input type="reset" value="Reset" /></p>
</form>

[temp.user123]

Then this should work -- other than the lack of scrubbing:

$name1 = $_POST["fruit"]; 
$number1 = $_POST["fnumber"]; 
. 
. 
. 
$query = "INSERT INTO `fruit` (`name`, `number`) VALUES('{$name1}', '{$fnumber1}');"; 

[monarch_684]

Still no go. It just keeps on putting in blank data. It makes a new row and I can see the new row but no data.