도와주세요 정보
도와주세요본문
그누보드와 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
왜 이런거죠? 도와주세요 ㅠㅠ
댓글 전체
위의 프로그램 폴더에 _common.php 파일이 없다고 합니다.
/host/home/ago99999/html/pbank4gnu
/host/home/ago99999/html/pbank4gnu
말씀하신대로 _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
SQL 문법이 틀렸다고 합니다.
프로그램이 잘못되어 있는듯 한데요?
프로그램이 잘못되어 있는듯 한데요?
$sql .= ' cp_id varchar(10), ';
$sql .= ' reg_date datetime ';
$sql .= ' chkurl varchar(100), ';
====>
$sql .= ' cp_id varchar(10), ';
$sql .= ' reg_date datetime, ';
$sql .= ' chkurl varchar(100), ';
$sql .= ' reg_date datetime ';
$sql .= ' chkurl varchar(100), ';
====>
$sql .= ' cp_id varchar(10), ';
$sql .= ' reg_date datetime, ';
$sql .= ' chkurl varchar(100), ';
감사합니다^^