Welcome Guest, Not a member yet? Register   Sign In
Search Results
    Thread: Calling a MySql function
Post: RE: Calling a MySql function

InsiteFX Wrote: (04-29-2019, 03:50 AM) -- Not sure but maybe this will help. Emulating nextval() function to get sequence in MySQL (http://www.microshell.com/database/mysql/emulating-nextval-funct...
2,938 Views
5 Replies
04-29-2019, 09:00 PM
Shawn
    Thread: Calling a MySql function
Post: RE: Calling a MySql function

Shawn Wrote: (04-28-2019, 09:30 PM) -- Shawn Wrote: (04-28-2019, 07:37 PM) -- I have created a function in mysql called NextVal that requires a string parameter and returns an integer. I tried the ...
2,938 Views
5 Replies
04-28-2019, 09:40 PM
Shawn
    Thread: Calling a MySql function
Post: RE: Calling a MySql function

Shawn Wrote: (04-28-2019, 07:37 PM) -- I have created a function in mysql called NextVal that requires a string parameter and returns an integer. I tried the following code: Code: -- public fun...
2,938 Views
5 Replies
04-28-2019, 09:30 PM
Shawn
    Thread: Calling a MySql function
Post: Calling a MySql function

I have created a function in mysql called NextVal that requires a string parameter and returns an integer. I tried the following code: Code: -- public function next_value() {     $ci =& get_instan...
2,938 Views
5 Replies
04-28-2019, 07:37 PM
Shawn
    Thread: Dynamic generated dropdown value is not passed to controller after page refresh.
Post: RE: Dynamic generated dropdown value is not passed...

Are you passing back a new csrf hash when your controller responds to the AJAX call? Normally you get an access forbidden error if you don't, but maybe it's buried. Code: -- $ajax_data['csrf_tok...
3,534 Views
6 Replies
01-07-2019, 06:05 PM
Shawn
    Thread: qantities are not writted in the db
Post: RE: qantities are not writted in the db

You will need to learn more about codeigniter. You will need to become familiar with the concepts of model, view, and controller. css is in the view. Changes to view (css, javascript, html, embedded ...
1,640 Views
1 Replies
05-07-2018, 12:44 PM
Shawn
    Thread: Optimization on Nested Loop
Post: RE: Optimization on Nested Loop

Data intensive operations are easier to optimize inside the database. If possible your looping/subquery should be done in SQL. The first big hit this avoids is the repetitive database I/O between yo...
5,124 Views
7 Replies
12-22-2017, 03:04 PM
Shawn
    Thread: & get_instance()
Post: RE: & get_instance()

InsiteFX Wrote: (10-04-2017, 02:00 AM) -- If your not going to use hooks then why is your Login.php Library in the hooks folder? Also it depends on whats been loaded see Codeigniter.php and Loader...
3,784 Views
2 Replies
10-08-2017, 08:21 PM
Shawn
    Thread: Enter Dollar Amounts Into Database
Post: RE: Enter Dollar Amounts Into Database

wolfgang1983 Wrote: (10-06-2017, 01:40 AM) -- neuron Wrote: (10-06-2017, 01:31 AM) -- As u can see in your table structure,  the column types of cash_total_value and gift_card_value are type of DEC...
3,062 Views
3 Replies
10-08-2017, 08:03 PM
Shawn
    Thread: Cant figure out this intermitten problem DNS 500
Post: RE: Cant figure out this intermitten problem DNS 5...

ciadvantage Wrote: (08-26-2017, 09:17 AM) -- dave friend Wrote: (08-25-2017, 01:07 PM) -- Some things to try Look for matching error messages in the Web server log files Check server load statis...
2,910 Views
4 Replies
08-27-2017, 05:23 PM
Shawn
    Thread: csrf, ajax and form
Post: RE: csrf, ajax and form

theedo Wrote: (08-05-2017, 06:16 AM) -- InsiteFX Wrote: (08-05-2017, 05:29 AM) -- Google Search is your friend. You can try this, it uses the jQuery Cookie Plugin was written for CodeIgniter 2.x bu...
4,572 Views
4 Replies
08-09-2017, 12:20 PM
Shawn
    Thread: CI Way of Using Own Classes / Code
Post: RE: CI Way of Using Own Classes / Code

What you are doing above is a good start. You have to reference the full path name to any class that you want to instantiate with new(). If you use composer then you can load your classes or APIs ...
5,411 Views
4 Replies
02-18-2017, 09:58 AM
Shawn
    Thread: Database transaction error handling
Post: RE: Database transaction error handling

RastoStric Wrote: (02-25-2015, 01:19 AM) -- Thank you for your comment. However I think that it would be quite the same as in my case; moreover for error handling I prefer exceptions. Anyway, your co...
10,072 Views
3 Replies
01-04-2017, 07:55 PM
Shawn
    Thread: Best practice selecting data from related models
Post: RE: Best practice selecting data from related mode...

I agree with your intuition that person should not provide or manage comments. The comments model in both cases would be your primary domain of interest. If you are being terribly oop then your $this...
2,908 Views
2 Replies
11-21-2016, 05:51 PM
Shawn
    Thread: How can I hide content id on URL
Post: RE: How can I hide content id on URL

olmos Wrote: (10-20-2016, 06:42 AM) -- Hi Everyone. Firstly Sorry for my bad engelish.  Firstly my url : explame.com/olmos/id/content-title/ So I want to hide /id/ from the URL. So my r...
12,311 Views
11 Replies
10-20-2016, 03:15 PM
Shawn
    Thread: How should I use DB Transactions
Post: RE: How should I use DB Transactions

wolfgang1983 Wrote: (09-02-2016, 12:54 AM) -- I have now done it this way but if there is a error on my file upload section how to roll it back also. PHP Code: --
4,212 Views
4 Replies
09-02-2016, 05:52 PM
Shawn
    Thread: How should I use DB Transactions
Post: RE: How should I use DB Transactions

wolfgang1983 Wrote: (09-01-2016, 02:12 AM) -- I would like to be able to use Codeigniter Database Transactions (http://www.codeigniter.com/user_guide/database/transactions.html). But I am new to this...
4,212 Views
4 Replies
09-01-2016, 09:32 PM
Shawn
    Thread: ci-3 how to create admin without duplicating core files
Post: RE: ci-3 how to create admin without duplicating c...

I found the following controller hierarchy useful: The base controller (called MY_Controller and extends CI_Controller) does not check for login: any controller that extends it is open to the public....
8,175 Views
11 Replies
07-10-2016, 08:44 PM
Shawn
    Thread: Blank document when downloading word file just created.
Post: RE: Blank document when downloading word file just...

This is the solution I arrived at: I created as directory structure at the same level of the application and system directory (outside the public html) assets\templates\receipt_template.docx assets...
4,882 Views
3 Replies
06-14-2016, 07:23 PM
Shawn
    Thread: Blank document when downloading word file just created.
Post: RE: Blank document when downloading word file just...

InsiteFX Wrote: (06-10-2016, 04:18 AM) -- If a file is open it cannot be modified. -- How do I ensure that the file has been closed after the TemplateProcessor->saveAs statement, before attempting ...
4,882 Views
3 Replies
06-10-2016, 08:13 AM
Shawn

Theme © iAndrew 2016 - Forum software by © MyBB