Announcement

#1 2013-07-28 19:40:31

jessepunter
Member
England
2013-04-23
44

Adding custom MYSQL table and insert/update from Additional Page

Hi all,

Love Piwigo, managed to produce a site to help sell my partners greetings cards and, with a lot of trial and error and tons of additional hours, I'm pretty much finished. However, I have one little problem left that I'm hoping some of you fantastic helpers can aid me. I have added a couple of database tables to the piwigo database which I need to insert and update order details but I'm unsure how to go about using MySQL calls through an additional page.

Are there any functions I can call or pages I need to include to ensure I can access the MYSQL database and insert/update/delete records?

I am still relatively new to Piwigo so am struggling a little with this type of enhancement.

Thanks in advance!
Simon.


I'm no expert, I'm basically a beginner with an alter ego!
My sites:
My First Piwigo Site
My Hobby Site

Offline

 

#2 2013-07-28 19:48:07

mistic100
Former Piwigo Team
Lyon (FR)
2008-09-27
3277

Re: Adding custom MYSQL table and insert/update from Additional Page

Hi

sorry you can't do that, only HTML can be added in an Additional Page

you will need a totally independant page made by yourself, or a personal plugin

Offline

 

#3 2013-07-28 20:29:35

jessepunter
Member
England
2013-04-23
44

Re: Adding custom MYSQL table and insert/update from Additional Page

Okay, going to be a challenge but I'll have a go!
In that case, is there any thing I can include in my stand-alone page to access the db connections for the piwigo database? php scripts? constants? Or do I need to define them again from scratch?

Thanks again!


I'm no expert, I'm basically a beginner with an alter ego!
My sites:
My First Piwigo Site
My Hobby Site

Offline

 

#4 2013-07-28 20:39:13

mistic100
Former Piwigo Team
Lyon (FR)
2008-09-27
3277

Re: Adding custom MYSQL table and insert/update from Additional Page

it would be much easier to create a plugin (there is many help ine the doc)

Offline

 

#5 2013-07-28 21:22:40

jessepunter
Member
England
2013-04-23
44

Re: Adding custom MYSQL table and insert/update from Additional Page

Okay, I'll take a voyage into the unknown and try to figure it out.

Thanks for your input mistic100.


I'm no expert, I'm basically a beginner with an alter ego!
My sites:
My First Piwigo Site
My Hobby Site

Offline

 

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2024 · Contact