PHP - Insert Back Up Database In A Folder

../ tells the php program to go up a level.
Code: [Select]
require_once '../directory/somefile.php';
Is there a shortcut to go to the public web folder?

For example. The following file is placed 3 folders deep:    "var/www/deep/deeper/verydeep/index.php"   and it requires a file with location: "var/www/thisfile.php"

I there a short cut/ quicker method to??
Code: [Select]
require_once '../../../thisfile.php';

Hello everyone! I am a new user and I have a simple question. How to download the database and create a backup. 

I have a profile page where the user answers a list of about 20 questions.  These questions are then put into a mysql table with username, questionid, and answer.  I can store the answers to the table, but I cannot figure out how to get them back to view and edit.
My form is built from basic HTML.  I know how to pull answers from a db table with only 1 row of results, where each field is a different question, but this one is different, as it will pull 20 rows, and each row is for a different question.
Here is how I populate the questions and then fill in the answers.
Code: [Select]
// If this user has never set their profile, insert empty questions into the database
  $query1 = "SELECT * FROM u_profile WHERE username = '" . $_SESSION['username'] . "'";
  $data = mysqli_query($dbc, $query1);
  if (mysqli_num_rows($data) == 0) {
    // First grab the list of questionids
    $query2 = "SELECT questionid FROM questions ORDER BY q_order";
    $data = mysqli_query($dbc, $query2);
    $questionids = array();
    while ($row = mysqli_fetch_array($data)) {
      array_push($questionids, $row['questionid']);
    }

    // Insert empty question rows into the u_profile table, one per question
    foreach ($questionids as $questionid) {
      $query3 = "INSERT INTO u_profile (username, questionid) VALUES ('" . $_SESSION['username']. "', '$questionid')";
      mysqli_query($dbc, $query3);
    }
  }

  // If the questionnaire form has been submitted, write the responses to the database
  if (isset($_POST['submit'])) {
    // Write the questionnaire response rows to the response table
    foreach ($_POST as $answer_id => $answer) {
      $query4 = "UPDATE u_profile SET answer = '$answer' WHERE username = '" . $_SESSION['username'] . "' AND questionid = '$answer_id'";
      $uprofile_set = "CALL uprofile_set('" . $_SESSION['username'] . "')";
      mysqli_query($dbc, $query4) or die( "Connection Error1" . mysqli_error($dbc) ) ;
      mysqli_query($dbc, $uprofile_set) or die( "Connection Error2" . mysqli_error($dbc) ) ;
    }
      $races = "SELECT * FROM u_raceschedule WHERE username = '" . $_SESSION['username'] . "'";
      $data = mysqli_query($dbc, $races);
      if (mysqli_num_rows($data) > 0) {
      set_time_limit(30);
       $buildplan = "CALL tplan('" . $_SESSION['username'] . "')";
       mysqli_query($dbc,$buildplan) or die("Connection Error2" . mysqli_error($dbc) ) ;

Would LOVE any help.  I am really new to this whole coding thing.

I have been looking around and have not been able to find any useful information on this.  I am trying to transfer files from a folder in the directory to a table in a database.  Eventually they will be images but for right now I am just trying to get text files to transfer.  Any help/code/ideas would be a lot of help.  This is going to be triggered a button on a page by the way.

I have a PHP CRUD application and when i delete a row i need it to delete from the MySQL and the image from the uploads folder as well. I have researched and tried dozens of ways with the unlink option but nothing works. If i take out the unlink from my code it will delete fine from the DB. I am new to coding and PHP so any help would be awesome.

The file_path is correct. The uploads is the name of the folder where the image is stored and the $_POST["image"] is the column name in MySQL where the image name is stored.

delete.php

<?php

	//start PHP session
	session_start();

if (!isset($_SESSION['success']))
{
    header("Location: login_page.php");
    die();
}

// check if value was posted
if($_POST){
 
    // include database and object file
    include_once 'config/database.php';

    $file_path = 'uploads/' . $_POST["image"];
    if(unlink($file_path))
 {
	// delete query
	$query = "DELETE FROM myDBname WHERE id = ?";
	$stmt = $con->prepare($query);
	$stmt->bindParam(1, $_POST['object_id']);
 }
	if($stmt->execute()){
		// redirect to read records page and 
		// tell the user record was deleted
		echo "Record was deleted.";
	}else{
		echo "Unable to delete record.";
    }
}

?>

this is the delete button code

					echo "<a delete-id='{$id}' class='btn btn-danger delete-object'>";
					echo "<span class='glyphicon glyphicon-remove'></span> Delete";
					echo "</a>";

This is the javascript for the delete button as well.

	// delete record
	$(document).on('click', '.delete-object', function(){

		var id = $(this).attr('delete-id');

		bootbox.confirm({
		    message: "<h4>Are you sure?</h4>",
		    buttons: {
		        confirm: {
		            label: '<span class="glyphicon glyphicon-ok"></span> Yes',
		            className: 'btn-danger'
		        },
		        cancel: {
		            label: '<span class="glyphicon glyphicon-remove"></span> No',
		            className: 'btn-primary'
		        }
		    },
		    callback: function (result) {

		        if(result==true){
					$.post('delete.php', {
						object_id: id
					}, function(data){
						location.reload();
					}).fail(function() {
						alert('Unable to delete.');
					});
		    	}
			}
		});

		return false;
	});

 

If you need any other info that would help you help me just let me know and i will get that in here ASAP. Thanks again for any help on this.