# phpVMS Database Call Sheet

**URL:** <https://forum.phpvms.net/t/phpvms-database-call-sheet/9181>\
**Category:** Code Snippets\
**Created:** [May 3, 2014, 6:18pm UTC](https://forum.phpvms.net/t/phpvms-database-call-sheet/9181 "2014-05-03T18:18:34Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![StartVM](https://forum.phpvms.net/user_avatar/forum.phpvms.net/startvm/32/327_2.png) [@StartVM](https://forum.phpvms.net/u/StartVM)\
**Post date:** [May 3, 2014, 6:18pm UTC](https://forum.phpvms.net/t/phpvms-database-call-sheet/9181/1 "2014-05-03T18:18:34Z")

</div>

Aloha Everyone! As a former CEO of a VA and a current web developer in self-training, I know how frustrating it is to spend hours playing with code trying to pull elements from your database or, maybe you just don’t know where to find the scripts. To make your job easier, I have gone through the entire phpVMS Installation and pulled every PHP call I could find and compiled it into one document for easy use. If you find any errors, or more PHP calls, please post it here and I will update the original post. Cheers and happy coding!

[http://pastebin.com/ERuvPcmV](http://pastebin.com/ERuvPcmV)

**I have updated this call sheet as of 5/20/14 to correct some bugs**

---

<div class="post-metadata">

**Author:** ![in2tech](https://forum.phpvms.net/user_avatar/forum.phpvms.net/in2tech/32/32_2.png) [@in2tech](https://forum.phpvms.net/u/in2tech)\
**Post date:** [May 3, 2014, 9:12pm UTC](https://forum.phpvms.net/t/phpvms-database-call-sheet/9181/2 "2014-05-03T21:12:13Z")

</div>

What great information…Thank You so much. Now who wants to make up all the other calls like Schedules, Pilot Center. My Flight, etc… unless there already is one : ) Like a dummy when I was first learning to make skin’s from existing templates I was using links like [**http://www.domainname.com/schedules**](http://www.domainname.com/schedules) for schedules instead of \<a href=“**\<?php echo url(‘/Schedules’) ?\>**”\>Schedules\</a\>, of course now I feel really stupid! Took me forever to figure this out. Not to mention every person that downloaded my first (and still some old ones) skins had to change all that. With the codes below it just works, (usually)!

Example from drop down menu:

\<?php echo url(‘/’); ?\> -Home

\<li class=“active”\>\<a href=“\<?php echo url(‘/’); ?\>”\>Home\</a\>\</li\>

\<?php echo url(‘/contact’); ?\> -Contact

\<li\>\<a href=“\<?php echo url(‘/contact’); ?\>”\>Contact Us\</a\>\</li\>

\<?php echo url(‘/Schedules’) ?\> -Schedules

\<li\>\<a href=“\<?php echo url(‘/Schedules’) ?\>”\>Schedules\</a\>

I am always going back to old templates to copy and paste this info. Would love a Master copy with all the codes! Unless one exist!

---

<div class="post-metadata">

**Author:** ![StartVM](https://forum.phpvms.net/user_avatar/forum.phpvms.net/startvm/32/327_2.png) [@StartVM](https://forum.phpvms.net/u/StartVM)\
**Post date:** [May 4, 2014, 12:39am UTC](https://forum.phpvms.net/t/phpvms-database-call-sheet/9181/3 "2014-05-04T00:39:09Z")

</div>

I will add this in thanks!

---

<div class="post-metadata">

**Author:** ![TB1](https://forum.phpvms.net/user_avatar/forum.phpvms.net/tb1/32/366_2.png) [@TB1](https://forum.phpvms.net/u/TB1)\
**Post date:** [May 5, 2014, 8:04am UTC](https://forum.phpvms.net/t/phpvms-database-call-sheet/9181/4 "2014-05-05T08:04:47Z")

</div>

Fantastic stuff mate. Really good job.

---

<div class="post-metadata">

**Author:** ![StartVM](https://forum.phpvms.net/user_avatar/forum.phpvms.net/startvm/32/327_2.png) [@StartVM](https://forum.phpvms.net/u/StartVM)\
**Post date:** [May 20, 2014, 6:35pm UTC](https://forum.phpvms.net/t/phpvms-database-call-sheet/9181/5 "2014-05-20T18:35:39Z")

</div>

\_ **Updated Call Sheet see new link above** \_

---

<div class="post-metadata">

**Author:** ![HighFlyerPL185](https://forum.phpvms.net/user_avatar/forum.phpvms.net/highflyerpl185/32/145_2.png) [@HighFlyerPL185](https://forum.phpvms.net/u/HighFlyerPL185)\
**Post date:** [June 8, 2014, 2:35pm UTC](https://forum.phpvms.net/t/phpvms-database-call-sheet/9181/6 "2014-06-08T14:35:43Z")

</div>

I think this should get pinned, really useful for novice administrators.

---

<div class="post-metadata">

**Author:** ![servetas](https://forum.phpvms.net/user_avatar/forum.phpvms.net/servetas/32/75_2.png) [@servetas](https://forum.phpvms.net/u/servetas)\
**Post date:** [June 8, 2014, 3:39pm UTC](https://forum.phpvms.net/t/phpvms-database-call-sheet/9181/7 "2014-06-08T15:39:44Z")

</div>

Pinned

---

<div class="post-metadata">

**Author:** ![djchema](https://forum.phpvms.net/user_avatar/forum.phpvms.net/djchema/32/392_2.png) [@djchema](https://forum.phpvms.net/u/djchema)\
**Post date:** [June 8, 2014, 3:47pm UTC](https://forum.phpvms.net/t/phpvms-database-call-sheet/9181/8 "2014-06-08T15:47:09Z")

</div>

Great job. Thx a lot

---

<div class="post-metadata">

**Author:** ![Vangelis](https://forum.phpvms.net/user_avatar/forum.phpvms.net/vangelis/32/38_2.png) [@Vangelis](https://forum.phpvms.net/u/Vangelis)\
**Post date:** [June 8, 2014, 5:35pm UTC](https://forum.phpvms.net/t/phpvms-database-call-sheet/9181/9 "2014-06-08T17:35:34Z")

</div>

Very helpfull is the phpvms API [http://docs.phpvms.net/api/packages/Default.html](http://docs.phpvms.net/api/packages/Default.html)

Just click on the class and it will display the calls and how you can use it

---

<div class="post-metadata">

**Author:** ![RafaelLetras](https://forum.phpvms.net/letter_avatar_proxy/v4/letter/r/35a633/32.png) [@RafaelLetras](https://forum.phpvms.net/u/RafaelLetras)\
**Post date:** [June 21, 2017, 1:57pm UTC](https://forum.phpvms.net/t/phpvms-database-call-sheet/9181/10 "2017-06-21T13:57:00Z")

</div>

I need help ,&nbsp;

I can’t make the db calls and the vangelis link is outdated&nbsp;

---

<div class="post-metadata">

**Author:** ![Vangelis](https://forum.phpvms.net/user_avatar/forum.phpvms.net/vangelis/32/38_2.png) [@Vangelis](https://forum.phpvms.net/u/Vangelis)\
**Post date:** [June 22, 2017, 7:12am UTC](https://forum.phpvms.net/t/phpvms-database-call-sheet/9181/11 "2017-06-22T07:12:30Z")

</div>

my website at the moment is under redesign also i want to mention that this api has nothing to do with my site&nbsp;
