cara bikin page buat add/delet/table table di mysql dengan Php

Beranda
Komunitas
Tech
Programmer Forum
cara bikin page buat add/delet/table table di mysql dengan Php

SkySpeed

03-06-2014 08:44

cara bikin page buat add/delet/table table di mysql dengan Php

Halo agan2 sekalian, ane mao tanya nih tentang logika kalo mao bikin add/edit/delete table di dalem php page.

jadi gini kira2 page ane bentuknya.

Spoiler for pagesaya:

jadi itu saya buat 2 page. satu buat page ngeliatnya satu buat prosesnya.

kira2 seperti ini isi kodingan page untuk ngeliatnya .

index.php

Spoiler for index.php:

Code:





include("config.inc.php");



$results = mysqli_query($connecDB,"SELECT COUNT(*) FROM `get`");

$get_total_rows = mysqli_fetch_array($results); //total records



$item_per_page = 20;

//break total records into pages

$total_pages = ceil($get_total_rows[0]/$item_per_page); 



?><!DOCTYPE html>

<html>

<head>

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

<title>Ajax Pagination</title>

[removed][removed]

[removed]

$(document).ready(function() {



 var track_click = 0; //track user click on "load more" button, righ now it is 0 click

 var total_pages = <?php echo $total_pages; ?>;

 $('#results').load("fetch_pages.php", {'page':track_click}, function() {track_click++;}); //initial data to load



 $(".load_more").click(function (e) { //user clicks on button

 

 $(this).hide(); //hide load more button on click

 $('.animation_image').show(); //show loading image



 if(track_click <= total_pages) //make sure user clicks are still less than total pages

 {

 //post page number and load returned data into result element

 $.post('fetch_pages.php',{'page': track_click}, function(data) {

 

 $(".load_more").show(); //bring back load more button

 

 $("#results").append(data); //append data received from server

 

 //scroll page to button element

 $("html, body").animate({scrollTop: $("#load_more_button").offset().top}, 500);

 

 //hide loading image

 $('.animation_image').hide(); //hide loading image once data is received

 

 track_click++; //user click increment on load button

 

 }).fail(function(xhr, ajaxOptions, thrownError) { 

 alert(thrownError); //alert any HTTP error

 $(".load_more").show(); //bring back load more button

 $('.animation_image').hide(); //hide loading image once data is received

 });

 

 

 if(track_click >= total_pages-1)

 {

 //reached end of the page yet? disable load button

 $(".load_more").attr("disabled", "disabled");

 }

 }

 

 });

});

[removed]

<link href="css/style.css" rel="stylesheet" type="text/css">

</head>

<body>

<div id="results"></div>



<div align="center">

<button class="load_more" id="load_more_button">load More</button>

<div class="animation_image" style="display:none;"><img src="ajax-loader.gif"> Loading...</div>

</div>

</body>

</html>

dimana $item_per_page saya ambil dari page includenya. yang juga terdapat dbconn nya.

dan ini isi page buat data2nya.

Spoiler for fetch_page.php:

Code:

include("config.inc.php"); //include config file



//sanitize post value

$page_number = filter_var($_POST["page"], FILTER_SANITIZE_NUMBER_INT, FILTER_FLAG_STRIP_HIGH);



//throw HTTP error if page number is not valid

if(!is_numeric($page_number)){

 header('HTTP/1.1 500 Invalid page number!');

 exit();

}



//get current starting point of records

$position = ($page_number * $item_per_page);



//Limit our results within a specified range. 

$results = mysqli_query($connecDB,"SELECT * FROM `get` ORDER BY id DESC LIMIT $position, $item_per_page");



//get the column name

$query123 = "SELECT * from `get` ORDER BY id LIMIT 1";

$rowcount = 1;



//output results from database

echo '<ul class="page_result"> <table> ';

//

//print column name

// Get field information for all columns

echo '<tr>';

echo '<td> Rownum </td>';

if ($result321 = $connecDB->query($query123)) {

 while ($row0 = $result321->fetch_field()) {

 $column_name = $row0->name;

 echo '<td>'.$column_name.'</td>';

 }

 }

echo '</tr>';

 

 

while($row = mysqli_fetch_array($results))

{

 

 echo '<tr>';

 echo '<td>'.$rowcount.'</td>';

 if ($result123 = $connecDB->query($query123)) {

 while ($row1 = $result123->fetch_field()) {

 $column_content = $row1->name;

 echo '<td>'.$row[$column_content].'</td>';

 //$column_name = $row->name;

 //printf($column_name);

 }

 

 }

 echo '</tr>';

 //echo '<li id="item_'.$row["id"].'"><span class="page_name">'.$row["id"].') '.$row["timestamp"].'</span><span class="page_message">'.$row["Hz"].'</span></li>';

 $rowcount++;

}

echo '</table></ul>';

na ane mao nambahin fungsi add/delete/edit table dari table2 yang udah terpampang.

oke fine kalo edit ane udah kebayang cara buatnya dengan cara ade bikin satu link. isinya form2 dan sebagainya, di klik dia submit query yang isinya insert into bla bla.

nah tapi kalo untuk edit dan deletenya ane masih ga dapet logikanya.

gimana cara nyamain sama row yang mao di edit, gimana ngambil id yang row mao di edit, gimana nyamainnya dengan page yang ditampilin dan gimana2 yang laen.

kira2 gini tampilan kalo pagenya udah jadi.

Spoiler for tampilan kira2:

mohon bantuannya agan2. terimakasih banyak.
emoticon-Kiss

Diubah oleh SkySpeed 03-06-2014 08:54

Kutip

Balasan

Guest

Tulis komentar menarik atau mention replykgpt untuk ngobrol seru

Urutan

Terbaru

Terlama

Guest

Tulis komentar menarik atau mention replykgpt untuk ngobrol seru

Komunitas Pilihan