Jump to content

tkuan77

New Members
 View Profile  See their activity

  • Posts

    8

  • Joined

  • Last visited

    Never

 Content Type 

Posts posted by tkuan77

    Inserting php into mysql

    in PHP Coding Help

    Posted

    Hi,

     

    What I am trying to do is whenever the user created a new page it will be stored in the database and they can select it from a drop down list etc to view the page or edit the page or source code of the page with a text area editor such as ck editor or tinyMCE.

     

    Do note that it is for internal usage only. Do hope that there is a way to solve this problem.

     

    Regards

    Jas

    Inserting php into mysql

    in PHP Coding Help

    Posted

    Hi,

     

    Does anyone have any idea how to insert an entire php or html pages into mysql once the page has being created with php?

     

    E.g.

     

    np1.php

     

    <form action="np2.php" method="post">

    Name of New Page: <input type="text" name="newpage_name" />

    <input type="submit" />

    </form>

     

     

    np2.php

     

    <?php

    $newpage_name = $_POST[ 'newpage_name' ];

    $newpage_initial = "Input Contents Here.";

    //echo $editor_data;

     

    $newpage_file = "test/" . $newpage_name . ".php";

    $newpage_save = fopen($newpage_file, 'w');

    fwrite($newpage_save, $newpage_initial);

    fclose($newpage_save);

    ?>

     

     

    I have managed to create a new file with php but I also want it when I click on the submit button, it will also auto save that new php file or html file into mysql.

     

    Regards

    Jas

    Help on upload and download and mysql

    in PHP Coding Help

    Posted

    Hi MadTechie,

     

    an example of what happen when I upload and download the files are:

     

    original np1.php

     

    <form action="np2.php" method="post">

    Name of New Page: <input type="text" name="newpage_name" />

    <input type="submit" />

    </form>

     

     

    downloaded np1.php

     

    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

    <html xml

     

     

    Original np2.php

     

    <?php

    $newpage_name = $_POST[ 'newpage_name' ];

    $newpage_initial = "Input Contents Here.";

    $newpage_file = "test_np/" . $newpage_name . ".php";

    $newpage_save = fopen($newpage_file, 'w');

    fwrite($newpage_save, $newpage_initial);

    fclose($newpage_save);

    ?>

     

     

    downloaded np2.php

     

    <!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">

    <head>

    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

    <title>Untitled Document</title>

    </head>

    <body>

    <?php

    $newpage_name = $_POST[ 'newpage_name' ];

    $n

     

     

    Original links.html

     

    <!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">

    <head>

    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

    <title>Untitled Document</title>

    </head>

    <body>

    <ul>

    <li><a href="#home">Workspace</a></li>

    <li>  |  </li>

    <li><a href="#news">Manage</a></li>

    <li>  |  </li>

    <li><a href="#contact">Logout</a></li>

    </ul>

    </body>

    </html>

     

     

    downloaded links.html

     

    <!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">

    <head>

    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

    <title>Untitled Document</title>

    </head>

    <body>

    <!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">

    <head>

    <meta http-equiv="Content-Type"

     

     

    Original phpinfo.php

     

    <? phpinfo(); ?>

     

     

    Downloaded phpinfo.php

     

    <!DOCTYPE html P

     

     

    The errors appeared quite random. Hope this helps you understand the errors I am encountering.

     

    Regards

    Jasmine

    Help on upload and download and mysql

    in PHP Coding Help

    Posted

    Hi guys,

     

    I am trying to create a coding which allows users to upload and download files into mysql server, but I came across some errors. The coding itself works fine on the surface, but when I uploaded the file into mysql and download them, the contents of the downloaded file was different from the original file that was upload. One good example would be when I upload txt file or doc file. I was stuck on this for quite a few days without any leads.

     

    Here are the codes:

     

    index.html

     

    <form action="add_file.php" method="post" enctype="multipart/form-data">

    <input type="file" name="uploaded_file"><br>

    <input type="submit" value="Upload file">

    </form>

    <p>

    <a href="list_files.php">See all files</a>

    </p>

     

     

    add_file.php

     

    <?php

    // Check if a file has been uploaded

    if(isset($_FILES['uploaded_file'])) {

    // Make sure the file was sent without errors

    if($_FILES['uploaded_file']['error'] == 0) {

    // Connect to the database

    $dbLink = new mysqli('localhost', 'root', 'pwd', 'myTable');

    if(mysqli_connect_errno()) {

    die("MySQL connection failed: ". mysqli_connect_error());

    }

     

    // Gather all required data

    $name = $dbLink->real_escape_string($_FILES['uploaded_file']['name']);

    $mime = $dbLink->real_escape_string($_FILES['uploaded_file']['type']);

    $data = $dbLink->real_escape_string(file_get_contents($_FILES ['uploaded_file']['tmp_name']));

    $size = intval($_FILES['uploaded_file']['size']);

     

    // Create the SQL query

    $query = "

    INSERT INTO `file` (

    `name`, `mime`, `size`, `data`, `created`

    )

    VALUES (

    '{$name}', '{$mime}', {$size}, '{$data}', NOW()

    )";

     

    // Execute the query

    $result = $dbLink->query($query);

     

    // Check if it was successfull

    if($result) {

    echo 'Success! Your file was successfully added!';

    }

    else {

    echo 'Error! Failed to insert the file'

    . "<pre>{$dbLink->error}</pre>";

    }

    }

    else {

    echo 'An error accured while the file was being uploaded. '

    . 'Error code: '. intval($_FILES['uploaded_file']['error']);

    }

     

    // Close the mysql connection

    $dbLink->close();

    }

    else {

    echo 'Error! A file was not sent!';

    }

     

    // Echo a link back to the main page

    echo '<p>Click <a href="index.html">here</a> to go back</p>';

    ?>

     

     

    list_files.php

     

    <?php

    // Connect to the database

    $dbLink = new mysqli('localhost', 'root', 'pwd', 'myTable');

    if(mysqli_connect_errno()) {

    die("MySQL connection failed: ". mysqli_connect_error());

    }

     

    // Query for a list of all existing files

    $sql = 'SELECT `id`, `name`, `mime`, `size`, `created` FROM `file`';

    $result = $dbLink->query($sql);

     

    // Check if it was successfull

    if($result) {

    // Make sure there are some files in there

    if($result->num_rows == 0) {

    echo '<p>There are no files in the database</p>';

    }

    else {

    // Print the top of a table

    echo '<table width="100%">

    <tr>

    <td><b>Name</b></td>

    <td><b>Mime</b></td>

    <td><b>Size (bytes)</b></td>

    <td><b>Created</b></td>

    <td><b> </b></td>

    </tr>';

     

    // Print each file

    while($row = $result->fetch_assoc()) {

    echo "

    <tr>

    <td>{$row['name']}</td>

    <td>{$row['mime']}</td>

    <td>{$row['size']}</td>

    <td>{$row['created']}</td>

    <td><a href='get_file.php?id={$row['id']}'>Download</a></td>

    </tr>";

    }

     

    // Close table

    echo '</table>';

    }

     

    // Free the result

    $result->free();

    }

    else

    {

    echo 'Error! SQL query failed:';

    echo "<pre>{$dbLink->error}</pre>";

    }

     

    // Close the mysql connection

    $dbLink->close();

    ?>

     

     

    get_file.php

     

    <?php

    // Make sure an ID was passed

    if(isset($_GET['id'])) {

    // Get the ID

    $id = intval($_GET['id']);

     

    // Make sure the ID is in fact a valid ID

    if($id <= 0) {

    die('The ID is invalid!');

    }

    else {

    // Connect to the database

    $dbLink = new mysqli('localhost', 'root', 'pwd', 'myTable');

    if(mysqli_connect_errno()) {

    die("MySQL connection failed: ". mysqli_connect_error());

    }

     

    // Fetch the file information

    $query = "

    SELECT `mime`, `name`, `size`, `data`

    FROM `file`

    WHERE `id` = {$id}";

    $result = $dbLink->query($query);

     

    if($result) {

    // Make sure the result is valid

    if($result->num_rows == 1) {

    // Get the row

    $row = mysqli_fetch_assoc($result);

     

    // Print headers

    header("Content-Type: ". $row['mime']);

    header("Content-Length: ". $row['size']);

    header("Content-Disposition: attachment; filename=". $row['name']);

     

    // Print data

    echo $row['data'];

    }

    else {

    echo 'Error! No image exists with that ID.';

    }

     

    // Free the mysqli resources

    @mysqli_free_result($result);

    }

    else {

    echo "Error! Query failed: <pre>{$dbLink->error}</pre>";

    }

    @mysqli_close($dbLink);

    }

    }

    else {

    echo 'Error! No ID was passed.';

    }

    ?>

     

    I am not too sure where the error could be but I suspect that it could be somewhere at the add_file or get_file. Seriously hope someone could help me with this bug and thanks for the trouble.

     

    Regards

    Jasmine

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.