Reply to thread

Message

<blockquote data-quote="SLHodahitha" data-source="post: 23327764" data-attributes="member: 565060">1.PDO use karapan mysqli use karanne na dan.2. [PHP]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Attempt to execute the prepared statement&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (mysqli_stmt_execute($stmt)) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Redirect to login page&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; header(&quot;location: login.php&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } else {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;Something went wrong. Please try again later.&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //add here&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; mysqli_stmt_close($stmt);&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; //add here&nbsp; &nbsp; &nbsp; &nbsp; mysqli_close($link);&nbsp; &nbsp; &nbsp; &nbsp; // Close statement&nbsp; &nbsp; &nbsp;&nbsp; // mysqli_stmt_close($stmt); //removed&nbsp; &nbsp; }&nbsp; &nbsp; // Close connection&nbsp; &nbsp; //mysqli_close($link);//removed?&gt;[/PHP]ube ara if eka dala tiyenne [HTML]if ($stmt = mysqli_prepare($link, &quot;INSERT INTO users ([/HTML] othana monawahari aulakin u statement eka close wenna yanawa ethaka nisa ethanin error eka enne. if eka ethulema statement close karapan3.[PHP]if (mysqli_stmt_execute($stmt)) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; /* store result */&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //echo 'e';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; mysqli_stmt_store_result($stmt);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (mysqli_stmt_num_rows($stmt) == 1) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $username_err = &quot;This username is already taken.&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } else {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $username = trim($_GET[&quot;username&quot;]);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo $username . '---';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } else {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;Oops! Something went wrong. Please try again later.&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //add here&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; mysqli_stmt_close($stmt);&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; //removed&nbsp; &nbsp; &nbsp; &nbsp; //mysqli_stmt_close($stmt);&nbsp; &nbsp; &nbsp; &nbsp; // Close statement[/PHP]</blockquote>

[QUOTE="SLHodahitha, post: 23327764, member: 565060"] [SIZE=3][B]1.PDO use karapan mysqli use karanne na dan.[/B] [/SIZE][SIZE=5][B][SIZE=3]2. [/SIZE] [/B][/SIZE] [PHP] // Attempt to execute the prepared statement if (mysqli_stmt_execute($stmt)) { // Redirect to login page header("location: login.php"); } else { echo "Something went wrong. Please try again later."; } //add here mysqli_stmt_close($stmt); } //add here mysqli_close($link); // Close statement // mysqli_stmt_close($stmt); //removed } // Close connection //mysqli_close($link);//removed ?>[/PHP] ube ara if eka dala tiyenne [HTML]if ($stmt = mysqli_prepare($link, "INSERT INTO users ([/HTML] othana monawahari aulakin u statement eka close wenna yanawa ethaka nisa ethanin error eka enne. if eka ethulema statement close karapan [SIZE=3][B]3.[/B][/SIZE] [SIZE=2][PHP]if (mysqli_stmt_execute($stmt)) { /* store result */ //echo 'e'; mysqli_stmt_store_result($stmt); if (mysqli_stmt_num_rows($stmt) == 1) { $username_err = "This username is already taken."; } else { $username = trim($_GET["username"]); echo $username . '---'; } } else { echo "Oops! Something went wrong. Please try again later."; } //add here mysqli_stmt_close($stmt); } //removed //mysqli_stmt_close($stmt); // Close statement[/PHP][/SIZE] [/QUOTE]

Verification

Dahaya deken beduwama keeyada?

Search

Latest ads

Reply to thread