ElaKiri Programmer's Club

[DooA]

me error ekA ENNA HETHUWA MOKAKDA BUN??


Database query failed : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1' at line 1

SQL:

function get_subject_by_id($subject_id){
		global $connection;
		
		$query  = "SELECT * ";
		$query .= "FROM subjects ";
		$query .= "WHERE id=" . $subject_id . " ";
		$query .= "LIMIT 1";
		$result_set= mysqli_query($connection,$query);
		confirm_query($result_set);
		//Remember.....
		//if no rows are returned,fetch_array will return false
		if($subject=mysqli_fetch_array($result_set)){
					return $subject;
				}else{
				
					return NULL;
				}
		}

Quary variable eka print karanna.
Subject id ekata string value ekak enawada danne na.


FYI prepare statement use karahan. Ohoma kaloth sql injection denna puluwanda

 

[tery123]

Quary variable eka print karanna.
Subject id ekata string value ekak enawada danne na.


FYI prepare statement use karahan. Ohoma kaloth sql injection denna puluwanda

 

[DooA]

$query .= "WHERE id='" . $subject_id . "' ";

meka dala balapan. wada kale nathnam $query variable eka print karala eka workbench eke execute karala balapan wada karanawada kiyala

 

[MihiCherub]

me error ekA ENNA HETHUWA MOKAKDA BUN??


Database query failed : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1' at line 1

SQL:

function get_subject_by_id($subject_id){
        global $connection;
        
        $query  = "SELECT * ";
        $query .= "FROM subjects ";
        $query .= "WHERE id=" . $subject_id . " ";
        $query .= "LIMIT 1";
        $result_set= mysqli_query($connection,$query);
        confirm_query($result_set);
        //Remember.....
        //if no rows are returned,fetch_array will return false
        if($subject=mysqli_fetch_array($result_set)){
                    return $subject;
                }else{
                
                    return NULL;
                }
        }

developing phase ekedi SQL query auto console wenna program eka liyanna. api nam hard code karala thiyenne developing machine wla witharak execute wenna.

ethakota hama query ekak ma execute wenna kalin console eke print wenawa. errors check karanna, efficiency check karanna, query explain karanna godak lesi.

oyage case eke query eke "single quote" eka na. e nisa string value ekak awoth error ekak. eth e error eka clearly visible wenne na query eka print nokarana nisa. e nisa unit test n debug nathuwa normal run ekedi query auto print wenna danna.

"confirm_query" function eke para walin ena $result_set eka print wenna danna..

 

[CorD SaC]

kamathi nam api laga wadata enna..

මොකක්ද මචන් ඔයාලගෙ කම්පැනි එක.විස්තර ටිකක් ඉන්බොක්ස් කරනවද

 

[CorD SaC]

wenas wenna one. ehema wenas wenne natte wenath UI ekak dala thibboth thama. Nimbus UI eka ayin karanna..
nath nam dala thiyena UI eke Property change karanna,

හරි මචන් වැඩේ ගොඩ දාගත්තා....

 

[tery123]

developing phase ekedi SQL query auto console wenna program eka liyanna. api nam hard code karala thiyenne developing machine wla witharak execute wenna.

ethakota hama query ekak ma execute wenna kalin console eke print wenawa. errors check karanna, efficiency check karanna, query explain karanna godak lesi.

oyage case eke query eke "single quote" eka na. e nisa string value ekak awoth error ekak. eth e error eka clearly visible wenne na query eka print nokarana nisa. e nisa unit test n debug nathuwa normal run ekedi query auto print wenna danna.

"confirm_query" function eke para walin ena $result_set eka print wenna danna..

ade ela macho tanku wewa

 

[Ritash9001]

mean stack dannawanm podi help ekak dipanko. heroku walata daganna baruwa hira wela ennawa

 

[^Buddhika^]

 

[Onda_AX1]

machanlaa.. first year project ideas tikak kiyapallako..

basically electronics project combined with programming..

(mora IT)
​

 

[Sea1men]

machanla hotel management system ekakata hadapu data flow diagram ekak tiyenava nam danna please.mama try kala eth hari giye ne.

 

[saja]

can anyone help ?

http://www.elakiri.com/forum/showthread.php?t=1781203

 

[Fire Five]

web page ekaka

yourdomain/products.html

kiyala enakota file format eka hide karanne kohomada mama try kara hariyanne nehe ne web eke thiyena ewa

wamp server walin try karanne mama

 

[I love JS]

web page ekaka

yourdomain/products.html

kiyala enakota file format eka hide karanne kohomada mama try kara hariyanne nehe ne web eke thiyena ewa

wamp server walin try karanne mama

htaccess try kalada?

 

[Fire Five]

htaccess try kalada?

htaccess file eka demma

 

[whiteskull]

sub

 

[I love JS]

htaccess file eka demma

code eka nam hari, .htaccess file eka thiyenne machan ubata URI rewrite karanna ona directory ekeda? root da?

 

[channamoney]

web designing, devloping walatath adalada meka?

 

[Fire Five]

code eka nam hari, .htaccess file eka thiyenne machan ubata URI rewrite karanna ona directory ekeda? root da?

root eka machan

 

[I love JS]

root eka machan

ehenam files thiyena directory ekata dala try karanna hariyai