\uc544\ub798\ub294 form6.php\uc640 form_action6.php\ud30c\uc77c\uc758 \ub0b4\uc6a9\uc785\ub2c8\ub2e4.
\uc774\uc804\uc5d0 \ub2e4\ub918\ub358 \ub0b4\uc6a9\uacfc \ub9ce\uc740 \ubd80\ubd84 \uc77c\uce58\ud569\ub2c8\ub2e4.
\ub370\uc774\ud130 \ubca0\uc774\uc2a4 \uc785\ub825 \ubd80\ubd84\ub9cc \uc0b4\ud3b4 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.
\ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 MYSQL\uc744 \uc0ac\uc6a9\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n
Below are the contents of the form6.php and form_action6.php files.
This is largely consistent with what we covered previously.
Let’s only look at the database input part.
The database we will use is mysql.<\/p>\n\n\n\n
1.MYSQL \ub85c\uadf8\uc778 LOGIN
new mysqli(“server host”,”username”,”password”,”databasename”); \uc774 \ubd80\ubd84\uc774 MYSQL\ub370\uc774\ud130 \ubca0\uc774\uc2a4\uc5d0 \ub85c\uadf8\uc778 \ud558\ub294 \ubd80\ubd84\uc785\ub2c8\ub2e4.
new mysqli(“server host”,”user name”,”password”,”database name”); This is where you log in to the MYSQL database.<\/p>\n\n\n\n
\/\/mysql auth\n$servername = \"localhost\";\n$username = \" \";\n$password = \" \";\n$dbname = \" \";\n\n\/\/connect mysql\n$mysqli = new mysqli($servername,$username,$password,$dbname);<\/code><\/pre>\n\n\n\n2.MYSQL ERROR CHECK
MYSQL\ub85c\uadf8\uc778\uc2dc \ub85c\uadf8\uc778\uc774 \uc2e4\ud328\ud558\uba74 \uc624\ub958 \uba54\uc138\uc9c0\ub97c \ucd9c\ub825\ud569\ub2c8\ub2e4.
When logging into MYSQL, if login fails, an error message is displayed.<\/p>\n\n\n\n
\/\/mysql error check\n if ($mysqli->connect_errno) {\n printf(\"Connect failed: %s\\n\", $mysqli->connect_error);\n exit();\n }<\/code><\/pre>\n\n\n\n3.MYSQL \uc790\ub8cc \uc785\ub825 Data input
\uc815\uc0c1\uc801\uc73c\ub85c \uc790\ub8cc\uc785\ub825\uc774 \ub418\uba74 “New record created successfully” \uba54\uc2dc\uc9c0\ub97c \ucd9c\ub825\ud569\ub2c8\ub2e4.
\uc785\ub825\uc2e4\ud328\uc2dc \uc624\ub958 \uba54\uc2dc\uc9c0\ub97c \ucd9c\ub825\ud569\ub2c8\ub2e4.
If data is entered normally, the message \u201cNew record created successfully\u201d is displayed.
If input fails, an error message is output.<\/p>\n\n\n\n
\n $sql = \"INSERT INTO testuser (name,email,title,website,pwd,comment) values('$f_name','$f_email','$f_title','$f_website','$f_pwd','$f_comment')\";\n if($mysqli->query($sql)){\n echo \"New record created successfully\";\n }else{\n printf(\"Connect failed: %s\\n\", $mysqli->connect_error);\n exit();\n };<\/code><\/pre>\n\n\n\n4.COMMENT\ucc98\ub9ac \ubd80\ubd84[CREATE TABLE] ( COMMENT PART[CREATE TABLE])
\ud14c\uc774\ube14\uc774 \uc874\uc7ac\ud558\uc9c0 \uc54a\uc744 \uacbd\uc6b0 \uc0dd\uc131\ud558\ub294 \ubd80\ubd84\uc785\ub2c8\ub2e4.
\ud544\uc694\uc2dc COMMENT\uc0ad\uc81c\ud558\uace0 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n
This is the part that creates the table if it does not exist.
If necessary, you can delete COMMENT and use it.<\/p>\n\n\n\n
\/*\n ** create table **\n $sql = \"CREATE TABLE IF NOT EXISTS testuser (\n id int(6) unsigned auto_increment primary key,\n name varchar(30) not null,\n email varchar(30) not null,\n title varchar(30) not null,\n website varchar(30) not null,\n pwd varchar(20) not null,\n comment text ); \";\n\n $mysqli->query($sql);\n *\/<\/code><\/pre>\n\n\n\n5.COMMENT\ucc98\ub9ac \ubd80\ubd84-\ud398\uc774\uc9c0 \uc774\ub3d9(COMMENT part – page movement)
\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc790\ub8cc \uc785\ub825\uc774 \uc644\ub8cc\ub418\uba74 \ud398\uc774\uc9c0 \uc774\ub3d9\ud569\ub2c8\ub2e4.
Once database data entry is complete, the page moves.<\/p>\n\n\n\n
\/\/ echo (\"<script> window.location.href = '.\/list.php'; <\/script> \");<\/code><\/pre>\n\n\n\n6.\uc804\uccb4\ucf54\ub4dc(FULL CODE)<\/p>\n\n\n\n
form6.php\n<?php\n\n$fileName = \".\/form_action6.php\";\n\nif(!is_file($fileName)){\n $form_action_name = basename($_SERVER['PHP_SELF']);\n}else{\n $form_action_name = \".\/form_action6.php\";\n}\n?>\n\n<!DOCTYPE html>\n<html>\n <head>\n <title>Bootstrap 5 webform<\/title>\n <!--\uc774 \ubd80\ubd84\uc740 html\ucf54\uba58\ud2b8 \uc601\uc5ed This part is the html comment area,\ub9c8\uc784\ud0c0\uc785\uc124\uc815 Mime type settings\/\/-->\n <meta charset=\"utf-8\">\n <!-- \ubaa8\ubc14\uc77c\ud3f0 \uc2a4\ud06c\ub9b0 \uc635\uc158 Mobile phone screen options\/\/-->\n <meta name=\"viewport\" content=\"width=device-width, initial-scale=1\">\n <!--\ubd80\ud2b8\uc2a4\ud2b8\ub7a95 CDN\ubc29\uc2dd \ub9c1\ud06c Bootstrap 5 CDN method link\/\/-->\n <link href=\"https:\/\/cdn.jsdelivr.net\/npm\/bootstrap@5.2.3\/dist\/css\/bootstrap.min.css\" rel=\"stylesheet\">\n <script src=\"https:\/\/cdn.jsdelivr.net\/npm\/bootstrap@5.2.3\/dist\/js\/bootstrap.bundle.min.js\"><\/script>\n <!-- \ud3fc\uccb4\ud06c innerHTML\uacbd\uace0 \uba54\uc2dc\uc9c0 \ucd9c\ub825 -->\n <!-- Form check innerHTML warning message output \/\/-->\n <script>\n function frmSubmit(){\n \n \/\/name input box\uc5d0\uc11c \uac12\uc744 \uac00\uc838\uc624\uae30\n \/\/Get value from name input box\n var frmName = document.getElementById(\"name\").value;\n var frmEmail = document.getElementById(\"email\").value; \n var frmWebsite = document.getElementById(\"website\").value; \n var frmTitle = document.getElementById(\"title\").value; \n var frmPwd = document.getElementById(\"pwd\").value;\n var frmComment = document.getElementById(\"comment\").value;\n\n \/\/\uc815\uaddc\ud45c\ud604\uc2dd\uacfc \ube44\uad50\ud558\uc5ec \uc774\uba54\uc77c \ubc0f url\ud14c\uc2a4\ud2b8\n \/\/Test the email and url against the regular expression\n var regex = \/^[\\w-]+(\\.[\\w-]+)*@([\\w-]+\\.)+[a-zA-Z]{2,7}$\/;\n var emailCheck = regex.test(frmEmail); \n var regexURL = \/^(https?:\\\/\\\/)?([a-z0-9-]+\\.)+[a-z]{2,7}(\\\/\\S*)?$\/i;\n var URLCheck = regexURL.test(frmWebsite);\n\n \/\/ \uc6f9\uc0ac\uc774\ud2b8\uc8fc\uc18c\uac00 \uacf5\ubc31\uc774\uba74 \ud655\uc778\ud558\uc9c0 \uc54a\uc74c.\n \/\/ If the website field is blank, it does not check.\n if(frmWebsite == \"\"){\n URLCheck = true;\n } \n\n \/\/\uc5d0\ub7ec\uba54\uc138\uc9c0 \ucd08\uae30\ud654\n \/\/Reset error message\n errorName.innerHTML = \"\";\n errorEmail.innerHTML = \"\"; \n errorPwd.innerHTML = \"\";\n errorWebsite.innerHTML = \"\";\n errorTitle.innerHTML = \"\";\n errorComment.innerHTML = \"\";\n \n \/\/\uac12\uc758 \uc874\uc7ac \uc5ec\ubd80\uccb4\ud06c ,\uacf5\ubc31\uc774\uba74 \uacbd\uace0\ucc3d \ub744\uc6b0\uae30\n \/\/Check whether value exists, if blank, display warning window\n if(frmName == \"\"){\n errorName.innerHTML =\"<p>\uc774\ub984\uc744 \uc785\ub825\ud558\uc138\uc694(Please Enter Your Name)<\/p>\";\n return;\n }else if(frmEmail == \"\"){\n errorEmail.innerHTML =\"<p>Email\uc744 \uc785\ub825\ud558\uc138\uc694(Please Enter Your Email)<\/p>\";\n return;\n }else if(emailCheck == false){ \n errorEmail.innerHTML =\"<p>\uc815\ud655\ud55c Email\uc744 \uc785\ub825\ud558\uc138\uc694(Please enter the correct Email)<\/p>\"; \n return; \n }else if(URLCheck == false){ \n errorWebsite.innerHTML =\"<p>\uc815\ud655\ud55c URL\uc744 \uc785\ub825\ud558\uc138\uc694(Please enter the correct URL)<\/p>\"; \n return; \n }else if(frmTitle == \"\"){\n errorTitle.innerHTML =\"<p>\uc81c\ubaa9\uc744 \uc785\ub825\ud558\uc138\uc694(Please enter the post title)<\/p>\";\n return; \n }else if(frmPwd == \"\"){\n errorPwd.innerHTML =\"<p>\ud328\uc2a4\uc6cc\ub4dc\ub97c \uc785\ub825\ud558\uc138\uc694(Please Enter Your Password)<\/p>\";\n return;\n }else if(frmComment == \"\"){\n errorComment.innerHTML =\"<p>\uae00\ub0b4\uc6a9\uc744 \uc785\ub825\ud558\uc138\uc694(Please Enter The post content)<\/p>\";\n return; \n }else{\n frm.submit();\n }\n }\n <\/script>\n <\/head>\n <body> \n <div class=\"container-sm\"> \n <form id=\"frm\" action=\"<?php echo $form_action_name; ?>\" method=\"post\">\n <div class=\"mb-3\">\n <label for=\"name\" class=\"form-label\">\uc774\ub984(Name):<\/label>\n <input type=\"text\" class=\"form-control\" id=\"name\" placeholder=\"\ub2f9\uc2e0\uc758 \uc774\ub984\uc744 \uc785\ub825\ud558\uc138\uc694(Pleas enter your name)\" name=\"name\" required>\n <div id=\"errorName\"><\/div>\n <\/div>\n\n <div class=\"mb-3\">\n <label for=\"email\" class=\"form-label\">Email:<\/label>\n <input type=\"text\" class=\"form-control\" id=\"email\" placeholder=\"ID@exmale.com\" name=\"email\" required>\n <div id=\"errorEmail\"><\/div>\n <\/div>\n\n <div class=\"mb-3\">\n <label for=\"website\" class=\"form-label\">Website:<\/label>\n <input type=\"text\" class=\"form-control\" id=\"website\" placeholder=\"example.com\" name=\"website\">\n <div id=\"errorWebsite\"><\/div> \n <\/div>\n \n <div class=\"mb-3\">\n <label for=\"pwd\" class=\"form-label\">Title:<\/label>\n <input type=\"text\" class=\"form-control\" id=\"title\" placeholder=\"\uc81c\ubaa9\uc744 \uc785\ub825\ud558\uc138\uc694(Please enter the post title)\" name=\"title\" required>\n <div id=\"errorTitle\"><\/div>\n <\/div>\n\n <div class=\"mb-3\">\n <label for=\"pwd\" class=\"form-label\">Password:<\/label>\n <input type=\"password\" class=\"form-control\" id=\"pwd\" placeholder=\"Enter password\" name=\"pswd\" required>\n <div id=\"errorPwd\"><\/div>\n <\/div> \n\n <div class=\"mb-3\">\n <label for=\"comment\" class=\"form-label\">Comment:<\/label> \n <textarea id=\"comment\"name=\"comment\" rows=\"5\" cols=\"40\" class=\"form-control\"><\/textarea>\n <div id=\"errorComment\"><\/div>\n <\/div>\n\n <div class=\"mb-3\">\n <div class=\"form-check mb-3\">\n <label class=\"form-check-label\">Remember me<\/label>\n <input class=\"form-check-input\" type=\"checkbox\" name=\"remember\">\n <\/div>\n <\/div>\n <button type=\"button\" class=\"btn btn-primary\" onClick=\"frmSubmit();\">Submit<\/button>\n <\/form>\n <\/div> \n <\/body>\n<\/html> <\/code><\/pre>\n\n\n\nform_action6.php\n\n<?php \n\nif($_SERVER['REQUEST_METHOD'] == \"POST\"){\n\n $f_name = $_POST['name'];\n $f_pwd = $_POST['pswd'];\n $f_email = $_POST['email'];\n $f_title = $_POST['title'];\n $f_website = $_POST['website'];\n $f_comment = $_POST['comment'];\n\n \/\/ post data blank check\n if($f_name == \"\"){\n echo (\"<script>\n alert('\uc774\ub984\uc744 \uc785\ub825\ud558\uc138\uc694(Please Enter Your Name).');\n window.location.href = '.\/form5-1.php';\n <\/script>\n \");\n exit; \n }else if($f_email == \"\"){ \n echo (\"<script>\n alert('Email\uc744 \uc785\ub825\ud558\uc138\uc694(Please Enter Your Email).');\n window.location.href = '.\/form5-1.php';\n <\/script>\n \");\n exit; \n }else if($f_title == \"\"){ \n echo (\"<script>\n alert('\uae00 \uc81c\ubaa9\uc744 \uc785\ub825\ud558\uc138\uc694(Please Enter Your Post Title).');\n window.location.href = '.\/form5-1.php';\n <\/script>\n \");\n exit; \n }else if($f_comment == \"\"){\n echo (\"<script>\n alert('\uae00\ub0b4\uc6a9\uc744 \uc785\ub825\ud558\uc138\uc694(Please Enter The post content).');\n window.location.href = '.\/form5-1.php';\n <\/script>\n \");\n exit; \n }else if($f_pwd == \"\"){\n echo (\"<script>\n alert('\ud328\uc2a4\uc6cc\ub4dc\ub97c \uc785\ub825\ud558\uc138\uc694(Please Enter Your Password).');\n window.location.href = '.\/form5-1.php';\n <\/script>\n \");\n exit; \n } \n\n \/\/ email check\n if (!preg_match(\"\/^[\\w-]+(\\.[\\w-]+)*@([\\w-]+\\.)+[a-zA-Z]{2,7}$\/\",$f_email)) {\n echo (\"<script>\n alert('\uc815\ud655\ud55c Email\uc744 \uc785\ub825\ud558\uc138\uc694(Please enter the correct Email).');\n window.location.href = '.\/form5-1.php';\n <\/script>\n \");\n exit;\n }\n \/\/ URL check\n if ($f_website != \"\" && !preg_match(\"\/^(https?:\\\/\\\/)?([a-z0-9-]+\\.)+[a-z]{2,7}(\\\/\\S*)?$\/i\",$f_website)) {\n echo (\"<script>\n alert('\uc815\ud655\ud55c URL\uc744 \uc785\ub825\ud558\uc138\uc694(Please enter the correct URL).');\n window.location.href = '.\/form5-1.php';\n <\/script>\n \");\n exit;\n }\n\n}\n\n \/\/ post data\n\n echo \"REQUEST_METHOD:\".$_SERVER['REQUEST_METHOD'].\"<br>\";\n echo \"\uc774\ub984(NAME):\".$f_name.\"<br>\";\n echo \"\uc774\uba54\uc77c(EMAIL):\".$f_email.\"<br>\";\n echo \"\uc81c\ubaa9(TITLE):\".$f_title.\"<br>\";\n echo \"\uc6f9\uc0ac\uc774\ud2b8(WEBSITE):\".$f_website.\"<br>\";\n echo \"\uae00 \ub0b4\uc6a9(CONTENT):\".$f_comment.\"<br>\";\n echo \"\ud328\uc2a4\uc6cc\ub4dc(PASSWORD):\".$f_pwd;\n\n \/\/mysql auth\n $servername = \"localhost\";\n $username = \" \";\n $password = \" \";\n $dbname = \" \";\n \n <\/mark> \/\/connect mysql\n $mysqli = new mysqli($servername,$username,$password,$dbname);\n \n<\/mark> \/\/mysql error check\n if ($mysqli->connect_errno) {\n printf(\"Connect failed: %s\\n\", $mysqli->connect_error);\n exit();\n }<\/mark>\n\n \/*\n ** create table **\n $sql = \"CREATE TABLE IF NOT EXISTS testuser (\n id int(6) unsigned auto_increment primary key,\n name varchar(30) not null,\n email varchar(30) not null,\n title varchar(30) not null,\n website varchar(30) not null,\n pwd varchar(20) not null,\n comment text ); \";\n\n $mysqli->query($sql);\n *\/<\/mark>\n\n $sql = \"INSERT INTO testuser (name,email,title,website,pwd,comment) values('$f_name','$f_email','$f_title','$f_website','$f_pwd','$f_comment')\";\n if($mysqli->query($sql)){\n echo \"New record created successfully\";\n }else{\n printf(\"Connect failed: %s\\n\", $mysqli->connect_error);\n exit();\n };<\/mark>\n\n \/\/ echo (\"<script> window.location.href = '.\/list.php'; <\/script> \");<\/mark>\n\n?><\/code><\/pre>\n\n\n\n\uc601\uc0c1\uc5d0 \uc0ac\uc6a9\ub41c sql\uba85\ub839\uc5b4(sql command used in video)<\/p>\n\n\n\n
mysql log in : mysql -u mysqlID -p mysql database name;
\ud14c\uc774\ube14\ubcf4\uae30 : show tables;
\ud14c\uc774\ube14 \uad6c\uc870\ubcf4\uae30(View table structure) : desc tablename;
\ucd5c\uc2e0 \ub370\uc774\ud130 1\uac1c\ub9cc \uac80\uc0c9(Search for only 1 recent data) : select * from <tablename> order by <primary key> desc limit 1; <\/p>\n\n\n\n