<생활코딩 웹>
https://opentutorials.org/course/1688/9398
<?php
$conn = mysqli_connect('localhost','root', '111111(이부분이 비밀번호!)');
$row = mysqli_Fetch_assoc($result);
echo $row['id'];
echo $row['title'];
echo "<br/>";
?>
error.log라는 파일을 atom으로 들어감
======================================================
%제목% = include 제목
%제목 = 제목으로 끝남
제목% = 제목으로 시작함
<?php
$conn = mysqli_connect('localhost','root', '') or die('db fail');
mysqli_select_db($conn, "c1");
$result = mysqli_query($conn, "SELECT * FROM article WHERE title LIKE '%제목' ORDER BY id DESC LIMIT 100");
while ( $row = mysqli_fetch_assoc($result) ) {
echo $row['id'];
echo " : ";
echo $row['title'];
echo " / ";
echo $row['regDate'];
echo "<hr>";
}
?>
<?php
$conn = mysqli_connect('localhost','root', '');
mysqli_select_db($conn, "opentutorials");
$result = mysqli_query($conn, "SELECT * FROM topic");
$row = mysqli_Fetch_assoc($result);
echo $row['id'];
echo $row['title'];
echo "<br/>";
$row = mysqli_Fetch_assoc($result);
echo $row['id'];
echo $row['title'];
echo "<br/>";
?>
<?php
$conn = mysqli_connect('localhost','root', '');
mysqli_select_db($conn, "opentutorials");
$result = mysqli_query($conn, "SELECT * FROM topic");
while ($row = mysqli_Fetch_assoc($result)) {
echo $row['id'];
echo $row['title'];
echo "<br/>";}
?>
<?php
while ($row = mysqli_Fetch_assoc($result)) {
echo '<li><a href="http://localhost/index.php?id='.$row[id].'">'.$row['title'].'</a></li>'."\n";
}
?>
==============================================
<ol>_</ol>
of(empty($_GET['id']) ===false){
$sql = 'SELECT * FROM topic WHERE id='.$_GET['id'];
$result = mysqli_query($conn, $sql);
$row = mysqli_fetch_Assoc($result);
echo '<h2>'.$row['title'].'</h2>';
echo $row['description'];
}
==============================================
text field
가 뭔지 잘 모르므로 앞에 제목을 붙여준다
<body>
<form action = "http://localhost/php/3.php" method = "GET">
<p>제목 : <input type = "text" name = "title"> </p>
<p>본문 : <textarea></textarea> </p>
<input type = "submit">
</form>
</body>
<body>
<form action = "http://localhost/php/3.php" method = "GET">
<p>제목 : <input type = "text" name = "title"> </p>
<p>본문 : <textarea name = "description"></textarea> </p>
<input type = "submit">
</form>
</body>
==============================================
실습 5 추가!!
<a href = "http"//localhost/write/php">쓰기</a>
$sql = "INSERT INTO topic(title,description,author,created)VALUES('".$_POST['title']."', '".$_POST['description']."', '".$_POST['author']."', now())";
$result = mysqli_query($conn, $sql);
header('Location: http://localhost/index.php');
?>
==============================================
http://localhost:8081/index.php
<?php
$conn = mysqli_connect('localhost','root', '');
mysqli_select_db($conn, "opentutorials");
$result = mysqli_query($conn, "SELECT * FROM topic");
while ($row = mysqli_Fetch_assoc($result)) {
echo $row['id'];
echo $row['title'];
echo "<br/>";}
?>
<?php
$conn = mysqli_connect('localhost','root','');
mysqli_select_db($conn, "opentutorials");
$result = mysqli_query($conn, "SELECT * FROM topic");
while ($row = mysqli_query(
댓글 없음:
댓글 쓰기