SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Addict
    Join Date
    Jul 2011
    Location
    Hyderabad,India.
    Posts
    327
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    php using database

    hi all,
    i have written a script for deleting more than one records using check box.
    but it is not working.below is the code ...
    Code:
    <script>
    function fundel(sno)
    {
    rv=confirm("u want to delete");
    if(rv==true)
    {
    location="delete.php?seno="+sno;
    }
    }
    </script>
    <form method="post" action="delrec.php">
    <table border='1'>
    <?php
    mysql_connect("localhost","root","");
    mysql_select_db("test");
    $data=mysql_query("select * from emp");
    while($rec=mysql_fetch_row($data))
    {
    echo"<tr><td><input type='checkbox' name=$rec[2]'
    value='$rec[2]'><td>$rec[0]<td>$rec[1]<td>$rec[2]<td><input type='button' value='delete'
    onclick='fundel($rec[2])'>";
    }
    ?>
    </table>
    <input type='submit' value='delrec'>
    </form>
    below ids the delrec.php.
    Code:
    /*<?php
    $qs=$_REQUEST['seno'];
    mysql_connect("localhost","root","");
    mysql_select_db("test");
    mysql_query("delete from emp where sno=$qs");
    header('location:getrec.php");
    ?>*/
    <script>
    function delrec(sno)
    {
    rv=confirm("u want to delete");
    if(rv==true)
    {
    location="delete.php?seno="+sno;
    }
    }
    </script>
    also is the delete.php..
    Code:
    <?php
    $qs=$_REQUEST['seno'];
    mysql_connect("localhost","root","");
    mysql_select_db("test");
    mysql_query("delete from emp where sno=$qs");
    header("location:getrec.php");
    ?>
    /*<script>
    function delrec(sno)
    {
    rv=confirm("u want to delete");
    if(rv==true)
    {
    location="delete.php?seno="+sno;
    }
    }
    </script>
    */
    also i want to insert values of three fields using php code.
    i have written the code.when i click the insert button it should get inserted
    into database....
    below is the code for insert function..
    Code:
    <table width="300" border="0" align="center" cellpadding="0" cellspacing="1">
    <tr>
    <td><form name="form1" method="post" action="ins.php">
    <table width="100%" border="0" cellspacing="1" cellpadding="3">
    <tr>
    <td colspan="3"><strong>Insert Data Into mySQL Database </strong></td>
    </tr>
    <tr>
    <td width="71">Name</td>
    <td width="6">:</td>
    <td width="301"><input name="name" type="text" id="name"></td>
    </tr>
    <tr>
    <td>Lastname</td>
    <td>:</td>
    <td><input name="lastname" type="text" id="lastname"></td>
    </tr>
    <tr>
    <td>Email</td>
    <td>:</td>
    </tr>
    <tr>
    <td colspan="3" align="center"><input type="submit" name="Submit" value="Submit"></td>
    </tr>
    </table>
    </form>
    </td>
    </tr>
    </table>
    also the ins.php..
    Code:
    <?php
    
    /*$host="localhost"; // Host name 
    $username=""; // Mysql username 
    $password=""; // Mysql password 
    $db_name="test"; // Database name 
    $tbl_name="test_mysql"; // Table name*/
    
    // Connect to server and select database.
    mysql_connect("localhost", "root", "")or die("cannot connect"); 
    mysql_select_db("test")or die("cannot select DB");
    
    // Get values from form 
    $empno=$_POST['empno'];
    $empname=$_POST['empname'];
    $desig=$_POST['desig'];
    
    // Insert data into mysql 
    $sql="INSERT INTO emp(empno, empname, desig)VALUES('$empno', '$empname', '$desig')";
    $result=mysql_query($sql);
    
    // if successfully insert data into database, displays message "Successful". 
    if($result){
    echo "Successful";
    echo "<BR>";
    echo "<a href='insert.php'>Back to main page</a>";
    }
    
    else 
    {
    echo "ERROR";
    }
    // close connection 
    mysql_close();
    ?>
    i want all these to be integrated into one form so that i can easily insert,delete using php
    kindly tell me how to do it....

  2. #2
    SitePoint Zealot Amit Yaron's Avatar
    Join Date
    Jan 2011
    Location
    Hod Haharon, Israel
    Posts
    107
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    The values of HTML attributes should be inside double-quotes:
    For example:
    Code:
     echo"<tr><td><input type=\"checkbox\" name=\"$rec[2]\"
    When you pass a PHP variable's value to a Javascript function do it as follows
    Code:
    <input type='button' value='delete'
    onclick=\"fundel('$rec[2]')\">";
    Put quotes before the variable's name, unless it is mot a string.
    To make quoting easier, you can use Heredoc:
    Code:
    echo <<<EOD
    <input type="checkbox" name="$rec[2]"
    EOD
    Amit Yaron
    My Blog: PHP & More.

  3. #3
    SitePoint Addict
    Join Date
    Jul 2011
    Location
    Hyderabad,India.
    Posts
    327
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    hi,
    can u briefly adjust the above code i have written so that i can insert the code into correct place...
    is there any thing wrong in the code i have written...
    if yes please tell me where i went wrong....

  4. #4
    SitePoint Addict
    Join Date
    Jul 2011
    Location
    Hyderabad,India.
    Posts
    327
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    i am using phpmyadmin database.
    i am not finding any links u provided there......


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •