rapha1908/Biograph.php Secret

## bd
DROP TABLE IF EXISTS `biographs`;
CREATE TABLE IF NOT EXISTS `biographs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `skills` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` text COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `projects`
--
INSERT INTO `biographs` (`name`, `skills`,`content`) VALUES
('Raphael Da Silva','JavaScrip, PHP, Jquery', '"At vero eos et accusamus et iusto odio dignissimos ducimus qui blanditiis praesentium voluptatum deleniti atque corrupti quos dolores et quas molestias excepturi sint occaecati cupiditate non provident, similique sunt in culpa qui officia deserunt mollitia animi, id est laborum et dolorum fuga.'),
('Kaique Mutton','Java, R , Python','Et harum quidem rerum facilis est et expedita distinctio. Nam libero tempore, cum soluta nobis est eligendi optio cumque nihil impedit quo minus id quod maxime placeat facere possimus, omnis voluptas assumenda est, omnis dolor repellendus. Temporibus autem quibusdam et aut officiis '),
('Guilherme Mendes','R , C++ , go','ed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo inventore veritatis et quasi architecto beatae vitae dicta sunt explicabo. Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni dolores eos qui ratione voluptatem sequi nesciunt. Neque porro quisquam est, qui dolorem ipsum quia dolor sit amet, consectetur, adipisci velit, sed quia non numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem. Ut enim ad minima veniam, quis nostrum exercitationem ullam corporis suscipit laboriosam, nisi ut aliquid ex ea commodi conse');

## Biograph.php
<?php

class Biographs{

    private $mysql;

    public function __construct(mysqli $mysql)
    {
        $this->mysql = $mysql;
    }

    public function showAll(): array
    {

        $result = $this->mysql->query('SELECT * FROM biographs');
        $biographs = $result->fetch_all(MYSQLI_ASSOC);

        return $biographs;
    }

    public function addBiograph(string $name, string $skills, string $content): void
    {
        $insertBiograph = $this->mysql->prepare('INSERT INTO `biographs`(`name`, `skills`, `content`) VALUES (?,?,?)');
        $insertBiograph->bind_param('sss',$name,$skills,$content);
        $insertBiograph->execute();

    }
    public function delete(string $id)
    {
      $deleteBiograph = $this->mysql->prepare('DELETE FROM `biographs` WHERE id=?');
      $deleteBiograph->bind_param('s',$id);
      $deleteBiograph->execute();

    }

    public function update(string $id , string $name, string $skills, string $content): void
    {
        $updateBiograph = $this->mysql->prepare('UPDATE `biographs` SET `name`= ?,`skills`= ?,`content`= ? WHERE `id`=?');
        $updateBiograph->bind_param('sss', $name, $skills, $content, $id);
        $updateBiograph->execute();
    }

    public function findById(String $id):array
    {
        $selectBiograph = $this->mysql->prepare('SELECT * FROM `biographs` WHERE id= ?');
        $selectBiograph->bind_param('s',$id);
        $selectBiograph->execute();
        $biograph = $selectBiograph->get_result()->fetch_assoc();
        return $biograph;
    }


}


?>

## edit.php
<?php
    require '../config.php';
    require '../src/Biographs.php';

    if($_SERVER['REQUEST_METHOD'] === 'POST'){

        $biographs = new Biographs($mysql);
        $biograph = $biographs->update($_POST['id'],$_POST['name'], $_POST['skills'], $_POST['content']);
        header('Location: index.php');
        die();

    }

    $biographs = new Biographs($mysql);
    $biograph = $biographs->findById($_GET['id']);
?>


<!DOCTYPE html>
<html lang="pt-br">

<head>
    <link rel="stylesheet" type="text/css" href="../style.css">
    <meta charset="UTF-8">
    <title>Edit bio</title>
</head>

<body>
    <div id="container">
        <h1>Edit Biograph</h1>
        <form action="edit.php" method="post">
            <p>
                <label for="name">Write your name</label>
                <input class="campo-form" type="text" name="name" id="name" value="<?php echo $biograph['name']?>"/>
            </p>
            <p>
                <label for="skills">Write yours news skills</label>
                <input class="campo-form" type="text" name="skills" id="skills" value="<?php echo $biograph['skills']?>"/>
            </p>

            <p>
                <label for="content">Write your resume</label>
                <textarea class="campo-form" type="text" name="content" id="title" rows="10" cols="50"><?php echo $biograph['content'] ?></textarea>
            </p>
            <p>
                <input type="hidden" name="id" value="<?php echo $biograph['id']?>" />
            </p>
            <p>
                <button class="botao">Editar Artigo</button>
            </p>
        </form>
    </div>
</body>

</html>
	DROP TABLE IF EXISTS `biographs`;
	CREATE TABLE IF NOT EXISTS `biographs` (
	`id` int(11) NOT NULL AUTO_INCREMENT,
	`name` text COLLATE utf8mb4_unicode_ci NOT NULL,
	`skills` text COLLATE utf8mb4_unicode_ci NOT NULL,
	`content` text COLLATE utf8mb4_unicode_ci NOT NULL,
	PRIMARY KEY (`id`)
	) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

	--
	-- Dumping data for table `projects`
	--
	INSERT INTO `biographs` (`name`, `skills`,`content`) VALUES
	('Raphael Da Silva','JavaScrip, PHP, Jquery', '"At vero eos et accusamus et iusto odio dignissimos ducimus qui blanditiis praesentium voluptatum deleniti atque corrupti quos dolores et quas molestias excepturi sint occaecati cupiditate non provident, similique sunt in culpa qui officia deserunt mollitia animi, id est laborum et dolorum fuga.'),
	('Kaique Mutton','Java, R , Python','Et harum quidem rerum facilis est et expedita distinctio. Nam libero tempore, cum soluta nobis est eligendi optio cumque nihil impedit quo minus id quod maxime placeat facere possimus, omnis voluptas assumenda est, omnis dolor repellendus. Temporibus autem quibusdam et aut officiis '),
	('Guilherme Mendes','R , C++ , go','ed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo inventore veritatis et quasi architecto beatae vitae dicta sunt explicabo. Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni dolores eos qui ratione voluptatem sequi nesciunt. Neque porro quisquam est, qui dolorem ipsum quia dolor sit amet, consectetur, adipisci velit, sed quia non numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem. Ut enim ad minima veniam, quis nostrum exercitationem ullam corporis suscipit laboriosam, nisi ut aliquid ex ea commodi conse');
	<?php

	class Biographs{

	private $mysql;

	public function __construct(mysqli $mysql)
	{
	$this->mysql = $mysql;
	}

	public function showAll(): array
	{

	$result = $this->mysql->query('SELECT * FROM biographs');
	$biographs = $result->fetch_all(MYSQLI_ASSOC);

	return $biographs;
	}

	public function addBiograph(string $name, string $skills, string $content): void
	{
	$insertBiograph = $this->mysql->prepare('INSERT INTO `biographs`(`name`, `skills`, `content`) VALUES (?,?,?)');
	$insertBiograph->bind_param('sss',$name,$skills,$content);
	$insertBiograph->execute();

	}
	public function delete(string $id)
	{
	$deleteBiograph = $this->mysql->prepare('DELETE FROM `biographs` WHERE id=?');
	$deleteBiograph->bind_param('s',$id);
	$deleteBiograph->execute();

	}

	public function update(string $id , string $name, string $skills, string $content): void
	{
	$updateBiograph = $this->mysql->prepare('UPDATE `biographs` SET `name`= ?,`skills`= ?,`content`= ? WHERE `id`=?');
	$updateBiograph->bind_param('sss', $name, $skills, $content, $id);
	$updateBiograph->execute();
	}

	public function findById(String $id):array
	{
	$selectBiograph = $this->mysql->prepare('SELECT * FROM `biographs` WHERE id= ?');
	$selectBiograph->bind_param('s',$id);
	$selectBiograph->execute();
	$biograph = $selectBiograph->get_result()->fetch_assoc();
	return $biograph;
	}


	}







	?>
	<?php
	require '../config.php';
	require '../src/Biographs.php';

	if($_SERVER['REQUEST_METHOD'] === 'POST'){

	$biographs = new Biographs($mysql);
	$biograph = $biographs->update($_POST['id'],$_POST['name'], $_POST['skills'], $_POST['content']);
	header('Location: index.php');
	die();

	}

	$biographs = new Biographs($mysql);
	$biograph = $biographs->findById($_GET['id']);
	?>




	<!DOCTYPE html>
	<html lang="pt-br">

	<head>
	<link rel="stylesheet" type="text/css" href="../style.css">
	<meta charset="UTF-8">
	<title>Edit bio</title>
	</head>

	<body>
	<div id="container">
	<h1>Edit Biograph</h1>
	<form action="edit.php" method="post">
	<p>
	<label for="name">Write your name</label>
	<input class="campo-form" type="text" name="name" id="name" value="<?php echo $biograph['name']?>"/>
	</p>
	<p>
	<label for="skills">Write yours news skills</label>
	<input class="campo-form" type="text" name="skills" id="skills" value="<?php echo $biograph['skills']?>"/>
	</p>

	<p>
	<label for="content">Write your resume</label>
	<textarea class="campo-form" type="text" name="content" id="title" rows="10" cols="50"><?php echo $biograph['content'] ?></textarea>
	</p>
	<p>
	<input type="hidden" name="id" value="<?php echo $biograph['id']?>" />
	</p>
	<p>
	<button class="botao">Editar Artigo</button>
	</p>
	</form>
	</div>
	</body>

	</html>