멋진 인생이 기록되도록 30분만 더 하자!

2015년 10월 13일 화요일

동적인 테이블 tr 추가하기

좋은 소스가 있어서 참고용으로 저장합니다

출처 :  http://stove99.tistory.com/93

<html>

<head>

    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">

    <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.6.4/jquery.min.js" type="text/javascript"></script>

    <script type="text/javascript">

        $(document).ready(function(){

            // 옵션추가 버튼 클릭시

            $("#addItemBtn").click(function(){

                // item 의 최대번호 구하기

                var lastItemNo = $("#example tr:last").attr("class").replace("item", "");

                var newitem = $("#example tr:eq(1)").clone();

                newitem.removeClass();

                newitem.find("td:eq(0)").attr("rowspan", "1");

                newitem.addClass("item"+(parseInt(lastItemNo)+1));

                $("#example").append(newitem);

            });

            // 항목추가 버튼 클릭시

            $(".addBtn").live("click", function(){

                var clickedRow = $(this).parent().parent();

                var cls = clickedRow.attr("class");

                // tr 복사해서 마지막에 추가

                var newrow = clickedRow.clone();

                newrow.find("td:eq(0)").remove();

                newrow.insertAfter($("#example ."+cls+":last"));

                // rowspan 조정

                resizeRowspan(cls);

            });

            // 삭제버튼 클릭시

            $(".delBtn").live("click", function(){

                var clickedRow = $(this).parent().parent();

                var cls = clickedRow.attr("class");

                // 각 항목의 첫번째 row를 삭제한 경우 다음 row에 td 하나를 추가해 준다.

                if( clickedRow.find("td:eq(0)").attr("rowspan") ){

                    if( clickedRow.next().hasClass(cls) ){

                        clickedRow.next().prepend(clickedRow.find("td:eq(0)"));

                    }

                }

                clickedRow.remove();

                // rowspan 조정

                resizeRowspan(cls);

            });

            // cls : rowspan 을 조정할 class ex) item1, item2, ...

            function resizeRowspan(cls){

                var rowspan = $("."+cls).length;

                $("."+cls+":first td:eq(0)").attr("rowspan", rowspan);

            }

        });

    </script>

</head>

<body>

<button id="addItemBtn">옵션추가</button>

<table id="example" border="1px">

        <tr>

            <th>옵션명</th>

            <th>항목명</th>

            <th>필수항목</th>

            <th>가격</th>

            <th>재고</th>

            <th>옵션추가</th>

        </tr>

        <tr class="item1">

            <td><input type="text" /><button class="addBtn">항목추가</button></td>

            <td><input type="text" /></td>

            <td><input type="checkbox" /></td>

            <td><input type="text" /></td>

            <td><input type="text" /></td>

            <td><button class="delBtn">삭제</button></td>

        </tr>

        <tr class="item2">

            <td><input type="text" /><button class="addBtn">항목추가</button></td>

            <td><input type="text" /></td>

            <td><input type="checkbox" /></td>

            <td><input type="text" /></td>

            <td><input type="text" /></td>

            <td><button class="delBtn">삭제</button></td>

        </tr>

        <tr class="item3">

            <td><input type="text" /><button class="addBtn">항목추가</button></td>

            <td><input type="text" /></td>

            <td><input type="checkbox" /></td>

            <td><input type="text" /></td>

            <td><input type="text" /></td>

            <td><button class="delBtn">삭제</button></td>

        </tr>

        <tr class="item4">

            <td><input type="text" /><button class="addBtn">항목추가</button></td>

            <td><input type="text" /></td>

            <td><input type="checkbox" /></td>

            <td><input type="text" /></td>

            <td><input type="text" /></td>

            <td><button class="delBtn">삭제</button></td>

        </tr>

</table>

</body>

</html>

2015년 9월 21일 월요일

라라벨 강좌 좌표

한국사람이 만든거 같은데
잘정리된듯하다
http://schoolofweb.net/laravel-5-기초-강좌-1-introduction/

2015년 9월 19일 토요일

ERROR 2002 (HY000): Can't connect to local MySQL server through socket

The post will show how to solve the above error.

Steps

– Is mysql starting properly when you run /usr/local/bin/safe_mysqld?

If so:

Verify the /tmp/mysql.sock file exists.

If not do:

mysqld stop
touch /tmp/mysql.sock

// With old brew recipes
safe_mysqld restart
// With new brew recipes
mysqld_safe restart

**Note: If mysql does not start properly after that last line:

You may need to install the tables manually using /usr/local/bin/mysql_install_db, then restart mysql

출처 :http://www.panayiotisgeorgiou.net/error-2002-hy000-cant-connect-to-local-mysql-server-through-socket-tmpmysql-sock-2/