connection using mysqli_connect exampleLearning Curve- Perfect Tutorial for the beginers | Learning Curve- Perfect Tutorial for the beginers

File upload using php

step1: create a database ‘test’ and create table inside this database using the following query

CREATE TABLE IF NOT EXISTS `categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ttiles` varchar(250) NOT NULL,
  `path` varchar(250) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

CREATE TABLE IF NOT EXISTS `categories` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`ttiles` varchar(250) NOT NULL,

`path` varchar(250) NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

step2: create a folder called “fileupload” . step3: .create a folder ‘myfolder’ inside the ‘fileupload’ folder. step4: save the file ‘categories.php’ inside the ‘fileupload’ folder.

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>File upload using PHP:</title>
</head>
<body>

<table align="center">
<tbody>
<tr><td>
<form action="succescategories.php" method="POST" enctype="multipart/form-data">

Title:
<input type="text" name="titles" >
<br><br>
Imagine1:
<input type="file" name="filep" >
<br><br>
<input type="submit" value="Submit">
</form>
</tr></td>
</tbody>
</table>
</body>
</html>

<!DOCTYPE html>

<html>

<head>

<title>File upload using PHP:</title>

</head>

<body>

<tbody>

Title:

Imagine1:

</form>

</tr></td>

</tbody>

</table>

</body>

</html>

step5: save the file ‘successcategories.php ‘ inside the ‘fileupload’ folder.

<?php
$link = mysqli_connect("localhost", "root", "", "test");
 
// Check connection
if($link === false){
    die("ERROR: Could not connect. " . mysqli_connect_error());
}
 
// Escape user inputs for security

$titles = mysqli_real_escape_string($link, $_POST['titles']);


/*to upload fie*/

$fileName = $_FILES["filep"]["name"]; 
$fileTmpLoc = $_FILES["filep"]["tmp_name"];

$pathAndName = "myfolder/".$fileName;

$moveResult = move_uploaded_file($fileTmpLoc, $pathAndName);
// Evaluate the value returned from the function if needed
if ($moveResult == true) {

$insertpath=$pathAndName;
    
} else {
     $insertpath="Error in fie upload";
}




 
// attempt insert query execution
$sql = "INSERT INTO categories (ttiles,path) VALUES ('$titles','$insertpath')";
if(mysqli_query($link, $sql)){
    echo "<h1>Records added successfully.</h1>";
} else{
    echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);
}
 

 
// close connection
mysqli_close($link);


?>

<p><a href="categories.php">Add Category</a></p>

<?php

$link = mysqli_connect("localhost", "root", "", "test");

// Check connection

if($link === false){

die("ERROR: Could not connect. " . mysqli_connect_error());

}

// Escape user inputs for security

$titles = mysqli_real_escape_string($link, $_POST['titles']);

/*to upload fie*/

$fileName = $_FILES["filep"]["name"];

$fileTmpLoc = $_FILES["filep"]["tmp_name"];

$pathAndName = "myfolder/".$fileName;

$moveResult = move_uploaded_file($fileTmpLoc, $pathAndName);

// Evaluate the value returned from the function if needed

if ($moveResult == true) {

$insertpath=$pathAndName;

} else {

$insertpath="Error in fie upload";

}

// attempt insert query execution

$sql = "INSERT INTO categories (ttiles,path) VALUES ('$titles','$insertpath')";

if(mysqli_query($link, $sql)){

echo "<h1>Records added successfully.</h1>";

} else{

echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);

}

// close connection

mysqli_close($link);

<p><a href="categories.php">Add Category</a></p>

step6: execute… Read More »