Results 1 to 12 of 12

Thread: Connect MS access database in PHP

  1. #1
    zapaaris's Avatar
    zapaaris is offline Senior Member+
    Last Online
    30th September 2016 @ 10:27 PM
    Join Date
    11 Feb 2010
    Location
    Karachi
    Age
    39
    Posts
    161
    Threads
    9
    Credits
    241
    Thanked
    33

    Thumbs up Connect MS access database in PHP

    try this code for connection to an access database

    <?php
    $databaseConnection = new COM("ADODB.Connection");
    $connectionString = "DRIVER={Microsoft Access Driver (*.mdb)};
    DBQ=". realpath("D:\My Database\databaseName.mdb").";";
    $databaseConnection->open($connectionString);
    $resultSet = $databaseConnection->execute("SELECT * FROM tableName ");
    $field1 = $rS->Fields("tableColumn1Name");
    $field2 = $rS->Fields("tableColumn2Name");
    $field3 = $rS->Fields("tableColumn3Name");
    print "<table>";
    while (!$rS->EOF)
    {
    print " <tr><td>".$field1->value." </td><td>".$field2->value." </td><td>".$field3->value." </td><td></tr>"
    $resultSet->MoveNext();
    }
    print "</table>";
    $resultSet->Close();
    $databaseConnection->Close();
    ?>


    Step1:
    ڈیٹا بیس سے کنیکشن بنائیں.مائکرو سافٹ کی فراہم کردہ
    COM
    کمانڈ کے زریعے
    $databaseConnection = new COM("ADODB.Connection");
    ADODB کا مطلب ہے Active Data Objects DataBase
    Step2:
    ایک ویری ایبل لیں جس میں ایکسیس ڈیٹا بیس کا ڈرائیور لوڈ کریں.
    $connectionString = "DRIVER={Microsoft Access Driver (*.mdb)};
    Step3:
    ڈیٹابیس قیوری کے آبجیکٹ میں اپنے ڈیٹا بیس کا پاتھ دیں.
    DBQ=". realpath("D:\My Database\databaseName.mdb").";";
    Step4:
    connectionStringابھی ڈرائیور کا جو ویری ایبل ہم نے
    میں سٹور کیا تھااسکا ریفرینس
    کو پاس کر دیں databaseConnection
    $databaseConnection->open($connectionString);
    اور ڈیٹا بیس سے کنیکٹ ہو جائیں
    Step5:
    آبجیکٹ کے زریعے اپنی قیوری رن کریں databaseConnection
    $resultSet = $databaseConnection->execute("SELECT * FROM tableName ");
    Step6:
    ابھی اپنے ٹیبل کے تمام کالمز کی ویلیوز کو ایک ٹیبل کی صورت میں پرنٹ کرا لیں.
    کی جگہ آپ اپنے ڈیٹا بیس کے ٹیبل میں موجود کالمز کے نام لکیں گے tableColumn1Name,tableColumn2Name,tableColumn3Name
    ("SELECT * FROM tableName ") ; اسی طرح اوپر
    میں بھی آپ اپنے ٹیبل کا نام دیں گے


    کسی طرح کی کنفیوژن کی صورت میں ضرور بتائیے گا....

  2. #2
    ayub khosa's Avatar
    ayub khosa is offline Advance Member
    Last Online
    25th March 2021 @ 03:09 AM
    Join Date
    01 Apr 2010
    Location
    D G KHAN
    Gender
    Male
    Posts
    602
    Threads
    33
    Credits
    75
    Thanked
    29

    Default

    Thanks bro...

  3. #3
    zapaaris's Avatar
    zapaaris is offline Senior Member+
    Last Online
    30th September 2016 @ 10:27 PM
    Join Date
    11 Feb 2010
    Location
    Karachi
    Age
    39
    Posts
    161
    Threads
    9
    Credits
    241
    Thanked
    33

    Default

    Quote ayub khosa said: View Post
    Thanks bro...
    u r welcome......

  4. #4
    Mudassar 10's Avatar
    Mudassar 10 is offline Senior Member+
    Last Online
    23rd August 2013 @ 02:31 PM
    Join Date
    13 Dec 2010
    Location
    shahar e Iqbal
    Gender
    Male
    Posts
    711
    Threads
    14
    Credits
    0
    Thanked
    19

    Default

    thnx

  5. #5
    RqBukhari's Avatar
    RqBukhari is offline Junior Member
    Last Online
    7th February 2011 @ 02:51 PM
    Join Date
    04 Feb 2011
    Location
    Peshawar
    Gender
    Male
    Posts
    10
    Threads
    0
    Credits
    950
    Thanked
    0

    Default

    very nice.. thnx

  6. #6
    roye_kashif is offline Junior Member
    Last Online
    6th February 2011 @ 01:47 PM
    Join Date
    19 Jan 2011
    Gender
    Male
    Posts
    1
    Threads
    0
    Credits
    0
    Thanked
    0

    Default

    thanks

  7. #7
    udas_palkein is offline Senior Member+
    Last Online
    13th July 2017 @ 01:57 PM
    Join Date
    27 Oct 2009
    Location
    Shahkas ,khyber agency
    Posts
    1,320
    Threads
    97
    Credits
    1,037
    Thanked
    39

    Default

    Gud j0b

  8. #8
    sfweb is offline Junior Member
    Last Online
    10th March 2011 @ 06:35 PM
    Join Date
    10 Mar 2011
    Gender
    Male
    Posts
    22
    Threads
    0
    Credits
    960
    Thanked
    0

    Default

    good job

    Quote ayub khosa said: View Post
    Thanks bro...

  9. #9
    aamir uddin is offline Junior Member
    Last Online
    19th March 2011 @ 12:09 AM
    Join Date
    18 Mar 2011
    Age
    35
    Gender
    Male
    Posts
    1
    Threads
    0
    Credits
    0
    Thanked
    0

    Default

    this is very nice and educational website im new and im trying to learn from your web.

  10. #10
    Haseeb Alamgir's Avatar
    Haseeb Alamgir is offline Super Moderator
    Last Online
    Yesterday @ 11:34 PM
    Join Date
    09 Apr 2009
    Location
    KARACHI&
    Gender
    Male
    Posts
    19,310
    Threads
    412
    Credits
    39,767
    Thanked
    1813

    Default

    شیئر کرنے کا بہت بہت شکریہ

  11. #11
    yahookillers is offline Senior Member+
    Last Online
    26th June 2014 @ 04:54 PM
    Join Date
    05 May 2009
    Location
    Peshawar Nwfp Pakistan
    Age
    34
    Posts
    541
    Threads
    196
    Credits
    584
    Thanked
    8

    Default

    bahi mein php or database pai kam kar raha hon lakein ab tak en cheezon pai nai poohanca MS ACCESS DATABase .... kiya mujeh koi shortly bata sakta ha k ye kiya ha or kis liye use hota ha ta k mein aj he es pai kam start karun

  12. #12
    zapaaris's Avatar
    zapaaris is offline Senior Member+
    Last Online
    30th September 2016 @ 10:27 PM
    Join Date
    11 Feb 2010
    Location
    Karachi
    Age
    39
    Posts
    161
    Threads
    9
    Credits
    241
    Thanked
    33

    Default

    Quote yahookillers said: View Post
    bahi mein php or database pai kam kar raha hon lakein ab tak en cheezon pai nai poohanca MS ACCESS DATABase .... kiya mujeh koi shortly bata sakta ha k ye kiya ha or kis liye use hota ha ta k mein aj he es pai kam start karun

    Dear shakeel bhai ne yeh course bohat achhay treekay se samjhaya hai...aap bas class no 1 se start le lo...
    aap k liye sirf itna janena filhal kafi hai k...web developement k liye php ko use kia jata hai...jo aap ki website k back end pe kam kerti hai...or database se access or bohat si website ki requirement iss k zriay hasil poori ki jati hain...jab k front end pe aap html, css, flash etc use kertay hain apni website ki look and feel ko achha bnanay k liye....

Similar Threads

  1. Access database help needed
    By golden eagle in forum Ask an Expert
    Replies: 18
    Last Post: 6th February 2013, 05:36 PM
  2. Ms access 2007 database help
    By jimmythoms in forum Ask an Expert
    Replies: 0
    Last Post: 22nd January 2012, 11:53 AM
  3. MS access Database
    By safdar384 in forum Ask an Expert
    Replies: 2
    Last Post: 30th November 2011, 11:45 AM
  4. Help Access Database
    By waris-wbc in forum Ask an Expert
    Replies: 0
    Last Post: 20th September 2011, 08:40 PM
  5. i need a HR database in Ms Access
    By zahidanwar84 in forum Ask an Expert
    Replies: 0
    Last Post: 2nd February 2011, 05:02 PM

Tags for this Thread

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
  •