Alex (inpotentia) wrote in lj_clients,

Databases in PHP

Thanks to all your help I now have my SMS2lj client written and working as well as I can tell without actually having access to test it with a SMS yet.

I've hit a snag though on writing the page where people can enter their details into a ddatabase. I can not get the script to update the database. It's not throwing up any errors.

The code I am using in PHP is:
$conn = new COM("ADODB.Connection") or die("Cannot start ADO");
$conn->Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("user.mdb"));
$conn->Execute ("INSERT INTO user VALUES ('${mobile}', '${user}', '${pass}',' ${GMT}')");
Can anyone see anything obviously wrong with this?

  • 302: lj_dev

    In the interests of consolidating all LiveJournal development-related discussion, we're going to be closing down this community. The same…

  • Plain text to LJ

    I have an old blog from xanga that's in html/plain text and I want to move it over here. Which client would be the best to do this? I also want to…

  • ljKlient 0.2.0 Preview Release 1

    Today marks another milestone in the development of ljKlient — as the first preview of the 0.2 series is released.  Please go to the project…

  • Post a new comment


    Comments allowed for members only

    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened