Question

Good use-case for a Function ?

I have a standalone PHP script which is 192K (~3500 lines) that takes an array as user input and returns an huge array of numerous calculations that exists in an XLSX file which I mapped one-by-one in PHP code.

  1. Does this sound as a good use-case for a Function ?
  2. Can I connect it to a MySQL database on a droplet, if required or would be able to connect it to only a dedicated MySQL instance ?
  3. How can I pre-calculate the billing for this script / function ?

Submit an answer


This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

Sign In or Sign Up to Answer

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Rodric Rabbah
DigitalOcean Employee
DigitalOcean Employee badge
May 27, 2022
Accepted Answer

You can use a DBaaS instance for the database with your function. We have a couple of examples see here https://github.com/digitalocean/sample-functions-todo and another example https://github.com/rabbah/vitals/blob/master/packages/vitals/records/index.js. I realize these are in JavaScript but using an equivalent library for PHP and adding them to your function dependencies via composer would also work. We should create a php sample or if you’d like to contribute one I’m happy to help. Here is an example php project with dependencies https://github.com/digitalocean/sample-functions-php-numberstowords.

Rodric Rabbah
DigitalOcean Employee
DigitalOcean Employee badge
May 27, 2022

I came across this blog post that is very nice and also uses a DB from a PHP function, thought you might enjoy it https://devdojo.com/bobbyiliev/how-to-use-materialize-with-digitalocean-serverless-functions

Try DigitalOcean for free

Click below to sign up and get $200 of credit to try our products over 60 days!

Sign up

Become a contributor for community

Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.

DigitalOcean Documentation

Full documentation for every DigitalOcean product.

Resources for startups and SMBs

The Wave has everything you need to know about building a business, from raising funding to marketing your product.

Get our newsletter

Stay up to date by signing up for DigitalOcean’s Infrastructure as a Newsletter.

New accounts only. By submitting your email you agree to our Privacy Policy

The developer cloud

Scale up as you grow — whether you're running one virtual machine or ten thousand.

Get started for free

Sign up and get $200 in credit for your first 60 days with DigitalOcean.*

*This promotional offer applies to new accounts only.