<?php
function validateEmail($email)
{
   $pattern = '/^([0-9a-z]([-.\w]*[0-9a-z])*@(([0-9a-z])+([-\w]*[0-9a-z])*\.)+[a-z]{2,6})$/i';
   return preg_match($pattern, $email);
}
function addColumnIfNotExists($db, $mysql_table, $column_name, $column_type)
{
   $result = mysqli_query($db, "SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '$mysql_table' AND COLUMN_NAME = '$column_name'");
   if ($result)
   {
      $row = mysqli_fetch_row($result);
      $count = $row[0];
      if ($count == 0) 
      {
         $sql = "ALTER TABLE $mysql_table ADD $column_name $column_type";
         mysqli_query($db, $sql);
      }
   }
}
if ($_SERVER['REQUEST_METHOD'] == 'POST' && isset($_POST['formid']) && $_POST['formid'] == 'form1')
{
   $mailto = '';
   $mailfrom = isset($_POST['email']) ? $_POST['email'] : $mailto;
   $subject = 'Website form';
   $message = 'Values submitted from website form:';
   $success_url = '';
   $error_url = '';
   $mysql_server = 'localhost';
   $mysql_database = 'contacto_portofolio';
   $mysql_table = 'contacto';
   $mysql_username = 'root';
   $mysql_password = '';
   $eol = "\r\n";
   $error = '';
   $internalfields = array ("submit", "reset", "send", "filesize", "formid", "captcha", "recaptcha_challenge_field", "recaptcha_response_field", "g-recaptcha-response", "h-captcha-response");
   $boundary = md5(uniqid(time()));
   $header  = 'From: '.$mailfrom.$eol;
   $header .= 'Reply-To: '.$mailfrom.$eol;
   $header .= 'MIME-Version: 1.0'.$eol;
   $header .= 'Content-Type: multipart/mixed; boundary="'.$boundary.'"'.$eol;
   $header .= 'X-Mailer: PHP v'.phpversion().$eol;
   try
   {
      $message .= $eol;
      $message .= "IP Address : ";
      $message .= $_SERVER['REMOTE_ADDR'];
      $message .= $eol;
      foreach ($_POST as $key => $value)
      {
         if (!in_array(strtolower($key), $internalfields))
         {
            if (is_array($value))
            {
               $message .= ucwords(str_replace("_", " ", $key)) . " : " . implode(",", $value) . $eol;
            }
            else
            {
               $message .= ucwords(str_replace("_", " ", $key)) . " : " . $value . $eol;
            }
         }
      }
      $body  = 'This is a multi-part message in MIME format.'.$eol.$eol;
      $body .= '--'.$boundary.$eol;
      $body .= 'Content-Type: text/plain; charset=UTF-8'.$eol;
      $body .= 'Content-Transfer-Encoding: 8bit'.$eol;
      $body .= $eol.stripslashes($message).$eol;
      if (!empty($_FILES))
      {
         foreach ($_FILES as $key => $value)
         {
             if ($_FILES[$key]['error'] == 0)
             {
                $body .= '--'.$boundary.$eol;
                $body .= 'Content-Type: '.$_FILES[$key]['type'].'; name='.$_FILES[$key]['name'].$eol;
                $body .= 'Content-Transfer-Encoding: base64'.$eol;
                $body .= 'Content-Disposition: attachment; filename='.$_FILES[$key]['name'].$eol;
                $body .= $eol.chunk_split(base64_encode(file_get_contents($_FILES[$key]['tmp_name']))).$eol;
             }
         }
      }
      $body .= '--'.$boundary.'--'.$eol;
      if ($mailto != '')
      {
         mail($mailto, $subject, $body, $header);
      }
      $search = array("ä", "Ä", "ö", "Ö", "ü", "Ü", "ß", "!", "§", "$", "%", "&", "/", "\x00", "^", "°", "\x1a", "-", "\"", " ", "\\", "\0", "\x0B", "\t", "\n", "\r", "(", ")", "=", "?", "`", "*", "'", ":", ";", ">", "<", "{", "}", "[", "]", "~", "²", "³", "~", "µ", "@", "|", "<", "+", "#", ".", "´", "+", ",");
      $replace = array("ae", "Ae", "oe", "Oe", "ue", "Ue", "ss");
      foreach($_POST as $name=>$value)
      {
         $name = str_replace($search, $replace, $name);
         $name = strtoupper($name);
         if (is_array($value))
         {
            $form_data[$name] = implode(",", $value);
         }
         else
         {
            $form_data[$name] = $value;
         }
      }
      $db = mysqli_connect($mysql_server, $mysql_username, $mysql_password) or die('Failed to connect to database server!<br>'.mysqli_error($db));
      mysqli_query($db, "CREATE DATABASE IF NOT EXISTS $mysql_database");
      mysqli_select_db($db, $mysql_database) or die('Failed to select database<br>'.mysqli_error($db));
      mysqli_query($db, "CREATE TABLE IF NOT EXISTS $mysql_table (ID int(9) NOT NULL auto_increment, PRIMARY KEY (id))");
      addColumnIfNotExists($db, $mysql_table, 'DATESTAMP', 'DATE');
      addColumnIfNotExists($db, $mysql_table, 'TIME', 'VARCHAR(8)');
      addColumnIfNotExists($db, $mysql_table, 'IP', 'VARCHAR(15)');
      addColumnIfNotExists($db, $mysql_table, 'BROWSER', 'VARCHAR(255)');
      foreach($form_data as $name=>$value)
      {
         addColumnIfNotExists($db, $mysql_table, $name, 'VARCHAR(255)');
      }
      $stmt = mysqli_prepare($db, "INSERT INTO $mysql_table (`DATESTAMP`, `TIME`, `IP`, `BROWSER`) VALUES (?, ?, ?, ?)");
      $datestamp = date("Y-m-d");
      $time = date("G:i:s");
      $ip = $_SERVER['REMOTE_ADDR'];
      $browser = $_SERVER['HTTP_USER_AGENT'];
      mysqli_stmt_bind_param($stmt, "ssss", $datestamp, $time, $ip, $browser);
      mysqli_stmt_execute($stmt) or die('Failed to insert data into table!<br>'.mysqli_error($db));
      $id = mysqli_insert_id($db);
      foreach($form_data as $name=>$value)
      {
         mysqli_query($db, "UPDATE $mysql_table SET $name='".mysqli_real_escape_string($db, $value)."' WHERE ID=$id") or die('Failed to update table!<br>'.mysqli_error($db));
      }
      mysqli_close($db);
      header('Location: '.$success_url);
   }
   catch (Exception $e)
   {
      $errorcode = file_get_contents($error_url);
      $replace = "##error##";
      $errorcode = str_replace($replace, $e->getMessage(), $errorcode);
      echo $errorcode;
   }
   exit;
}
?>
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Portofolio Lima Studio</title>
<meta name="generator" content="WYSIWYG Web Builder 12 - http://www.wysiwygwebbuilder.com">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="font-awesome.min.css" rel="stylesheet">
<link href="https://fonts.googleapis.com/css2?family=Open+Sans:wdth,wght@75..100,300..800&300&display=swap" rel="stylesheet">
<link href="Portofolio.css" rel="stylesheet">
<link href="index.css" rel="stylesheet">
<link rel="stylesheet" href="fancybox/jquery.fancybox-1.3.4.css">
</head>
<body onload="ShowObject('FullScreenLayer1', 0);ShowObject('FullScreenLayer2', 0);ShowObject('FullScreenLayer3', 0);return false;">
   <div id="container">
   </div>
   <header id="PageHeader1">
      <div id="PageHeader1_Container">
         <div id="wb_Heading4">
            <h1 id="Heading4"><a href="./index.html">LIMA STUDIO</a></h1></div>
         <nav id="wb_CssMenu1">
            <ul id="CssMenu1" role="menubar" class="nav">
               <li role="menuitem" class="nav-item firstmain"><a class="nav-link" href="#portfolio" target="_self"><i class="fa fa-th"></i>PORTFOLIO</a>
               </li>
               <li role="menuitem" class="nav-item"><a class="nav-link" href="#about" target="_self"><i class="fa fa-user-circle-o"></i>ACERCA</a>
               </li>
               <li role="menuitem" class="nav-item"><a class="nav-link" href="#contact" target="_self"><i class="fa fa-address-card"></i>CONTACTE-ME</a>
               </li>
            </ul>
         </nav>
      </div>
   </header>
   <div id="portfolio">
      <div id="portfolio_Container">
         <div id="RollOverLayer3">
            <div class="hover">
               <div id="wb_FontAwesomeIcon14">
                  <div id="FontAwesomeIcon14"><i class="fa fa-eye"></i></div></div>
               <div id="wb_Heading11">
                  <h1 id="Heading11">Projeto 3</h1></div>
            </div>
            <div class="default">
               <div id="wb_FontAwesomeIcon3">
                  <a href="javascript:displaylightbox('./images/clouds@2x.jpg',{})" target="_self" onclick="ShowObject('FullScreenLayer3', 1);return false;"><div id="FontAwesomeIcon3"><i class="fa fa-search-plus"></i></div></a></div>
            </div>
         </div>
         <div id="RollOverLayer6">
            <div class="hover">
               <div id="wb_FontAwesomeIcon17">
                  <div id="FontAwesomeIcon17"><i class="fa fa-headphones"></i></div></div>
               <div id="wb_Heading14">
                  <h1 id="Heading14">Project 6</h1></div>
            </div>
            <div class="default">
               <div id="wb_FontAwesomeIcon6">
                  <a href="javascript:displaylightbox('./images/clouds@2x.jpg',{})" target="_self" onclick="ShowObject('FullScreenLayer3', 1);return false;"><div id="FontAwesomeIcon6"><i class="fa fa-search-plus"></i></div></a></div>
            </div>
         </div>
         <div id="RollOverLayer5">
            <div class="hover">
               <div id="wb_FontAwesomeIcon16">
                  <div id="FontAwesomeIcon16"><i class="fa fa-globe"></i></div></div>
               <div id="wb_Heading13">
                  <h1 id="Heading13">Project 5</h1></div>
            </div>
            <div class="default">
               <div id="wb_FontAwesomeIcon5">
                  <a href="javascript:displaylightbox('./images/clouds@2x.jpg',{})" target="_self" onclick="ShowObject('FullScreenLayer2', 1);return false;"><div id="FontAwesomeIcon5"><i class="fa fa-search-plus"></i></div></a></div>
            </div>
         </div>
         <div id="RollOverLayer4">
            <div class="hover">
               <div id="wb_FontAwesomeIcon15">
                  <div id="FontAwesomeIcon15"><i class="fa fa-trophy"></i></div></div>
               <div id="wb_Heading12">
                  <h1 id="Heading12">Project 4</h1></div>
            </div>
            <div class="default">
               <div id="wb_FontAwesomeIcon4">
                  <a href="javascript:displaylightbox('./images/clouds@2x.jpg',{})" target="_self" onclick="ShowObject('FullScreenLayer1', 1);return false;"><div id="FontAwesomeIcon4"><i class="fa fa-search-plus"></i></div></a></div>
            </div>
         </div>
         <div id="wb_Heading6">
            <h1 id="Heading6">PORTFOLIO</h1></div>
         <div id="RollOverLayer1">
            <div class="hover">
               <div id="wb_FontAwesomeIcon12">
                  <div id="FontAwesomeIcon12"><i class="fa fa-star"></i></div></div>
               <div id="wb_Heading9">
                  <h1 id="Heading9">Projeto 1</h1></div>
            </div>
            <div class="default">
               <div id="wb_FontAwesomeIcon1">
                  <a href="javascript:displaylightbox('./images/clouds@2x.jpg',{})" target="_self" onclick="ShowObject('FullScreenLayer1', 1);return false;"><div id="FontAwesomeIcon1"><i class="fa fa-search-plus"></i></div></a></div>
            </div>
         </div>
         <div id="RollOverLayer2">
            <div class="hover">
               <div id="wb_FontAwesomeIcon13">
                  <div id="FontAwesomeIcon13"><i class="fa fa-shopping-cart"></i></div></div>
               <div id="wb_Heading10">
                  <h1 id="Heading10">Projeto 2</h1></div>
            </div>
            <div class="default">
               <div id="wb_FontAwesomeIcon2">
                  <a href="javascript:displaylightbox('./images/clouds@2x.jpg',{})" target="_self" onclick="ShowObject('FullScreenLayer2', 1);return false;"><div id="FontAwesomeIcon2"><i class="fa fa-search-plus"></i></div></a></div>
            </div>
         </div>
      </div>
   </div>
   <div id="intro">
      <div id="intro-overlay"></div>
      <div id="intro_Container">
         <div id="wb_Heading5">
            <h1 id="Heading5">OLÁ!</h1></div>
         <div id="wb_Image1">
            <img src="images/Foto.png" id="Image1" alt="" width="195" height="230"></div>
         <div id="wb_Text4">
            <span style="color:#FFFFFF;font-family:Arial;font-size:21px;"><strong>Seja Bem-vindo ao portofolio Lima Studio</strong></span></div>
      </div>
   </div>
   <div id="about">
      <div id="about_Container">
         <div id="wb_Heading7">
            <h1 id="Heading7">SOBRE MÍM</h1></div>
         <div id="wb_Text5">
            <span style="color:#FFFFFF;font-family:Verdana;font-size:19px;">Sou um profissional dedicado e apaixonado pela tecnologia, com uma sólida formação em informática e experiência em desenvolvimento de software, design e manutenção de hardware. Estou sempre buscando novos desafios e oportunidades para aplicar minhas habilidades e contribuir para projetos inovadores.</span></div>
      </div>
   </div>
   <div id="contact">
      <div id="contact_Container">
         <div id="wb_Heading8">
            <h1 id="Heading8">CONTACTE-ME</h1></div>
         <div id="wb_Form1">
            <form name="Form1" method="post" action="<?php echo basename(__FILE__); ?>" enctype="multipart/form-data" id="Form1">
               <input type="hidden" name="formid" value="form1">
               <hr id="Line1">
               <input type="text" id="nome" name="Name" value="" spellcheck="false" placeholder="Nome">
               <hr id="Line3">
               <input type="text" id="telefone" name="telefone" value="" spellcheck="false" placeholder="Número de Telefone">
               <hr id="Line4">
               <textarea name="messagem" id="mensagem" rows="2" cols="65" autocomplete="off" spellcheck="false" placeholder="Messagem"></textarea>
               <hr id="Line5">
               <input type="submit" id="Button1" name="" value="Enviar">
            </form>
         </div>
      </div>
   </div>
   <div id="social">
      <div id="social_Container">
         <div id="wb_Text7">
            <span style="color:#FFFFFF;font-family:Arial;font-size:16px;"><strong><br>Angola, Saurimo/Lunda-Sul<br>Email: feliciofernando567@gmail.com<br>Telefone: (+244) 946788879</strong></span></div>
         <div id="wb_Text8">
            <span style="color:#FFFFFF;font-family:Arial;font-size:19px;"><strong>INFO</strong></span></div>
         <div id="wb_FontAwesomeIcon7">
            <a href="https://www.facebook.com/trampuleiro.gps/"><div id="FontAwesomeIcon7"><i class="fa fa-facebook"></i></div></a></div>
         <div id="wb_FontAwesomeIcon8">
            <a href="./index.html"><div id="FontAwesomeIcon8"><i class="fa fa-twitter"></i></div></a></div>
         <div id="wb_FontAwesomeIcon9">
            <a href="./index.html"><div id="FontAwesomeIcon9"><i class="fa fa-pinterest"></i></div></a></div>
         <div id="wb_FontAwesomeIcon10">
            <a href="./index.html"><div id="FontAwesomeIcon10"><i class="fa fa-instagram"></i></div></a></div>
         <div id="wb_Text9">
            <span style="color:#FFFFFF;font-family:Arial;font-size:19px;"><strong>REDES SÓCIAIS</strong></span></div>
         <div id="wb_FontAwesomeIcon11">
            <a href="./index.html"><div id="FontAwesomeIcon11"><i class="fa fa-youtube"></i></div></a></div>
         <div id="wb_Text11">
            <span style="color:#FFFFFF;font-family:Verdana;font-size:13px;">Sou um profissional dedicado e apaixonado pela tecnologia, com uma sólida formação em informática e experiência em desenvolvimento de software, design e manutenção de hardware. Estou sempre buscando novos desafios e oportunidades para aplicar minhas habilidades e contribuir para projetos inovadores.</span></div>
         <div id="wb_Text10">
            <span style="color:#FFFFFF;font-family:Arial;font-size:19px;"><strong>SOBRE MIM</strong></span></div>
      </div>
   </div>
   <div id="footer">
      <div id="footer_Container">
         <div id="wb_Text6">
            <span style="color:#FFFFFF;font-family:Arial;font-size:13px;">Copyright © Lima Studio 2025. All right reserved. </span></div>
      </div>
   </div>
   <div id="FullScreenLayer1">
      <div id="FullScreenLayer1_Container">
         <div id="wb_Heading1">
            <h1 id="Heading1">Projecto 1</h1></div>
         <div id="wb_Text1">
            <span style="color:#FFFFFF;font-family:Arial;font-size:13px;">Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer nec odio. Praesent libero. Sed cursus ante dapibus diam. Sed nisi. Nulla quis sem at nibh elementum imperdiet. Duis sagittis ipsum. Praesent mauris. Fusce nec tellus sed augue semper porta. Mauris massa. Vestibulum lacinia arcu eget nulla. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Curabitur sodales ligula in libero.</span></div>
         <div id="wb_CloseButton1">
            <a href="#" onclick="ShowObject('FullScreenLayer1', 0);return false;"><div id="CloseButton1"><i class="fa fa-times"></i></div></a></div>
      </div>
   </div>
   <div id="FullScreenLayer2">
      <div id="FullScreenLayer2_Container">
         <div id="wb_Heading2">
            <h1 id="Heading2">Projecto 2</h1></div>
         <div id="wb_Text2">
            <span style="color:#FFFFFF;font-family:Arial;font-size:13px;">Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer nec odio. Praesent libero. Sed cursus ante dapibus diam. Sed nisi. Nulla quis sem at nibh elementum imperdiet. Duis sagittis ipsum. Praesent mauris. Fusce nec tellus sed augue semper porta. Mauris massa. Vestibulum lacinia arcu eget nulla. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Curabitur sodales ligula in libero.</span></div>
         <div id="wb_CloseButton2">
            <a href="#" onclick="ShowObject('FullScreenLayer2', 0);return false;"><div id="CloseButton2"><i class="fa fa-times"></i></div></a></div>
      </div>
   </div>
   <div id="FullScreenLayer3">
      <div id="FullScreenLayer3_Container">
         <div id="wb_Heading3">
            <h1 id="Heading3">Project 3</h1></div>
         <div id="wb_Text3">
            <span style="color:#FFFFFF;font-family:Arial;font-size:13px;">Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer nec odio. Praesent libero. Sed cursus ante dapibus diam. Sed nisi. Nulla quis sem at nibh elementum imperdiet. Duis sagittis ipsum. Praesent mauris. Fusce nec tellus sed augue semper porta. Mauris massa. Vestibulum lacinia arcu eget nulla. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Curabitur sodales ligula in libero.</span></div>
         <div id="wb_CloseButton3">
            <a href="#" onclick="ShowObject('FullScreenLayer3', 0);return false;"><div id="CloseButton3"><i class="fa fa-times"></i></div></a></div>
      </div>
   </div>
   <script src="jquery-1.12.4.min.js"></script>
   <script src="jquery-ui.min.js"></script>
   <script src="wb.parallax.min.js"></script>
   <script src="fancybox/jquery.easing-1.3.pack.js"></script>
   <script src="fancybox/jquery.fancybox-1.3.4.pack.js"></script>
   <script src="fancybox/jquery.mousewheel-3.0.4.pack.js"></script>
   <script src="wwb20.min.js"></script>
      <script src="index.js"></script>
</body>
</html>