mac에서 php를 통해서 mysql에 삽입하기
//
// ViewController.swift
// Relax2
//
// Created by MacBookPro on 2017. 12. 19..
// Copyright © 2017년 MacBookPro. All rights reserved.
//
import UIKit
class ViewController: UIViewController {
@IBOutlet weak var firstName: UITextField!
@IBOutlet weak var lastName: UITextField!
@IBAction func button(_ sender: UIButton) {
let request = NSMutableURLRequest(url: NSURL(string: "http://localhost/wow3.php")! as URL)
request.httpMethod = "POST"
let postString = "a=\(firstName.text!)&b=\(lastName.text!)"
request.httpBody = postString.data(using: String.Encoding.utf8)
let task = URLSession.shared.dataTask(with: request as URLRequest) {
data, response, error in
if error != nil {
print("error=\(String(describing: error))")
return
}
print("response = \(String(describing: response))")
let responseString = NSString(data: data!, encoding: String.Encoding.utf8.rawValue)
print("responseString = \(String(describing: responseString))")
}
task.resume()
}
override func viewDidLoad() {
super.viewDidLoad()
// Do any additional setup after loading the view, typically from a nib.
}
override func didReceiveMemoryWarning() {
super.didReceiveMemoryWarning()
// Dispose of any resources that can be recreated.
}
}
php mysql_connect() 이용!
<?php
$host='localhost';
$user='root';
$password='비번';
$connection = mysql_connect($host,$user,$password);
$name = $_REQUEST['a'];
$age = $_REQUEST['b'];
if(!$connection){
die('Connection Failed');
}
else{
$dbconnect = @mysql_select_db('wow', $connection);
if(!$dbconnect){
die('Could not connect to Database');
}
else{
$query = "INSERT INTO test (name, age)
VALUES ('$name','$age');";
mysql_query("set session character_set_connection=utf8;") ;
mysql_query("set session character_set_result=utf8;");
mysql_query("set session character_set_client=utf8;");
mysql_query($query, $connection) or die(mysql_error());
echo 'Successfully added.';
echo $query;
}
}
?>
php mysqli_connect() 이용!
<?php
$connect = mysqli_connect("localhost", "root", "1111","wow");
mysqli_set_charset($connect, 'utf8');
$name = $_REQUEST['a'];
$age = $_REQUEST['b'];
$query = "INSERT INTO test (name, age)
VALUES ('$name','$age');";
mysqli_query($connect, $query);
echo '성공적으로 입력 되었습니다.';
?>
한글문제는
결과
이번에는 php화면단, 즉 웹에서 mysql 로 삽입하기
php 화면단 소스~!
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags -->
<title>crud</title>
<!-- jQuery (necessary for Bootstrap's JavaScript plugins) -->
<script src="https://code.jquery.com/jquery-3.1.1.min.js"> </script>
<!-- Bootstrap -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0-beta.2/css/bootstrap.min.css" integrity="sha384-PsH8R72JQ3SOdhVi3uxftmaW6Vc51MKb0q5P2rRUpPvrszuE4W1povHYgTpBfshb" crossorigin="anonymous">
<!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries -->
<!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
<!--[if lt IE 9]>
<script src="https://oss.maxcdn.com/html5shiv/3.7.3/html5shiv.min.js"></script>
<script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
<![endif]-->
<style>
body{
margin:0;
padding:0;
background-color:#f1f1f1;
}
.box{
width:750px;
padding:20px;
background-color:#fff;
border:1px solid #ccc;
border-radius:5px;
margin-top:100px;
}
</style>
</head>
<body>
<div class="container box">
<h3 align="center">php Ajax Crud</h3>
<br/><br/>
<br/><br/>
<label>성을 입력하세요</label>
<input type="text" name="first_name" id="first_name" class="form-control" />
<br/>
<label>이름을 입력하세요</label>
<input type="text" name="last_name" id="last_name" class="form-control" />
<br/><br/>
<div align="center">
<!-- 클릭했을 때 user id를 알 수 있게 숨겨 둔다.-->
<input type="hidden" name="id" id="user_id" />
<button type="button" name="action" id="action" class="btn btn-warning">추가</button>
</div>
<br/><br/>
<!-- ++++++++++++++++++결과 리스트 출력 테이블++++++++++++++++++++++++ -->
<!-- select.php에서 받아온 데이터를 이곳에다가 붙인다. -->
<div id="result" class="table-responsive">
</div>
</div>
</body>
<script>
$(document).ready(function(){
//[2] 추가 버튼 클릭했을 때 작동되는 함수
$('#action').click(function(){
//각 엘리먼트들의 데이터 값을 받아온다.
var a = $('#first_name').val();
var b = $('#last_name').val();
//성과 이름이 올바르게 입력이 되면
if(a !='' && b != ''){
$.ajax({
//insert page로 위에서 받은 데이터를 넣어준다.
url:"wow4.php",
method:"POST",
data:{a:a,b:b},
success:function(data){
//성공하면 action.php 에서 출력된 데이터가 넘어온다.
alert(data);
}
});
}else
{
alert('빈칸을 입력해 주세요');
}
});
});
</script>
<!-- jQuery (necessary for Bootstrap's JavaScript plugins) -->
<!-- Include all compiled plugins (below), or include individual files as needed -->
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.12.3/umd/popper.min.js" integrity="sha384-vFJXuSJphROIrBnz7yo7oB41mKfc8JzQZiCq4NCceLEaO4IHwicKwpJf9c9IpFgh" crossorigin="anonymous"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0-beta.2/js/bootstrap.min.js" integrity="sha384-alpBpkh1PFOepccYVYDB4do5UnbKysX5WZXm3XxPqe5iKTfUKjNkCk9SaVuEZflJ" crossorigin="anonymous"></script>
</body>
</html>
댓글