Notes

Stopped due to too many errors: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'name' at row 1 (Connection: mysql, SQL: insert into `member_data` (`name`, `phone`, `email`, `ins_name`, `ins_address`, `designation`, `updated_at`, `created_at`) values (",className: "text-center", }, { "data": "vTelOffice",className: "text-center", }, { "data": "status",className: "text-center", "render": function(data) { const color = data === "Died" ? "red" : "green"; return `<span style="color:${color};">${data}`; } }, { "data": null, "render": function(data, type, row, meta) { //button action to show details of member using bootstrap modal //return `<a onclick='showDetails(${meta.row})' data-toggle ><i class="bi bi-eye-fill">`; return `<a onclick='showDetails(${meta.row})' style="cursor: pointer; color:#009ef7" data-toggle ><i class="bi bi-zoom-in">`; } } ], "rowCallback": function(row, data) { if (data.status === "Died") { $(row).css("background-color", "#ffcccc"); // Light red background } } }); //console.log(url); table.ajax.url(url).load(); });, 01500000002, , , , fixed; font-family: Arial, Helvetica, sans-serif; top: 0; right: 0; bottom: 0; left: 0; background: rgba(0, 0, 0, 0.8); z-index: 99999; display: none; -webkit-transition: opacity 400ms ease-in; -moz-transition: opacity 400ms ease-in; transition: opacity 400ms ease-in; } .modalDialog:target { opacity: 1; pointer-events: auto; } .modalDialog>div { width: 60%; position: relative; margin: 10% auto; padding: 5px 20px 13px 20px; border-radius: 10px; background: #fff; background: -moz-linear-gradient(#fff, #999); background: -webkit-linear-gradient(#fff, #999); background: -o-linear-gradient(#fff, #999); } .close { background: #606061; color: #FFFFFF; line-height: 25px; position: absolute; right: -12px; text-align: center; top: -10px; width: 24px; text-decoration: none; font-weight: bold; -webkit-border-radius: 12px; -moz-border-radius: 12px; border-radius: 12px; -moz-box-shadow: 1px 1px 3px #000; -webkit-box-shadow: 1px 1px 3px #000; box-shadow: 1px 1px 3px #000; } .close:hover { background: #00d9ff; }, 2026-04-21 09:20:52, 2026-04-21 09:20:52))