Implementing non framework code into a framework such as laravel or codeigniter

Question

I'm trying to implement AJAX Booking Calendar Pro into my Laravel application. (It was purchased from CodeCanyon) I've implemented most of the plugin, I just need to figure out how to connect it to the database so I can save and display the information. I'm using the controller approach. The start of the js file looks like this..

(function($)
{
    $.fn.DOPBookingCalendar = function(options)
    {
        var Data = {'Type':'BackEnd',
                'DataURL':'/php/load.php',
                'SaveURL':'/php/save.php',
                'DayNames':['Sunday', 'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday'],
                'MonthNames':['January', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December'],
                'AvailableText':'AVAILABLE', // The available text.
                'BookedText':'BOOKED', // The Booked text.
                'UnavailableText':'NOT AVAILABLE', // The unavailable text.
                'DateType':1, // 1: american style; 2: european style;
                'PopupDisplayTime':300, // The time for the Pop-Up to Show/Hide
                'StatusLabel':'Status', // The text for Availability label.
                'PriceLabel':'Price', // The text for Price label.
                'Currency':'$', // The currency.
                'SubmitBtnText':'Submit', // The text for Submit button.
                'ResetBtnText':'Reset', // The text for Reset button.
                'ExitBtnText':'Exit', // The text for Exit button.
                'InvalidPriceText':'Error! Please enter a number for the price.' // The text for Invalid Price Warning.
               },

It seems to me that I it could be something as simple as setting the DataURL and SaveURL to a controller/model ... but how would I connect the database, and how do I know what fields the table would have? Hopefully someone will have experience with this.

//This is the save query

if (isset($_POST['dop_booking_calendar'])){
    require_once 'opendb.php';
    mysql_query('UPDATE schedule SET data="'.$_POST['dop_booking_calendar'].'" WHERE id=1');
}

//this is the load query

require_once 'opendb.php';

$query = mysql_query('SELECT * FROM schedule WHERE id=1');

while ($result=mysql_fetch_array($query)){
    echo $result['data'];
}

Stefan Neubig · Accepted Answer · 2012-11-03 23:03:15Z

3

I think you should rewrite the Database Connection and Communication Part of the script and replace it with Laravels query builder.

E.g. change

mysql_query('SELECT * FROM schedule WHERE id=1');

Into:

$schedule = DB::query('SELECT * FROM schedule WHERE id=1');

answered Nov 3, 2012 at 23:03

Stefan Neubig

1,0381 gold badge8 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

coryj Over a year ago

Thanks, that helped me out a lot. Making some progress now.

John C. Derrick · Accepted Answer · 2012-11-09 19:48:00Z

0

This may be obvious to some, but it took me a while since I'm new to working directly with mySQL and PHP. But I discovered I had to create a database called "schedule" along with two rows called "id" and "data" which allows the calendar to write data to them.

But I'm also getting stumped on the load.php file. I have successfully gotten the calendar to write data to the database using save.php, but the load.php file isn't retrieving the data. Very weird. I've tried the method Stefan provided, but still without any luck.

Anyone know how to retrieve the data from the database noted above? Here's my full load.php file.

<?php
    require_once 'opendb.php';

    $query = mysql_query('SELECT * FROM schedule WHERE id=1');

    while ($result=mysql_fetch_array($query)){
        echo $result['data'];
    }

?>

answered Nov 9, 2012 at 19:48

John C. Derrick

771 gold badge1 silver badge6 bronze badges

1 Comment

coryj Over a year ago

what's working for me is that instead of echo'ing $result['data'] I'm doing var_dump($result[data]); I'm using a PHP framework called Laravel.

Collectives™ on Stack Overflow

Implementing non framework code into a framework such as laravel or codeigniter

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related