CodeIgniter Forums - Search Results

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...

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...

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...

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...

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...

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...

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 ...

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 ...

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 ...

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...

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...

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...

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...

Thread: Generated SQL query in 4
Post: RE: Generated SQL query in 4

Thanks , very helpful .

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 ...

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 ...