Principal

<!DOCTYPE html>
<html lang="pt" dir="ltr">
  <head>
    <meta charset="utf-8">
    <title>Galeria</title>
    <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css" integrity="sha384-ggOyR0iXCbMQv3Xipma34MD+dH/1fQ784/j6cY/iJTQUOhcWr7x9JvoRxT2MZw1T" crossorigin="anonymous">
    <style>

      #geral{
        text-align: center;
        margin: auto;
        width: 600px;
      }
      .forms{
        border: 1px solid black;
        background-color: orange;
      }
      body{
        background-color: grey;
      }
    </style>

  </head>
  <body>

    <?php
      include"cabecalho.php";
    	$bd_host="localhost";
    	$bd_user="root";
    	$bd_password="";
    	$bd_database="galeria";

    	$msg="";
    	$erro=0;
    	$ms = new mysqli($bd_host,$bd_user,$bd_password,$bd_database);

    	$existe=false;

    	if ($ms->connect_error) {
    		$msg= '<h3 class="erro">Erro: ('. $ms->connect_errno .') '. $ms->connect_error . '</h3>';
    		$erro=1;
    	}

    ?>
<?php
  if(isset($_POST['insere']))
    {
      if($_POST['titulo']=='' || $_POST['descricao']=='' || $_POST['data']==''){
        $msg='<h3 class="erro">Erro, Existem campos por preencher!</h3>';
      }
      else{
        $destino =  "fotos/a" . $_POST['titulo'] . ".jpg" ;

  			if($_FILES["imagem"]["type"]=="image/jpeg"){
  				if(move_uploaded_file($_FILES['imagem']['tmp_name'], $destino)) {

//  					echo '<img src="' . $destino. '">';


  					$qr = "INSERT INTO tbl_fotos(imagem,titulo,descricao,data,tipo) VALUES(?,?,?,?,?)";


  					$st = $ms->prepare($qr);

  					$st->bind_param('sssss',$destino, $_POST["titulo"], $_POST["descricao"], $_POST["data"],$_POST["tipo"]);


  					if ($st->execute() && $st->affected_rows>0){
  						$msg='<h3 class="sucesso">A fotografia foi inserida!</h3>';
  					}
  					else{
  						$msg='<h3 class="erro" >Erro: ('. $ms->errno .') '. $ms->error . '</h3>';
  						$erro=1;
  					}
  					$st->close();


  				}
      }

    }
  }
  if(isset($_POST['novo'])){
    $qr = "INSERT INTO tbl_tipo(tipo) VALUES(?)";


    $st = $ms->prepare($qr);

    $st->bind_param('s', $_POST["tipo"]);


    if ($st->execute() && $st->affected_rows>0){
      $msg='<h3 class="sucesso">O tipo foi inserido!</h3>';
    }
    else{
      $msg='<h3 class="erro" >Erro: ('. $ms->errno .') '. $ms->error . '</h3>';
      $erro=1;
    }
    $st->close();
  }
 ?>


    <div id="geral">
      <br>
      <form class="forms" action="" method="post">
<br>
        Tipo: <input type="text" name="tipo"><input type="submit" name="novo" value="Novo">

        <br>
        <br>
        <br>
      </form>
      <form enctype="multipart/form-data" class="forms" action="" method="post">
        <br>
        <input type="file" name="imagem"><br><br>
        titulo:<input type="text" name="titulo"><br><br>
        Tipo:<select class="" name="tipo">
          <option value=""></option>
          <?php
        	$qr="SELECT * FROM tbl_tipo";
			    $st = $ms->query($qr);
			       while($row = $st->fetch_assoc())
      			{
		 		         echo '<option value = "'.$row['tipo'].'">'.$row['tipo'].' </option>';
			      }
			         $st->close();
			            ?>
        </select><br><br>
        Descricao:<input type="text" name="descricao" value=""><br><br>
        Data:<input type="date" name="data" value=""><br><br>
        <input type="submit" name="insere" value="Inserir">
        <br>
        <br>
        <br>
        <br>
      </form>
    </div>
    <?php echo $msg ; ?>
    <?php echo "<br>"; ?>
    <?php include"rodape.php"; ?>

  </body>

</html>