글쓰기 링크 link 삽입 추가 늘리기 / 추가하기 하여 유투브 추가 연습/링크 주소 입력 개수 늘리는 방법
이전
다음
링크
첨부
등록일
2021.08.06 01:36
본문
글쓰기 링크 link 삽입 추가 늘리기 / 추가하기 하여 유투브 추가 연습/링크 주소 입력 개수 늘리는 방법
1) config.php 수정
define('G5_LINK_COUNT', 5); ( 2--> 5 )
PHPMYADMIN 수정 않하면 상기와같이 저장 이 되지 않습니다
2) phpmyadmin 수정
글쓰기 링크 link 삽입 늘리기 / 추가하기
목표) wr_link3 wr_link4 wr_link5 를 3개 추가 예정입니다.
방법 )3개 추가 (wr_link2 뒤애) ,이름입력난에 wr_link3 wr_link4 wr_link5 입력 text 와 utf8_general_ci 선택 변경
완료) 저장
반복적인 진행은 한번 만들때 복사 메모장에 복사 합니다
한 테이블당 SQL 소스 입니다
텡이블 이름 수정 실행 하세요
ALTER TABLE `g4_write_co2` ADD `wr_link3` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `wr_link2`, ADD `wr_link4` TEXT CHARACTER SET ucs2 COLLATE ucs2_general_ci NOT NULL AFTER `wr_link3`, ADD `wr_link5` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `wr_link4`;
ALTER TABLE `g4_write_co2` ADD `wr_link3_hit` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `wr_link2`, ADD `wr_link4_hit` TEXT CHARACTER SET ucs2 COLLATE ucs2_general_ci NOT NULL AFTER `wr_link3`, ADD `wr_link5_hit` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `wr_link4_hit`;
모두 정상적인 수정후 저장 뷰모드 입니다
한번에 테리블 아이디 확인 추가 편집 실행 합니다
에러시 에러부분이후 실행
----------
3.업데이트 저장 방법
\write_update.skin.php 을 추가및 생성 해야 합니다
https://11q.kr/www/bbs/board.php?bo_table=co4&wr_id=630
\\192.168.0.6\web\www\skin\board\11q_kr_pdf_office_cmt_file_calender_list_skin_board_V41★\write_update.skin.php
<?php
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가
$sql = " update $write_table
set wr_link3 = '$wr_link3',
wr_link4 = '$wr_link4',
wr_link5 = '$wr_link5'
where wr_id = '$wr_id' ";
sql_query($sql);
?>
<!-- W:\www\skin\board\11q_kr_pdf_office_cmt_file_calender_list_skin_board_V41★\write_update.skin.php -->
<!-- https://gnustudy.com/bbs/board.php?bo_table=skin_board&wr_id=66&sfl=wr_subject%7C%7Cwr_content&stx=link3&sop=and -->
관련자료
-
링크
-
첨부등록일 2021.08.06 01:36
-
이전
-
다음
댓글 3
11qkr님의 댓글
ALTER TABLE `g4_write_co2` ADD `wr_link3` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `wr_link2`, ADD `wr_link4` TEXT CHARACTER SET ucs2 COLLATE ucs2_general_ci NOT NULL AFTER `wr_link3`, ADD `wr_link5` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `wr_link4`;
ALTER TABLE `g4_write_co2` ADD `wr_link3_hit` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `wr_link2`, ADD `wr_link4_hit` TEXT CHARACTER SET ucs2 COLLATE ucs2_general_ci NOT NULL AFTER `wr_link3`, ADD `wr_link5_hit` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `wr_link4_hit`;
ALTER TABLE `g4_write_co2` ADD `wr_link3_hit` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `wr_link2`, ADD `wr_link4_hit` TEXT CHARACTER SET ucs2 COLLATE ucs2_general_ci NOT NULL AFTER `wr_link3`, ADD `wr_link5_hit` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `wr_link4_hit`;
11qkr님의 댓글
ALTER TABLE `g4_write_co2` ADD `wr_link3` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `wr_link2`, ADD `wr_link4` TEXT CHARACTER SET ucs2 COLLATE ucs2_general_ci NOT NULL AFTER `wr_link3`, ADD `wr_link5` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `wr_link4`;
ALTER TABLE `g4_write_co2` ADD `wr_link3_hit` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `wr_link2`, ADD `wr_link4_hit` TEXT CHARACTER SET ucs2 COLLATE ucs2_general_ci NOT NULL AFTER `wr_link3`, ADD `wr_link5_hit` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `wr_link4_hit`;
11qkr님의 댓글
ALTER TABLE `g4_write_s21` ADD `wr_link3` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `wr_link2`, ADD `wr_link4` TEXT CHARACTER SET ucs2 COLLATE ucs2_general_ci NOT NULL AFTER `wr_link3`, ADD `wr_link5` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `wr_link4`;
ALTER TABLE `g4_write_s21` ADD `wr_link3_hit` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `wr_link2`, ADD `wr_link4_hit` TEXT CHARACTER SET ucs2 COLLATE ucs2_general_ci NOT NULL AFTER `wr_link3`, ADD `wr_link5_hit` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `wr_link4_hit`;
ALTER TABLE `g4_write_s21` ADD `wr_link3_hit` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `wr_link2`, ADD `wr_link4_hit` TEXT CHARACTER SET ucs2 COLLATE ucs2_general_ci NOT NULL AFTER `wr_link3`, ADD `wr_link5_hit` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `wr_link4_hit`;