PHP Help!!!

isurutmv · Sep 20, 2017

mcn mata one me table eke thiyena edit button eka click karama ee row eke thiyena data pahala form ekata load karanna

meka karanne kohomada bn

pramix2011 · Sep 20, 2017

same page or different page?

Hora_Nariya · Sep 20, 2017

BUMP

isurutmv · Sep 20, 2017

pramix2011 said:
same page or different page?

different page mcn

CorD SaC · Sep 20, 2017

ටේබල් එක generate කරගනින් ID එකත් එක්ක..ඒ ID එක පාස් කරපන parameter එකක් විදිහට EDit.php කියන එකට හරි..ටේබල් එක generate කරපු php ෆයිල් එකේම හරි(උඹේ අවශ්‍යතාව අනුව)

PHP:

	while($row = mysqli_fetch_assoc($select_posts)){

		$id = $row['id'];		
		$name =  $row['name'];
		$nic = $row['nic'];
		$add = $row['address'];

		
				
		echo "<tr>";
		echo "<td>$id</td>";
		echo "<td>$name</td>";
		echo "<td>$nic</td>";
		echo "<td>$add</td>";
		echo "<td><a href='EDit.php?id={$id}'>Edit</a></td>";;
		echo "</tr>";
	}

ඊට පස්සේ මේ තියෙන්නේ EDit.php කියන එක.

PHP:

	if(isset($_GET['id'])){
		
		$id = $_GET['id'];
		
	}
	

	$stmt = $connection->prepare("SELECT * FROM user WHERE id = ?");
	$stmt->bind_param('s',$id);
	$stmt->execute(); 
	$result = $stmt->get_result();
	
	
	if($result->num_rows > 0) {
	while($row = $result-> fetch_assoc()){
		
		$id =  $row['id'];
		$name =  $row['name'];
		$add = $row['address'];

		
	}
	}else{
		$name =  '';
		$add = '';
		
	}
	$stmt->close();
	
	<form action = "" method = "post" enctype="multipart/form-data">

			<div class="form-group">
			<label for="post-category">Name</label>
			<input value="<?php echo $name; ?>" name="name" class="form-control input-sm" placeholder="name" type="text">
		</div>		
		<div class="form-group">
			<label for="post-category">NIC</label>
			<input value="<?php echo $add; ?>" name="nic" class="form-control input-sm" placeholder="nic" type="text">
		</div>
	</form>

ඒකෙදි උඹ අර පාස් කරපු ID එකට අදාල ඩේටා ටේබල් එකෙන් ගන්නවා..ඒ අරගෙන ඒ values variables වලට assign කරලා..variable values form එකට සෙට් කරනවා

isurutmv · Sep 20, 2017

CorD SaC said:
ටේබල් එක generate කරගනින් ID එකත් එක්ක..ඒ ID එක පාස් කරපන parameter එකක් විදිහට EDit.php කියන එකට හරි..ටේබල් එක generate කරපු php ෆයිල් එකේම හරි(උඹේ අවශ්‍යතාව අනුව)

PHP:

while($row = mysqli_fetch_assoc($select_posts)){ $id = $row['id']; $name = $row['name']; $nic = $row['nic']; $add = $row['address']; echo "<tr>"; echo "<td>$id</td>"; echo "<td>$name</td>"; echo "<td>$nic</td>"; echo "<td>$add</td>"; echo "<td><a href='EDit.php?id={$id}'>Edit</a></td>";; echo "</tr>"; }

ඊට පස්සේ මේ තියෙන්නේ EDit.php කියන එක.

PHP:

if(isset($_GET['id'])){ $id = $_GET['id']; } $stmt = $connection->prepare("SELECT * FROM user WHERE id = ?"); $stmt->bind_param('s',$id); $stmt->execute(); $result = $stmt->get_result(); if($result->num_rows > 0) { while($row = $result-> fetch_assoc()){ $id = $row['id']; $name = $row['name']; $add = $row['address']; } }else{ $name = ''; $add = ''; } $stmt->close(); <form action = "" method = "post" enctype="multipart/form-data"> <div class="form-group"> <label for="post-category">Name</label> <input value="<?php echo $name; ?>" name="name" class="form-control input-sm" placeholder="name" type="text"> </div> <div class="form-group"> <label for="post-category">NIC</label> <input value="<?php echo $add; ?>" name="nic" class="form-control input-sm" placeholder="nic" type="text"> </div> </form>

ඒකෙදි උඹ අර පාස් කරපු ID එකට අදාල ඩේටා ටේබල් එකෙන් ගන්නවා..ඒ අරගෙන ඒ values variables වලට assign කරලා..variable values form එකට සෙට් කරනවා

Thanks mcn rep++ :love:

Arrow11 · Sep 20, 2017

oya database ekenam thiyenne jqery post eketh kelinma genna gannawa mannam..interface eke witarak thiyana ewanam wenama variable ekata assign karala genna gannawa :baffled:

CorD SaC · Sep 20, 2017

isurutmv said:
Thanks mcn rep++

වැඩද? අවුලක් උනොත් අහන්ඩ

isurutmv · Sep 20, 2017

CorD SaC said:
ටේබල් එක generate කරගනින් ID එකත් එක්ක..ඒ ID එක පාස් කරපන parameter එකක් විදිහට EDit.php කියන එකට හරි..ටේබල් එක generate කරපු php ෆයිල් එකේම හරි(උඹේ අවශ්‍යතාව අනුව)

PHP:

while($row = mysqli_fetch_assoc($select_posts)){ $id = $row['id']; $name = $row['name']; $nic = $row['nic']; $add = $row['address']; echo "<tr>"; echo "<td>$id</td>"; echo "<td>$name</td>"; echo "<td>$nic</td>"; echo "<td>$add</td>"; echo "<td><a href='EDit.php?id={$id}'>Edit</a></td>";; echo "</tr>"; }

ඊට පස්සේ මේ තියෙන්නේ EDit.php කියන එක.

PHP:

if(isset($_GET['id'])){ $id = $_GET['id']; } $stmt = $connection->prepare("SELECT * FROM user WHERE id = ?"); $stmt->bind_param('s',$id); $stmt->execute(); $result = $stmt->get_result(); if($result->num_rows > 0) { while($row = $result-> fetch_assoc()){ $id = $row['id']; $name = $row['name']; $add = $row['address']; } }else{ $name = ''; $add = ''; } $stmt->close(); <form action = "" method = "post" enctype="multipart/form-data"> <div class="form-group"> <label for="post-category">Name</label> <input value="<?php echo $name; ?>" name="name" class="form-control input-sm" placeholder="name" type="text"> </div> <div class="form-group"> <label for="post-category">NIC</label> <input value="<?php echo $add; ?>" name="nic" class="form-control input-sm" placeholder="nic" type="text"> </div> </form>

ඒකෙදි උඹ අර පාස් කරපු ID එකට අදාල ඩේටා ටේබල් එකෙන් ගන්නවා..ඒ අරගෙන ඒ values variables වලට assign කරලා..variable values form එකට සෙට් කරනවා

CorD SaC said:
වැඩද? අවුලක් උනොත් අහන්ඩ

Code:

[COLOR=#000000]$stmt->bind_param('s',$id); [/COLOR]

methana error ekak enawa mcn

CorD SaC · Sep 20, 2017

isurutmv said:
Code:

[COLOR=#000000]$stmt->bind_param('s',$id); [/COLOR]

methana error ekak enawa mcn

එරර් එක දාපන් මචන්

isurutmv · Sep 20, 2017

CorD SaC said:
එරර් එක දාපන් මචන්

hari mcn eeka hada gatta

thawa awulak thiyenawa bn

Code:

[COLOR=#d4d4d4][FONT=Consolas][COLOR=#c586c0]if[/COLOR][COLOR=#d4d4d4]([/COLOR][COLOR=#dcdcaa]isset[/COLOR][COLOR=#d4d4d4]([/COLOR][COLOR=#9cdcfe]$_POST[/COLOR][COLOR=#d4d4d4][[/COLOR][COLOR=#ce9178]'submit'[/COLOR][COLOR=#d4d4d4]])){[/COLOR]

[COLOR=#d4d4d4]    [/COLOR][COLOR=#9cdcfe]$vehicalnumber[/COLOR][COLOR=#d4d4d4]=[/COLOR][COLOR=#9cdcfe]$_POST[/COLOR][COLOR=#d4d4d4][[/COLOR][COLOR=#ce9178]'vehicalnumber'[/COLOR][COLOR=#d4d4d4]];[/COLOR]
[COLOR=#d4d4d4]    [/COLOR][COLOR=#9cdcfe]$date[/COLOR][COLOR=#d4d4d4]=[/COLOR][COLOR=#9cdcfe]$_POST[/COLOR][COLOR=#d4d4d4][[/COLOR][COLOR=#ce9178]'date'[/COLOR][COLOR=#d4d4d4]];[/COLOR]
[COLOR=#d4d4d4]    [/COLOR][COLOR=#9cdcfe]$date2[/COLOR][COLOR=#d4d4d4]=[/COLOR][COLOR=#9cdcfe]$_POST[/COLOR][COLOR=#d4d4d4][[/COLOR][COLOR=#ce9178]'date2'[/COLOR][COLOR=#d4d4d4]];[/COLOR]
[COLOR=#d4d4d4]    [/COLOR][COLOR=#9cdcfe]$billnumber[/COLOR][COLOR=#d4d4d4]=[/COLOR][COLOR=#9cdcfe]$_POST[/COLOR][COLOR=#d4d4d4][[/COLOR][COLOR=#ce9178]'billnumber'[/COLOR][COLOR=#d4d4d4]];[/COLOR]
[COLOR=#d4d4d4]    [/COLOR][COLOR=#9cdcfe]$time[/COLOR][COLOR=#d4d4d4]=[/COLOR][COLOR=#9cdcfe]$_POST[/COLOR][COLOR=#d4d4d4][[/COLOR][COLOR=#ce9178]'time'[/COLOR][COLOR=#d4d4d4]];[/COLOR]
[COLOR=#d4d4d4]    [/COLOR][COLOR=#9cdcfe]$duration[/COLOR][COLOR=#d4d4d4]=[/COLOR][COLOR=#9cdcfe]$_POST[/COLOR][COLOR=#d4d4d4][[/COLOR][COLOR=#ce9178]'duration'[/COLOR][COLOR=#d4d4d4]];[/COLOR]
[COLOR=#d4d4d4]    [/COLOR][COLOR=#9cdcfe]$telephone[/COLOR][COLOR=#d4d4d4]=[/COLOR][COLOR=#9cdcfe]$_POST[/COLOR][COLOR=#d4d4d4][[/COLOR][COLOR=#ce9178]'telephone'[/COLOR][COLOR=#d4d4d4]];[/COLOR]
[COLOR=#d4d4d4]    [/COLOR][COLOR=#9cdcfe]$nic[/COLOR][COLOR=#d4d4d4]=[/COLOR][COLOR=#9cdcfe]$_POST[/COLOR][COLOR=#d4d4d4][[/COLOR][COLOR=#ce9178]'nic'[/COLOR][COLOR=#d4d4d4]];[/COLOR]
[COLOR=#d4d4d4]    [/COLOR][COLOR=#9cdcfe]$name[/COLOR][COLOR=#d4d4d4]=[/COLOR][COLOR=#9cdcfe]$_POST[/COLOR][COLOR=#d4d4d4][[/COLOR][COLOR=#ce9178]'name'[/COLOR][COLOR=#d4d4d4]];[/COLOR]



[COLOR=#d4d4d4]    [/COLOR][COLOR=#9cdcfe]$connect[/COLOR][COLOR=#d4d4d4] [/COLOR][COLOR=#d4d4d4]=[/COLOR][COLOR=#d4d4d4] [/COLOR][COLOR=#dcdcaa]mysqli_connect[/COLOR][COLOR=#d4d4d4]([/COLOR][COLOR=#ce9178]"localhost"[/COLOR][COLOR=#d4d4d4], [/COLOR][COLOR=#ce9178]"root"[/COLOR][COLOR=#d4d4d4], [/COLOR][COLOR=#ce9178]""[/COLOR][COLOR=#d4d4d4], [/COLOR][COLOR=#ce9178]"dgi"[/COLOR][COLOR=#d4d4d4]);  [/COLOR]
[COLOR=#d4d4d4]    [/COLOR]
[COLOR=#d4d4d4]    [/COLOR][COLOR=#9cdcfe]$query[/COLOR][COLOR=#d4d4d4]=[/COLOR][COLOR=#ce9178]"[/COLOR][COLOR=#569cd6]SELECT[/COLOR][COLOR=#ce9178] [/COLOR][COLOR=#d4d4d4]*[/COLOR][COLOR=#ce9178] [/COLOR][COLOR=#569cd6]FROM[/COLOR][COLOR=#ce9178] ongoing_booking [/COLOR][COLOR=#569cd6]WHERE[/COLOR][COLOR=#ce9178] vehical_number [/COLOR][COLOR=#d4d4d4]=[/COLOR][COLOR=#ce9178]'[/COLOR][COLOR=#9cdcfe]$vehicalnumber[/COLOR][COLOR=#ce9178]'[/COLOR][COLOR=#ce9178]"[/COLOR][COLOR=#d4d4d4];[/COLOR]
[COLOR=#d4d4d4]    [/COLOR]
[COLOR=#d4d4d4]    [/COLOR][COLOR=#9cdcfe]$result[/COLOR][COLOR=#d4d4d4] [/COLOR][COLOR=#d4d4d4]=[/COLOR][COLOR=#d4d4d4] [/COLOR][COLOR=#dcdcaa]mysqli_query[/COLOR][COLOR=#d4d4d4]([/COLOR][COLOR=#9cdcfe]$connect[/COLOR][COLOR=#d4d4d4], [/COLOR][COLOR=#9cdcfe]$query[/COLOR][COLOR=#d4d4d4]); [/COLOR]
[COLOR=#d4d4d4]    [/COLOR][COLOR=#c586c0]if[/COLOR][COLOR=#d4d4d4]([/COLOR][COLOR=#9cdcfe]$result[/COLOR][COLOR=#d4d4d4]==[/COLOR][COLOR=#ce9178]''[/COLOR][COLOR=#d4d4d4])[/COLOR]
[COLOR=#d4d4d4]    {[/COLOR]
[COLOR=#d4d4d4]        [/COLOR][COLOR=#c586c0]include[/COLOR][COLOR=#d4d4d4] [/COLOR][COLOR=#ce9178]"../include/db.php"[/COLOR][COLOR=#d4d4d4];[/COLOR]
[COLOR=#d4d4d4]        [/COLOR][COLOR=#9cdcfe]$sql[/COLOR][COLOR=#d4d4d4] [/COLOR][COLOR=#d4d4d4]=[/COLOR][COLOR=#d4d4d4] [/COLOR][COLOR=#ce9178]"[/COLOR][COLOR=#569cd6]INSERT INTO[/COLOR][COLOR=#ce9178] ongoing_booking (vehical_number,booking_date,end_date,bill_number,booking_time,duration,telephone,NIC,name)[/COLOR]
[COLOR=#ce9178]        [/COLOR][COLOR=#569cd6]VALUES[/COLOR][COLOR=#ce9178] ('[/COLOR][COLOR=#9cdcfe]$vehicalnumber[/COLOR][COLOR=#ce9178]','[/COLOR][COLOR=#9cdcfe]$date[/COLOR][COLOR=#ce9178]','[/COLOR][COLOR=#9cdcfe]$date2[/COLOR][COLOR=#ce9178]','[/COLOR][COLOR=#9cdcfe]$billnumber[/COLOR][COLOR=#ce9178]','[/COLOR][COLOR=#9cdcfe]$time[/COLOR][COLOR=#ce9178]','[/COLOR][COLOR=#9cdcfe]$duration[/COLOR][COLOR=#ce9178]','[/COLOR][COLOR=#9cdcfe]$telephone[/COLOR][COLOR=#ce9178]','[/COLOR][COLOR=#9cdcfe]$nic[/COLOR][COLOR=#ce9178]','[/COLOR][COLOR=#9cdcfe]$name[/COLOR][COLOR=#ce9178]')[/COLOR][COLOR=#ce9178]"[/COLOR][COLOR=#d4d4d4];[/COLOR]
[COLOR=#d4d4d4]        [/COLOR]
[COLOR=#d4d4d4]        [/COLOR][COLOR=#9cdcfe]$connect[/COLOR][COLOR=#d4d4d4]->[/COLOR][COLOR=#dcdcaa]exec[/COLOR][COLOR=#d4d4d4]([/COLOR][COLOR=#9cdcfe]$sql[/COLOR][COLOR=#d4d4d4]);[/COLOR]
[COLOR=#d4d4d4]        [/COLOR][COLOR=#dcdcaa]header[/COLOR][COLOR=#d4d4d4]([/COLOR][COLOR=#ce9178]"location:../pages/dashboadr.php"[/COLOR][COLOR=#d4d4d4]);  [/COLOR]
[COLOR=#d4d4d4]    } [/COLOR]
[COLOR=#d4d4d4]    [/COLOR][COLOR=#c586c0]else[/COLOR][COLOR=#d4d4d4] {[/COLOR]
[COLOR=#d4d4d4]    [/COLOR][COLOR=#c586c0]while[/COLOR][COLOR=#d4d4d4]([/COLOR][COLOR=#9cdcfe]$row[/COLOR][COLOR=#d4d4d4] [/COLOR][COLOR=#d4d4d4]=[/COLOR][COLOR=#d4d4d4] [/COLOR][COLOR=#dcdcaa]mysqli_fetch_array[/COLOR][COLOR=#d4d4d4]([/COLOR][COLOR=#9cdcfe]$result[/COLOR][COLOR=#d4d4d4])){[/COLOR]
[COLOR=#d4d4d4]        [/COLOR]
[COLOR=#d4d4d4]        [/COLOR][COLOR=#9cdcfe]$dbdate[/COLOR][COLOR=#d4d4d4]=[/COLOR][COLOR=#9cdcfe]$row[/COLOR][COLOR=#d4d4d4][[/COLOR][COLOR=#ce9178]'end_date'[/COLOR][COLOR=#d4d4d4]];[/COLOR]
[COLOR=#d4d4d4]        [/COLOR][COLOR=#9cdcfe]$dbtime[/COLOR][COLOR=#d4d4d4]=[/COLOR][COLOR=#9cdcfe]$row[/COLOR][COLOR=#d4d4d4][[/COLOR][COLOR=#ce9178]'booking_time'[/COLOR][COLOR=#d4d4d4]];[/COLOR]
[COLOR=#d4d4d4]        [/COLOR][COLOR=#9cdcfe]$dbdate2[/COLOR][COLOR=#d4d4d4]=[/COLOR][COLOR=#9cdcfe]$row[/COLOR][COLOR=#d4d4d4][[/COLOR][COLOR=#ce9178]'booking_date'[/COLOR][COLOR=#d4d4d4]];[/COLOR]
[COLOR=#d4d4d4]     [/COLOR]
[COLOR=#d4d4d4]        [/COLOR]
[COLOR=#d4d4d4]     }[/COLOR]
[/FONT][/COLOR]

mata oone bn oya vehical number number eken database eke row ekak nattan witharak data tika eneter karanna ee vehical number eken kisima row ekak nadda kiyala balaganna man mehema use kara if($result=='') eeth hari giye na bn

rajith123 · Sep 20, 2017

isurutmv said:

hari mcn eeka hada gatta

thawa awulak thiyenawa bn

Code:

[COLOR=#d4d4d4][FONT=Consolas][COLOR=#c586c0]if[/COLOR][COLOR=#d4d4d4]([/COLOR][COLOR=#dcdcaa]isset[/COLOR][COLOR=#d4d4d4]([/COLOR][COLOR=#9cdcfe]$_POST[/COLOR][COLOR=#d4d4d4][[/COLOR][COLOR=#ce9178]'submit'[/COLOR][COLOR=#d4d4d4]])){[/COLOR]

[COLOR=#d4d4d4]    [/COLOR][COLOR=#9cdcfe]$vehicalnumber[/COLOR][COLOR=#d4d4d4]=[/COLOR][COLOR=#9cdcfe]$_POST[/COLOR][COLOR=#d4d4d4][[/COLOR][COLOR=#ce9178]'vehicalnumber'[/COLOR][COLOR=#d4d4d4]];[/COLOR]
[COLOR=#d4d4d4]    [/COLOR][COLOR=#9cdcfe]$date[/COLOR][COLOR=#d4d4d4]=[/COLOR][COLOR=#9cdcfe]$_POST[/COLOR][COLOR=#d4d4d4][[/COLOR][COLOR=#ce9178]'date'[/COLOR][COLOR=#d4d4d4]];[/COLOR]
[COLOR=#d4d4d4]    [/COLOR][COLOR=#9cdcfe]$date2[/COLOR][COLOR=#d4d4d4]=[/COLOR][COLOR=#9cdcfe]$_POST[/COLOR][COLOR=#d4d4d4][[/COLOR][COLOR=#ce9178]'date2'[/COLOR][COLOR=#d4d4d4]];[/COLOR]
[COLOR=#d4d4d4]    [/COLOR][COLOR=#9cdcfe]$billnumber[/COLOR][COLOR=#d4d4d4]=[/COLOR][COLOR=#9cdcfe]$_POST[/COLOR][COLOR=#d4d4d4][[/COLOR][COLOR=#ce9178]'billnumber'[/COLOR][COLOR=#d4d4d4]];[/COLOR]
[COLOR=#d4d4d4]    [/COLOR][COLOR=#9cdcfe]$time[/COLOR][COLOR=#d4d4d4]=[/COLOR][COLOR=#9cdcfe]$_POST[/COLOR][COLOR=#d4d4d4][[/COLOR][COLOR=#ce9178]'time'[/COLOR][COLOR=#d4d4d4]];[/COLOR]
[COLOR=#d4d4d4]    [/COLOR][COLOR=#9cdcfe]$duration[/COLOR][COLOR=#d4d4d4]=[/COLOR][COLOR=#9cdcfe]$_POST[/COLOR][COLOR=#d4d4d4][[/COLOR][COLOR=#ce9178]'duration'[/COLOR][COLOR=#d4d4d4]];[/COLOR]
[COLOR=#d4d4d4]    [/COLOR][COLOR=#9cdcfe]$telephone[/COLOR][COLOR=#d4d4d4]=[/COLOR][COLOR=#9cdcfe]$_POST[/COLOR][COLOR=#d4d4d4][[/COLOR][COLOR=#ce9178]'telephone'[/COLOR][COLOR=#d4d4d4]];[/COLOR]
[COLOR=#d4d4d4]    [/COLOR][COLOR=#9cdcfe]$nic[/COLOR][COLOR=#d4d4d4]=[/COLOR][COLOR=#9cdcfe]$_POST[/COLOR][COLOR=#d4d4d4][[/COLOR][COLOR=#ce9178]'nic'[/COLOR][COLOR=#d4d4d4]];[/COLOR]
[COLOR=#d4d4d4]    [/COLOR][COLOR=#9cdcfe]$name[/COLOR][COLOR=#d4d4d4]=[/COLOR][COLOR=#9cdcfe]$_POST[/COLOR][COLOR=#d4d4d4][[/COLOR][COLOR=#ce9178]'name'[/COLOR][COLOR=#d4d4d4]];[/COLOR]



[COLOR=#d4d4d4]    [/COLOR][COLOR=#9cdcfe]$connect[/COLOR][COLOR=#d4d4d4] [/COLOR][COLOR=#d4d4d4]=[/COLOR][COLOR=#d4d4d4] [/COLOR][COLOR=#dcdcaa]mysqli_connect[/COLOR][COLOR=#d4d4d4]([/COLOR][COLOR=#ce9178]"localhost"[/COLOR][COLOR=#d4d4d4], [/COLOR][COLOR=#ce9178]"root"[/COLOR][COLOR=#d4d4d4], [/COLOR][COLOR=#ce9178]""[/COLOR][COLOR=#d4d4d4], [/COLOR][COLOR=#ce9178]"dgi"[/COLOR][COLOR=#d4d4d4]);  [/COLOR]
[COLOR=#d4d4d4]    [/COLOR]
[COLOR=#d4d4d4]    [/COLOR][COLOR=#9cdcfe]$query[/COLOR][COLOR=#d4d4d4]=[/COLOR][COLOR=#ce9178]"[/COLOR][COLOR=#569cd6]SELECT[/COLOR][COLOR=#ce9178] [/COLOR][COLOR=#d4d4d4]*[/COLOR][COLOR=#ce9178] [/COLOR][COLOR=#569cd6]FROM[/COLOR][COLOR=#ce9178] ongoing_booking [/COLOR][COLOR=#569cd6]WHERE[/COLOR][COLOR=#ce9178] vehical_number [/COLOR][COLOR=#d4d4d4]=[/COLOR][COLOR=#ce9178]'[/COLOR][COLOR=#9cdcfe]$vehicalnumber[/COLOR][COLOR=#ce9178]'[/COLOR][COLOR=#ce9178]"[/COLOR][COLOR=#d4d4d4];[/COLOR]
[COLOR=#d4d4d4]    [/COLOR]
[COLOR=#d4d4d4]    [/COLOR][COLOR=#9cdcfe]$result[/COLOR][COLOR=#d4d4d4] [/COLOR][COLOR=#d4d4d4]=[/COLOR][COLOR=#d4d4d4] [/COLOR][COLOR=#dcdcaa]mysqli_query[/COLOR][COLOR=#d4d4d4]([/COLOR][COLOR=#9cdcfe]$connect[/COLOR][COLOR=#d4d4d4], [/COLOR][COLOR=#9cdcfe]$query[/COLOR][COLOR=#d4d4d4]); [/COLOR]
[COLOR=#d4d4d4]    [/COLOR][COLOR=#c586c0]if[/COLOR][COLOR=#d4d4d4]([/COLOR][COLOR=#9cdcfe]$result[/COLOR][COLOR=#d4d4d4]==[/COLOR][COLOR=#ce9178]''[/COLOR][COLOR=#d4d4d4])[/COLOR]
[COLOR=#d4d4d4]    {[/COLOR]
[COLOR=#d4d4d4]        [/COLOR][COLOR=#c586c0]include[/COLOR][COLOR=#d4d4d4] [/COLOR][COLOR=#ce9178]"../include/db.php"[/COLOR][COLOR=#d4d4d4];[/COLOR]
[COLOR=#d4d4d4]        [/COLOR][COLOR=#9cdcfe]$sql[/COLOR][COLOR=#d4d4d4] [/COLOR][COLOR=#d4d4d4]=[/COLOR][COLOR=#d4d4d4] [/COLOR][COLOR=#ce9178]"[/COLOR][COLOR=#569cd6]INSERT INTO[/COLOR][COLOR=#ce9178] ongoing_booking (vehical_number,booking_date,end_date,bill_number,booking_time,duration,telephone,NIC,name)[/COLOR]
[COLOR=#ce9178]        [/COLOR][COLOR=#569cd6]VALUES[/COLOR][COLOR=#ce9178] ('[/COLOR][COLOR=#9cdcfe]$vehicalnumber[/COLOR][COLOR=#ce9178]','[/COLOR][COLOR=#9cdcfe]$date[/COLOR][COLOR=#ce9178]','[/COLOR][COLOR=#9cdcfe]$date2[/COLOR][COLOR=#ce9178]','[/COLOR][COLOR=#9cdcfe]$billnumber[/COLOR][COLOR=#ce9178]','[/COLOR][COLOR=#9cdcfe]$time[/COLOR][COLOR=#ce9178]','[/COLOR][COLOR=#9cdcfe]$duration[/COLOR][COLOR=#ce9178]','[/COLOR][COLOR=#9cdcfe]$telephone[/COLOR][COLOR=#ce9178]','[/COLOR][COLOR=#9cdcfe]$nic[/COLOR][COLOR=#ce9178]','[/COLOR][COLOR=#9cdcfe]$name[/COLOR][COLOR=#ce9178]')[/COLOR][COLOR=#ce9178]"[/COLOR][COLOR=#d4d4d4];[/COLOR]
[COLOR=#d4d4d4]        [/COLOR]
[COLOR=#d4d4d4]        [/COLOR][COLOR=#9cdcfe]$connect[/COLOR][COLOR=#d4d4d4]->[/COLOR][COLOR=#dcdcaa]exec[/COLOR][COLOR=#d4d4d4]([/COLOR][COLOR=#9cdcfe]$sql[/COLOR][COLOR=#d4d4d4]);[/COLOR]
[COLOR=#d4d4d4]        [/COLOR][COLOR=#dcdcaa]header[/COLOR][COLOR=#d4d4d4]([/COLOR][COLOR=#ce9178]"location:../pages/dashboadr.php"[/COLOR][COLOR=#d4d4d4]);  [/COLOR]
[COLOR=#d4d4d4]    } [/COLOR]
[COLOR=#d4d4d4]    [/COLOR][COLOR=#c586c0]else[/COLOR][COLOR=#d4d4d4] {[/COLOR]
[COLOR=#d4d4d4]    [/COLOR][COLOR=#c586c0]while[/COLOR][COLOR=#d4d4d4]([/COLOR][COLOR=#9cdcfe]$row[/COLOR][COLOR=#d4d4d4] [/COLOR][COLOR=#d4d4d4]=[/COLOR][COLOR=#d4d4d4] [/COLOR][COLOR=#dcdcaa]mysqli_fetch_array[/COLOR][COLOR=#d4d4d4]([/COLOR][COLOR=#9cdcfe]$result[/COLOR][COLOR=#d4d4d4])){[/COLOR]
[COLOR=#d4d4d4]        [/COLOR]
[COLOR=#d4d4d4]        [/COLOR][COLOR=#9cdcfe]$dbdate[/COLOR][COLOR=#d4d4d4]=[/COLOR][COLOR=#9cdcfe]$row[/COLOR][COLOR=#d4d4d4][[/COLOR][COLOR=#ce9178]'end_date'[/COLOR][COLOR=#d4d4d4]];[/COLOR]
[COLOR=#d4d4d4]        [/COLOR][COLOR=#9cdcfe]$dbtime[/COLOR][COLOR=#d4d4d4]=[/COLOR][COLOR=#9cdcfe]$row[/COLOR][COLOR=#d4d4d4][[/COLOR][COLOR=#ce9178]'booking_time'[/COLOR][COLOR=#d4d4d4]];[/COLOR]
[COLOR=#d4d4d4]        [/COLOR][COLOR=#9cdcfe]$dbdate2[/COLOR][COLOR=#d4d4d4]=[/COLOR][COLOR=#9cdcfe]$row[/COLOR][COLOR=#d4d4d4][[/COLOR][COLOR=#ce9178]'booking_date'[/COLOR][COLOR=#d4d4d4]];[/COLOR]
[COLOR=#d4d4d4]     [/COLOR]
[COLOR=#d4d4d4]        [/COLOR]
[COLOR=#d4d4d4]     }[/COLOR]
[/FONT][/COLOR]

mata oone bn oya vehical number number eken database eke row ekak nattan witharak data tika eneter karanna ee vehical number eken kisima row ekak nadda kiyala balaganna man mehema use kara if($result=='') eeth hari giye na bn

kolla sahena gemak deela code eka color karanna. reply karana tana php wrap kiyala icon ekak athi anna eka use karala code eka dapan. anika purudu weyan machan code eka lassanata align karanna. me wage code dakiddi kiyawanna hithenne na nathnam

annunaki · Sep 20, 2017

Javascript walin karanna wenne PHP walin witharak page eka reload karanne nathuwa karanna ba

CorD SaC · Sep 20, 2017

rajith123 said:
kolla sahena gemak deela code eka color karanna. reply karana tana php wrap kiyala icon ekak athi anna eka use karala code eka dapan. anika purudu weyan machan code eka lassanata align karanna. me wage code dakiddi kiyawanna hithenne na nathnam

මූ කියන කතාව ඇත්ත :yes:

,ඔන්න ඒ නිසා මම format කරලා දැම්මා...

PHP:

if (isset($_POST['submit']))
	{
	$vehicalnumber = $_POST['vehicalnumber'];
	$date = $_POST['date'];
	$date2 = $_POST['date2'];
	$billnumber = $_POST['billnumber'];
	$time = $_POST['time'];
	$duration = $_POST['duration'];
	$telephone = $_POST['telephone'];
	$nic = $_POST['nic'];
	$name = $_POST['name'];
	$connect = mysqli_connect("localhost", "root", "", "dgi");
	$query = "SELECT*FROM ongoing_booking WHERE vehical_number ='$vehicalnumber'";
	$result = mysqli_query($connect, $query);
	if ($result == '')
		{
		include "../include/db.php";

		$sql = "INSERT INTO ongoing_booking (vehical_number,booking_date,end_date,bill_number,booking_time,duration,telephone,NIC,name)
VALUES ('$vehicalnumber','$date','$date2','$billnumber','$time','$duration','$telephone','$nic','$name')";
		$connect->exec($sql);
		header("location:../pages/dashboadr.php");
		}
	  else
		{
		while ($row = mysqli_fetch_array($result))
			{
			$dbdate = $row['end_date'];
			$dbtime = $row['booking_time'];
			$dbdate2 = $row['booking_date'];
			}
		}
	}

LazyLizard · Sep 20, 2017

isurutmv said:
mata oone bn oya vehical number number eken database eke row ekak nattan witharak data tika eneter karanna ee vehical number eken kisima row ekak nadda kiyala balaganna man mehema use kara if($result=='') eeth hari giye na bn

if($result=='') වෙනුවට if(mysqli_num_rows($result)==0) වගේ දැම්මොත් මොකෝ :oo:

CorD SaC · Sep 20, 2017

isurutmv said:
hari mcn eeka hada gatta thawa awulak thiyenawa bn

mata oone bn oya vehical number number eken database eke row ekak nattan witharak data tika eneter karanna ee vehical number eken kisima row ekak nadda kiyala balaganna man mehema use kara if($result=='') eeth hari giye na bn

කොහොමද යකෝ මේ ටික කලර් කලේ.. :shocked:

ඇඟ හිරි වැටිලා ගියා ඒක දැක්කම.. :sorry:

මෙහෙම කරපන්,සාමානයෙන් බන් මෙහෙම කෝඩ් ලියන්නෙ නෑ..පුලුවන්නම් මේවා prepared statements වලින් ලියපන්..නැතනම් security පැත්තක් නෑ බන්..

උඹ ප්‍රොජෙක්ට් එකකටද කරන්නේ..? PDO style or OOP වලින් කරපන් මචන් පුලුවන්නම්..

PHP:

$query = "SELECT count(*) as total FROM FROM ongoing_booking WHERE vehical_number ='$vehicalnumber'";
$sql = mysqli_query($connect, $query);
$all = mysqli_fetch_assoc($sql);
$total = $all['total'];

if ($total == 1)
	{
	}
  else
	{
	}

මේ තියෙන්නේ PDO style එකට..

PHP:

$connection = mysqli_connect('localhost','root','','yourdb');
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}

if ($stmt = mysqli_prepare($connection, "SELECT*FROM ongoing_booking WHERE vehical_number = ?")) {
	
	mysqli_stmt_bind_param($stmt, "s", $vehicalnumber);
	mysqli_stmt_execute($stmt);
	mysqli_stmt_store_result($stmt);
	
	if (mysqli_stmt_num_rows($stmt)) {
		
	
	}
	else{
		
	}	


}

Read more : http://php.net/manual/en/mysqli-stmt.fetch.php

D T · Sep 20, 2017

session walin karanna barida bn?

kolavari · Sep 21, 2017

CorD SaC said:
කොහොමද යකෝ මේ ටික කලර් කලේ..ඇඟ හිරි වැටිලා ගියා ඒක දැක්කම..මෙහෙම කරපන්,සාමානයෙන් බන් මෙහෙම කෝඩ් ලියන්නෙ නෑ..පුලුවන්නම් මේවා prepared statements වලින් ලියපන්..නැතනම් security පැත්තක් නෑ බන්.. උඹ ප්‍රොජෙක්ට් එකකටද කරන්නේ..? PDO style or OOP වලින් කරපන් මචන් පුලුවන්නම්..

PHP:

$query = "SELECT count(*) as total FROM FROM ongoing_booking WHERE vehical_number ='$vehicalnumber'"; $sql = mysqli_query($connect, $query); $all = mysqli_fetch_assoc($sql); $total = $all['total']; if ($total == 1) { } else { }

මේ තියෙන්නේ PDO style එකට..

PHP:

$connection = mysqli_connect('localhost','root','','yourdb'); if (mysqli_connect_errno()) { printf("Connect failed: %s\n", mysqli_connect_error()); exit(); } if ($stmt = mysqli_prepare($connection, "SELECT*FROM ongoing_booking WHERE vehical_number = ?")) { mysqli_stmt_bind_param($stmt, "s", $vehicalnumber); mysqli_stmt_execute($stmt); mysqli_stmt_store_result($stmt); if (mysqli_stmt_num_rows($stmt)) { } else{ } }

Read more : http://php.net/manual/en/mysqli-stmt.fetch.php

මේ උඹ දාපු එකේ PDO නෙමෙයි තියෙන්නේ..මේ දෙකේම තියෙන්නේ mysqli :yes:

CorD SaC · Sep 21, 2017

kolavari said:
මේ උඹ දාපු එකේ PDO නෙමෙයි තියෙන්නේ..මේ දෙකේම තියෙන්නේ mysqli

එහෙමද මචන්.. අන්න ඒ වැරද්ද හදපන් මචන් එහෙනම්

kolavari · Sep 21, 2017

CorD SaC said:
එහෙමද මචන්.. අන්න ඒ වැරද්ද හදපන් මචන් එහෙනම්

Heta daannam bn

dan nidi mathai ..

Pdo kiyanne extension ekak :yes:

mysqli kiyanneth extension ekak...pdo eka mama danna tharamin procedural liyanna ba (mama nam ehema use karala na)

Mysqli eka puluwan uba oya liyala thiyenawa wage..

PHP Help!!!

Well-known member

Active member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Member

Well-known member

Well-known member

Well-known member

Similar threads