그누보드와 p뱅킹을 연동하려고합니다.
테이블 생성파일인거같은데 업로드하고 보니 에러가납니다.
<?
include '_common.php';
$sql = 'CREATE TABLE '.$cb_DBprefix.'Bank_Cash (';
$sql .= ' idx timestamp NOT NULL, ';
$sql .= ' trans_id varchar(50) NOT NULL, ';
$sql .= ' good_code varchar(50), ';
$sql .= ' good_name varchar(50), ';
$sql .= ' usr_id varchar(50) NOT NULL, ';
$sql .= ' usr_memo varchar(50), ';
$sql .= ' pay_pg varchar(5), ';
$sql .= ' pay_price int NOT NULL default 0, ';
$sql .= ' pb_usrid varchar(10), ';
$sql .= ' pb_abook varchar(15), ';
$sql .= ' pb_bbook varchar(15), ';
$sql .= ' add_data3 varchar(255), ';
$sql .= ' add_data4 varchar(255), ';
$sql .= ' add_data5 varchar(255), ';
$sql .= ' add_data6 varchar(255), ';
$sql .= ' add_data7 varchar(255), ';
$sql .= ' add_data8 varchar(255), ';
$sql .= ' add_data9 varchar(255), ';
$sql .= ' cp_id varchar(10), ';
$sql .= ' reg_date datetime ';
$sql .= ' chkurl varchar(100), ';
$sql .= ' PRIMARY KEY (idx) )';
$result = sql_query($sql);
echo "<script>alert('Cash 테이블 생성 완료~~ (~^ㅠ^)~♡ 짜미 됴아??');location.href='".$cb_path."';</script>";
?>
웹에서 보면 이런 에러가납니다.
Warning: include(_common.php) [function.include]: failed to open stream: No such file or directory in /host/home/ago99999/html/pbank4gnu/mkcashtable.php on line 2
Warning: include(_common.php) [function.include]: failed to open stream: No such file or directory in /host/home/ago99999/html/pbank4gnu/mkcashtable.php on line 2
Warning: include() [function.include]: Failed opening '_common.php' for inclusion (include_path='.:/usr/local/lib/php') in /host/home/ago99999/html/pbank4gnu/mkcashtable.php on line 2
Fatal error: Call to undefined function sql_query() in /host/home/ago99999/html/pbank4gnu/mkcashtable.php on line 27
왜 이런거죠? 도와주세요 ㅠㅠ
테이블 생성파일인거같은데 업로드하고 보니 에러가납니다.
<?
include '_common.php';
$sql = 'CREATE TABLE '.$cb_DBprefix.'Bank_Cash (';
$sql .= ' idx timestamp NOT NULL, ';
$sql .= ' trans_id varchar(50) NOT NULL, ';
$sql .= ' good_code varchar(50), ';
$sql .= ' good_name varchar(50), ';
$sql .= ' usr_id varchar(50) NOT NULL, ';
$sql .= ' usr_memo varchar(50), ';
$sql .= ' pay_pg varchar(5), ';
$sql .= ' pay_price int NOT NULL default 0, ';
$sql .= ' pb_usrid varchar(10), ';
$sql .= ' pb_abook varchar(15), ';
$sql .= ' pb_bbook varchar(15), ';
$sql .= ' add_data3 varchar(255), ';
$sql .= ' add_data4 varchar(255), ';
$sql .= ' add_data5 varchar(255), ';
$sql .= ' add_data6 varchar(255), ';
$sql .= ' add_data7 varchar(255), ';
$sql .= ' add_data8 varchar(255), ';
$sql .= ' add_data9 varchar(255), ';
$sql .= ' cp_id varchar(10), ';
$sql .= ' reg_date datetime ';
$sql .= ' chkurl varchar(100), ';
$sql .= ' PRIMARY KEY (idx) )';
$result = sql_query($sql);
echo "<script>alert('Cash 테이블 생성 완료~~ (~^ㅠ^)~♡ 짜미 됴아??');location.href='".$cb_path."';</script>";
?>
웹에서 보면 이런 에러가납니다.
Warning: include(_common.php) [function.include]: failed to open stream: No such file or directory in /host/home/ago99999/html/pbank4gnu/mkcashtable.php on line 2
Warning: include(_common.php) [function.include]: failed to open stream: No such file or directory in /host/home/ago99999/html/pbank4gnu/mkcashtable.php on line 2
Warning: include() [function.include]: Failed opening '_common.php' for inclusion (include_path='.:/usr/local/lib/php') in /host/home/ago99999/html/pbank4gnu/mkcashtable.php on line 2
Fatal error: Call to undefined function sql_query() in /host/home/ago99999/html/pbank4gnu/mkcashtable.php on line 27
왜 이런거죠? 도와주세요 ㅠㅠ
댓글 5개
말씀하신대로 _common파일이 있는대에 파일을 넣었는데요 이번에는 이런에러가나네요 ㅠㅠ
CREATE TABLE Bank_Cash ( idx timestamp NOT NULL, trans_id varchar(50) NOT NULL, good_code varchar(50), good_name varchar(50), usr_id varchar(50) NOT NULL, usr_memo varchar(50), pay_pg varchar(5), pay_price int NOT NULL default 0, pb_usrid varchar(10), pb_abook varchar(15), pb_bbook varchar(15), add_data3 varchar(255), add_data4 varchar(255), add_data5 varchar(255), add_data6 varchar(255), add_data7 varchar(255), add_data8 varchar(255), add_data9 varchar(255), cp_id varchar(10), reg_date datetime chkurl varchar(100), PRIMARY KEY (idx) )
1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'chkurl varchar(100), PRIMARY KEY (idx) )' at line 1
error file : /mkcashtable.php
CREATE TABLE Bank_Cash ( idx timestamp NOT NULL, trans_id varchar(50) NOT NULL, good_code varchar(50), good_name varchar(50), usr_id varchar(50) NOT NULL, usr_memo varchar(50), pay_pg varchar(5), pay_price int NOT NULL default 0, pb_usrid varchar(10), pb_abook varchar(15), pb_bbook varchar(15), add_data3 varchar(255), add_data4 varchar(255), add_data5 varchar(255), add_data6 varchar(255), add_data7 varchar(255), add_data8 varchar(255), add_data9 varchar(255), cp_id varchar(10), reg_date datetime chkurl varchar(100), PRIMARY KEY (idx) )
1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'chkurl varchar(100), PRIMARY KEY (idx) )' at line 1
error file : /mkcashtable.php
게시글 목록
| 번호 | 제목 |
|---|---|
| 284438 | |
| 284437 | |
| 284435 | |
| 284430 | |
| 284420 | |
| 284417 | |
| 284409 | |
| 284401 | |
| 284399 | |
| 284397 | |
| 284380 | |
| 284378 | |
| 284371 | |
| 284370 | |
| 284366 | |
| 284364 | |
| 284360 | |
| 284357 | |
| 284355 | |
| 284354 |
댓글 작성
댓글을 작성하시려면 로그인이 필요합니다.
로그인하기