Calling PHP function wth HTML button

Question

I am developing website using php.I need to call php function using HTML Onclick event. How to do? Here I have given my code.

<?php

function insert() {
    echo "in insert ";
    $servername = "localhost";
    $username = "shwetharao";
    $password = "shwetha";
    $dbname = "semilab";
    // Create connection
    $conn = new mysqli($servername, $username, $password, $dbname);
    // Check connection
    if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    }
    $uname = $_POST['usernameu'];
    $upass = $_POST['passwordu'];
    echo $uname;

    $sql = "INSERT INTO login (id, username, password)VALUES ('id','$uname','$upass')";

    if ($conn->query($sql) === TRUE) {
        echo "New record created successfully";
    } else {
        echo "Error: " . $sql . "<br>" . $conn->error;
    }
    $conn->close();
}
?> 

<!DOCTYPE HTML>
<head>
    <title></title>

</head>

<body>
    <div id="main">

        <div id="login">
            <h2>Create User Account</h2>

            <form action="" method="post">
                <br><br><br>
                <label>UserName :</label>
                <br><br>
                <input id="name" name="usernameu" placeholder="username" type="text">
                <br><br><br>
                <label>Password :</label>
                <br><br>
                <input id="password" name="passwordu" placeholder="**********" type="password">
                <br><br><br>
                <input name="button" type="button" value=" Create user " onclick="insert();">
            </form>
        </div>
    </div>

</body>
</html>

I need to call function insert()[which is php function] on clicking button.How to achieve this?

I think you need to make an AJAX call such that the URL you hit will run the php function. — gravitas
– gravitas, Commented Dec 26, 2014 at 6:18
AJAX is the way... api.jquery.com/jquery.ajax ... or ... form submition by html/php — Gerardo Charles Rojas Vega
– Gerardo Charles Rojas Vega, Commented Dec 26, 2014 at 6:20
Try this, i already given a full demo on this earlier question.. stackoverflow.com/questions/27579480/… — Mahendra Pumbhadiya
– Mahendra Pumbhadiya, Commented Dec 26, 2014 at 6:31

I'm Geeker · Accepted Answer · 2014-12-26 06:20:06Z

1

Try this

 <?php  if(isset($_POST['submit'])){
    insert(); 
    }
    ?>

<!DOCTYPE HTML>
  <head>
  <title></title>

  </head>

  <body>
  <div id="main">

  <div id="login">
  <h2>Create User Account</h2>

  <form action="" method="post">
  <br><br><br>
  <label>UserName :</label>
  <br><br>
  <input id="name" name="usernameu" placeholder="username" type="text">
  <br><br><br>
  <label>Password :</label>
  <br><br>
  <input id="password" name="passwordu" placeholder="**********" type="password">
  <br><br><br>
  <input name="submit" type="submit" value=" Create user" >
  </div>
  </div>

  </body>
  </html>

answered Dec 26, 2014 at 6:20

I'm Geeker

4,6575 gold badges25 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user3335796 Over a year ago

Initially i tried to work through ajax but I could not make that to work. Thank you so much...It worked. :-).

Ferrakkem Bhuiyan · Accepted Answer · 2014-12-26 06:27:54Z

0

you did two mistake first one is php tag at above, you wrote only "?" please change it to '<form action="" method="post"> inside of form you don't write action page name ..for example action = "myFile.php"

answered Dec 26, 2014 at 6:27

Ferrakkem Bhuiyan

2,7932 gold badges25 silver badges39 bronze badges

Comments

Community · Accepted Answer · 2020-06-20 09:12:55Z

PHP: Is only run by the server and responds to requests like clicking on a link (GET) or submitting a form (POST).

HTML & Javascript: Is only run in someone's browser I'm assuming your file looks something like:

<?php
 function insert() {
  echo 'I just ran a php function';
  }
   if(isset($_POST['submit'])){
         insert(); 
     }
     ?>

 <!DOCTYPE HTML>
  <head>
 <title></title>

  </head>

 <body>
 <div id="main">

 <div id="login">
 <h2>Create User Account</h2>

 <form action="" method="post">
 <br><br><br>
 <label>UserName :</label>
  <br><br>
 <input id="name" name="usernameu" placeholder="username" type="text">
 <br><br><br>
 <label>Password :</label>
 <br><br>
 <input id="password" name="passwordu" placeholder="**********" type="password">
 <br><br><br>
<input name="submit" type="submit" value=" Create user" >
 </div>
 </div>

 </body>
 </html>

score 0 · Accepted Answer · 2014-12-26 06:33:53Z

0

Just change

<input name="button" type="button" value="Create user" onclick="insert();">

to

<input name="button" type="submit" value="Create user">

And paste your php code inside this

<?php  if(isset($_POST['submit'])){
    //paste you php code here
     }
     ?>

edited Dec 26, 2014 at 6:33

answered Dec 26, 2014 at 6:27

user4314601

Comments

Jill · Accepted Answer · 2014-12-26 06:35:21Z

<?php
if($_GET){
if(isset($_GET['insert'])){
    insert();
}elseif(isset($_GET['select'])){
    select();
}
}

function select()
{
   echo "The select function is called.";
}
function insert()
{
   echo "The insert function is called.";
}

?>


<input type="submit" class="button" name="insert" value="insert" />
<input type="submit" class="button" name="select" value="select" />

===============================================

<?php
 if($_GET['button1']){fun1();}
 if($_GET['button2']){fun2();}

 function fun1()
 {
  //This function will update some column in database to 1
 }
function fun2()
{
//This function will update some column in database to 2
}
?>

<!DOCTYPE html>
<html lang="en">
<head>
 <title></title>
 </head>
 <body>
  <button id="btnfun1" name="btnfun1" onClick='location.href="?button1=1"'>Update to 1</button>
 <button id="btnfun2" name="btnfun2" onClick='location.href="?button2=1"'>Update to 2</button>
 </body>
</html>

I did it using this code. Hope this helps.

Collectives™ on Stack Overflow

Calling PHP function wth HTML button

5 Answers 5

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related