Latest ads

Electronics
Vehicles
Property
Search

PHP MySQL help

senewimala1988

senewimala1988

Well-known member
  • Dec 5, 2007
    7,709
    2,578
    113
    Kadawatha, Sri Lanka
    Ane machanla meke mokak hari syntax error ekak thiyenavanam kiyanavada???

    <html>
    <body>
    <?php
    $con=mysql_connect("localhost","root","");
    if(!$con)
    {
    die('Could not connect: ' .mysql_error());
    }
    mysql_select_db("SML", $con);
    $SQL="INSERT INTO Customer_Details (Name, Address, Contact_No, Total_Price)
    VALUES
    ('$_POST[Name]','$_POST[Address]','$_POST[Contact_No]','$_POST[Total_Price]')";
    if(!mysql_query($SQL,$con))
    {
    die('Error: ' .mysql_error());
    }
    echo "Successfully added";
    mysql_close($con);
    ?>
    </body>
    </html>
     
    senewimala1988

    senewimala1988

    Well-known member
  • Dec 5, 2007
    7,709
    2,578
    113
    Kadawatha, Sri Lanka
    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
    <html>
    <head>
    <title>Customer Details</title>
    <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
    </head>
    <body BGCOLOR="#ffffff" BACKGROUND="file:///D:\Matrix.bmp">


    <h3><img src="IDM/Web%20designing/Computer.JPG" width="234" height="201" hspace="132"></h3>
    <blockquote>
    <blockquote>
    <blockquote>
    <blockquote>
    <blockquote>
    <blockquote>
    <blockquote>
    <blockquote>
    <blockquote>
    <blockquote>
    <h3 align="center"> Customer details</h3>
    </blockquote>
    </blockquote>
    </blockquote>
    </blockquote>
    </blockquote>
    </blockquote>
    </blockquote>
    </blockquote>
    </blockquote>
    </blockquote>
    <form action="Customer_Details.php" name="form1" method="post">
    <table width="73%" border="1" align="center">
    <tr>
    <td width="33%"><h4>Customer Name</h4>
    </td>
    <td width="67%"><input name="name" size="75"></td>
    </tr>
    <tr>
    <td><h4>Address</h4>
    </td>
    <td><input name="address" size="75"></td>
    </tr>
    <tr>
    <td><h4>Contact No.</h4>
    </td>
    <td><input name="contact_no" size="75"></td>
    </tr>
    </table>

    <table width="73%" border="1" align="center">
    <tr>
    <td width="24%"><h4>Item No.</h4></td>
    <td width="25%"><h4>Price</h4></td>
    <td width="24%"><h4>Qty.</h4></td>
    <td width="27%"><h4>Total Price</h4></td>
    </tr>
    <tr>
    <td><input name="textfield" size="25"></td>
    <td><input name="textfield2" size="24"></td>
    <td><input name="textfield3" size="22"></td>
    <td><input name="textfield4" size="26"></td>
    </tr>
    <tr>
    <td><input name="textfield5" size="25"></td>
    <td><input name="textfield6" size="24"></td>
    <td><input name="textfield7" size="22"></td>
    <td><input name="textfield8" size="26"></td>
    </tr>
    <tr>
    <td><input name="textfield9" size="25"></td>
    <td><input name="textfield10" size="24"></td>
    <td><input name="textfield11" size="22"></td>
    <td><input name="textfield12" size="26"></td>
    </tr>
    <tr>
    <td><input name="textfield16" size="25"></td>
    <td><input name="textfield15" size="24"></td>
    <td><input name="textfield14" size="22"></td>
    <td><input name="textfield13" size="26"></td>
    </tr>
    <tr>
    <td><input name="textfield17" size="25"></td>
    <td><input name="textfield18" size="24"></td>
    <td><input name="textfield19" size="22"></td>
    <td><input name="textfield20" size="26"></td>
    </tr>
    <tr>
    <td><input name="textfield24" size="25"></td>
    <td><input name="textfield23" size="24"></td>
    <td><input name="textfield22" size="22"></td>
    <td><input name="textfield21" size="26"></td>
    </tr>
    <tr>
    <td><input name="textfield25" size="25"></td>
    <td><input name="textfield26" size="24"></td>
    <td><input name="textfield27" size="22"></td>
    <td><input name="textfield28" size="26"></td>
    </tr>
    <tr>
    <td colspan="3"><strong>Total Price</strong></td>
    <td><input name="total_price" size="26"></td>
    </tr>
    </table>

    <p>
    <input type="submit" name="Submit" value="Submit">
    </p>
    <p> </p>
    </form>
    <P></P>
    </body>
    </html>
     
    rapa

    rapa

    Member
    May 5, 2006
    17,049
    48
    0
    සසර ගමන තුළ
    $SQL="INSERT INTO Customer_Details (Name, Address, Contact_No, Total_Price)
    VALUES
    ('$_POST[Name]','$_POST[Address]','$_POST[Contact_No]','$_POST[Total_Price]')";

    uda eka enna oni menna mehema :D
    balanna wenasa mokadda kiyala

    $SQL="INSERT INTO Customer_Details (Name, Address, Contact_No, Total_Price)
    VALUES
    ('{$_POST['Name']}','{$_POST['Address']}','{$_POST['Contact_No']}','{$_POST['Total_Price']}')";
     
    Last edited:
    senewimala1988

    senewimala1988

    Well-known member
  • Dec 5, 2007
    7,709
    2,578
    113
    Kadawatha, Sri Lanka
    rapa said:
    $SQL="INSERT INTO Customer_Details (Name, Address, Contact_No, Total_Price)
    VALUES
    ('$_POST[Name]','$_POST[Address]','$_POST[Contact_No]','$_POST[Total_Price]')";

    uda eka enna oni menna mehema :D
    balanna wenasa mokadda kiyala

    $SQL="INSERT INTO Customer_Details (Name, Address, Contact_No, Total_Price)
    VALUES
    ('{$_POST['Name']}','{$_POST['Address']}','{$_POST['Contact_No']}','{$_POST['Total_Price']}')";
    Click to expand...

    Machan this is a real hell!!!:frown::frown::frown:
    Meke HTML ekata details dala submit karana kota display vena PHP file eke mukuth ne!!Empty!!!
    browser eken http://localhost/Customer_Details.php dammama " Could not connect: Access denied for user: 'root@localhost' (Using password: NO)" kiyala enava!!!Mokada karanne!!!
    :frown::frown::frown::baffled::baffled::baffled::oo::oo::oo::oo:
     
    rapa

    rapa

    Member
    May 5, 2006
    17,049
    48
    0
    සසර ගමන තුළ
    senewimala1988 said:
    Machan this is a real hell!!!:frown::frown::frown:
    Meke HTML ekata details dala submit karana kota display vena PHP file eke mukuth ne!!Empty!!!
    browser eken http://localhost/Customer_Details.php dammama " Could not connect: Access denied for user: 'root@localhost' (Using password: NO)" kiyala enava!!!Mokada karanne!!!
    :frown::frown::frown::baffled::baffled::baffled::oo::oo::oo::oo:
    Click to expand...

    ithin macho oya pehediliwa kiyala thiyenne :D
    "Access denied for user"

    oayage connection string eke

    $con=mysql_connect("localhost","root","");

    oya blank thiyala thiyenne "" anna athenata apache2tried install karaddi deep password eka denna oni
     
    senewimala1988

    senewimala1988

    Well-known member
  • Dec 5, 2007
    7,709
    2,578
    113
    Kadawatha, Sri Lanka
    rapa said:
    ithin macho oya pehediliwa kiyala thiyenne :D
    "Access denied for user"

    oayage connection string eke

    $con=mysql_connect("localhost","root","");

    oya blank thiyala thiyenne "" anna athenata apache2tried install karaddi deep password eka denna oni
    Click to expand...
    Mmmmmmmmmmm..I will try!!!Thank u very much!!!ada udenama log vela vage!!!Anyway thanx again!!!
     
    rapa

    rapa

    Member
    May 5, 2006
    17,049
    48
    0
    සසර ගමන තුළ
    senewimala1988 said:
    Mokak!!!ane sorry rapa ayye!!!
    Click to expand...
    oyage thread ekata reply karapu gaman mail ekaka enna mama dala thiyenne
    ithin mail ekaka awoth dannawane oya mekata reply ekaka dala kiyala ;)
    ehema thamai mama awe :lol:
    ha ha panditha kam thiyala wede karapanko ikamanata oka iwara karala danna ;)
     

    Similar threads

    geeko
    PHP, JS, Ajax දන්න අයගෙන් උදව්වක් ඕනේ
    Replies
    25
    Views
    2K
    hodakolla
    hodakolla
    SL MULTIMEDIA TUTORIAL
    Code Error eka hadaganna help..
    Replies
    11
    Views
    1K
    HAneo
    HAneo
    oxide
    PHP උදව්වක්..
    Replies
    10
    Views
    768
    oxide
    oxide
    indi8305
    php waddo.....
    Replies
    6
    Views
    1K
    delmar
    delmar
    isurutmv
    PHP PDO Help ekak
    Replies
    4
    Views
    740
    CorD SaC
    CorD SaC
    Top Bottom