Results 1 to 7 of 7

Thread: Mysql & php question.
      
   

  1. #1
    Join Date
    Feb 2006
    Location
    Kings Lynn Norfolk UK
    Posts
    8,702

    Default Mysql & php question.

    Hi, I am trying to get a comments script working & I think I am stumbling at where to place this part of the script, & if it is needed. I think everything has installed ok & have created a database. But canít seem to get it working. The comments form is at this LINK

    Hope you can help.

    Thanks.

    CREATE TABLE `comments` (
    `commentid` int(11) NOT NULL auto_increment,
    `tutorialid` int(11) NOT NULL default '0',
    `name` text NOT NULL,
    `url` text NOT NULL,
    `comment` text NOT NULL,
    `email` text NOT NULL,
    `date` datetime NOT NULL default '0000-00-00 00:00:00',
    PRIMARY KEY (`commentid`),
    KEY `tutorialid` (`tutorialid`)
    )

  2. #2
    Join Date
    Oct 2005
    Location
    Italy
    Posts
    12,080

    Default Re: Mysql & php question.

    Chris, if this was PHP, it would usually be part of the installation wizard, if your script has one. It creates the necessary table "comments" with the relevant fields in the database. And, it is only run once, unless you drop the table in which case you would need to recreate them.
    Now, since i see that this is not php but directly mySQL instructions, i suppose that the script autor has provided it so you can copy / paste it directly in the phpMyAdmin query section, in order to create the tables semi-automatically.

    However, you don't necessarily have to follow this method. You can create the table "comments" manually using phpMyAdmin, according to field properties described above.
    Navaldesign
    Logger Lite: Low Cost, Customizable, multifeatured Login script
    Instant Download Cart: a Powerfull, Customized, in site, DB driven, e-products Cart
    DBTechnosystems.com Forms, Databases, Shopping Carts, Instant Download Carts, Loggin Systems and more....
    Advanced BlueVoda Form Processor : No coding form processor! Just install and use! Now with built in CAPTCHA!


  3. #3
    Join Date
    Feb 2006
    Location
    Kings Lynn Norfolk UK
    Posts
    8,702

    Default Re: Mysql & php question.

    Hi George. No joy! But not to worry, I wonít go to far with this one if itís not a simple fix. Just out of curiosity to if the tables are set up with what I done. Took an image of the page.?

    Thanks for your time.


  4. #4
    Join Date
    Oct 2005
    Location
    Italy
    Posts
    12,080

    Default Re: Mysql & php question.

    Your database table seems correctly created in phpMyAdmin. If it doesn't work, there must be other issues.

    MySQL will send out specific messages if the table structure doesn't correspond to what the script expects to find, so if it waere a table problem you would have known.
    Navaldesign
    Logger Lite: Low Cost, Customizable, multifeatured Login script
    Instant Download Cart: a Powerfull, Customized, in site, DB driven, e-products Cart
    DBTechnosystems.com Forms, Databases, Shopping Carts, Instant Download Carts, Loggin Systems and more....
    Advanced BlueVoda Form Processor : No coding form processor! Just install and use! Now with built in CAPTCHA!


  5. #5
    Join Date
    Feb 2006
    Location
    Kings Lynn Norfolk UK
    Posts
    8,702

    Default Re: Mysql & php question.

    Strange one! Not sure what went wrong here. But thanks for looking.

  6. #6
    Join Date
    Aug 2007
    Posts
    2

    Default Re: Mysql & php question.

    Can I bulilt a login page with php or my sql? How can I create a register and login page with password, which let my website user create their own page and login to their home page? I'm really need that information. Hope anyone can help me!!! Please send a copy of your answer to my email chang5311201******.com

  7. #7
    Join Date
    Oct 2005
    Location
    Italy
    Posts
    12,080

    Default Re: Mysql & php question.

    As a forum policy answers are provided on the forum so other users can benefir also.

    Yes, you can create a login script using BV, php and MySQL (or only php / MySQL). However, a complete login script is rather complicated and from what i understand, you don't have any php / MySQL knowledge.

    Have a look at this example made in BV (with php additional coding)
    Navaldesign
    Logger Lite: Low Cost, Customizable, multifeatured Login script
    Instant Download Cart: a Powerfull, Customized, in site, DB driven, e-products Cart
    DBTechnosystems.com Forms, Databases, Shopping Carts, Instant Download Carts, Loggin Systems and more....
    Advanced BlueVoda Form Processor : No coding form processor! Just install and use! Now with built in CAPTCHA!


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

     

Posting Permissions

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