Welcome Guest, Not a member yet? Register   Sign In
Search Results
    Thread: Named variables in sql query
Post: RE: Named variables in sql query

InsiteFX Wrote: (06-26-2021, 05:41 AM) -- Try this one, no time to test right now busy. You need to pass in the start and end strings for the dates to search. PHP Code: -- $sql = 'SELECT MONTHNAM...
755 Views
6 Replies
06-29-2021, 06:42 AM
stepgr
    Thread: Named variables in sql query
Post: RE: Named variables in sql query

InsiteFX Wrote: (06-26-2021, 01:51 AM) -- Try this, not tested but fixes some errors in your code see the quotes and semi-colons at the end. PHP Code: -- $sql = 'SELECT MONTHNAME (itd.DateOfshippm...
755 Views
6 Replies
06-26-2021, 02:17 AM
stepgr
    Thread: Named variables in sql query
Post: Named variables in sql query

HI, I have this query which runs perfect on plain sql (phpmyadmin etc) : Code: -- SELECT MONTHNAME (itd.DateOfshippment) AS Month ,COUNT(itm.Name) AS Operations FROM ImportsMaster itm INNER JO...
755 Views
6 Replies
06-26-2021, 01:03 AM
stepgr
    Thread: Populate form_multiselect from SET values ?
Post: RE: Populate form_multiselect from SET values ?

iRedds Wrote: (01-19-2021, 09:47 PM) -- $sdept = explode(',', $fieldFromTable) -- Thanks mate , I have already tried that but there was some additional steps in order for it to work and you neede...
1,246 Views
2 Replies
01-20-2021, 12:20 PM
stepgr
    Thread: Populate form_multiselect from SET values ?
Post: Populate form_multiselect from SET values ?

Hi guys, I have a simple table  and one of the columns is   SET type (mariadb) . I have found this way to insert values when adding records to the table (with a default selected value): In my V...
1,246 Views
2 Replies
01-19-2021, 03:07 AM
stepgr
    Thread: Report page with multiple Parts/Sections
Post: RE: Report page with multiple Parts/Sections

FlavioSuar Wrote: (10-26-2020, 10:21 AM) -- Hi, sorry if I'm too noobie in my answer... :-) I recently found halfmoon, wich could be great for a one-page-with-a-save-button solution: "Halfmoon is...
1,599 Views
6 Replies
10-27-2020, 02:54 AM
stepgr
    Thread: Report page with multiple Parts/Sections
Post: RE: Report page with multiple Parts/Sections

Thanks for answering , I have no experience with JS (just started an online tutor on it ) . I get the idea OK . I already made some other work with CI but it was much simpler , for this I figured ...
1,599 Views
6 Replies
10-25-2020, 02:01 AM
stepgr
    Thread: Report page with multiple Parts/Sections
Post: Report page with multiple Parts/Sections

Hi guys , I'm lost at this so I want an opinion if it's doable  : I was asked to see if I can create an online version of a report we now do in excel. The report is quite big around 50 pages  ...
1,599 Views
6 Replies
10-24-2020, 03:47 AM
stepgr
    Thread: easytables FPDF
Post: RE: easytables FPDF

vitnibel Wrote: (09-20-2020, 09:56 PM) -- Working example with CI4 & easeTable extension of FPDF library: PHP Code: -- -- I see no point in transferring such code to the view The result of ...
935 Views
2 Replies
09-21-2020, 12:00 AM
stepgr
    Thread: easytables FPDF
Post: easytables FPDF

Hi folks, I'm trying to get to grips with Ci4  usinng working code from version 3 . One of the tasks I have is to produce a pdf from a query .  In CI 3  I'm using  fpdf library with easytables...
935 Views
2 Replies
09-20-2020, 11:15 AM
stepgr
    Thread: FPDF
Post: RE: FPDF

vitnibel Wrote: (09-11-2020, 08:10 PM) -- pws Wrote: (09-10-2020, 02:45 AM) -- hello @niklas can you send me full code example how use fpdf? i need it to my website -- Hello @pws Copy fpdf libr...
7,979 Views
6 Replies
09-19-2020, 02:33 AM
stepgr
  Smile Thread: INNER JOIN USING
Post: RE: INNER JOIN USING

Well to answer my own question  in case some other newbie falls into the same pit I had to alter the statement  from $builder->join('vehicles', 'e.idvehicles = vehicles.idvehicles'); to $builder...
528 Views
1 Replies
06-28-2020, 09:50 AM
stepgr
    Thread: INNER JOIN USING
Post: INNER JOIN USING

I have this in my normal query  : INNER JOIN vehicles USING(idvehicles) but  in active record using this : $builder->join('vehicles', 'e.idvehicles = vehicles.idvehicles'); does not retu...
528 Views
1 Replies
06-27-2020, 09:57 AM
stepgr
    Thread: Generated SQL query in 4
Post: RE: Generated SQL query in 4

Thanks , very helpful .
594 Views
2 Replies
06-27-2020, 07:18 AM
stepgr
    Thread: Generated SQL query in 4
Post: Generated SQL query in 4

Hi all, very new to CI and after a short time in v3 I started to getting familiar with v4 . I have some ready sql queries (from phpmyadmin) that I would like to put into  a model . I have trouble ...
594 Views
2 Replies
06-27-2020, 03:17 AM
stepgr
    Thread: Master & Detail records in same page?
Post: Master & Detail records in same page?

HI all, I'm very new to codeigniter so please forgive my ignorance.  I have a master table (say orders) and a detail table ( say order_details). I'm actually using the sample database from mysql ...
1,228 Views
1 Replies
02-20-2020, 02:13 AM
stepgr

Theme © iAndrew 2016 - Forum software by © MyBB