php - Pagination in codeigniter. Extra set of values passed in to model and db->limit not working -

-

pagination in codeigniter. can't seem set limit of posts on every page (it shows of them on every page). think links working (they show on uri), not select rows per page.

the model:

public function index(  $limit,$start,      $var1,$var2,$var3,$var4 ){  $sql = "select          trabalho.var1         trabalho.var2         empregos.var3         empregos.var4         trabalho.empregos         join trabalho.empresas         on empregos.id_empresa = empresas.id_empresa                       trabalho.var1 ?         or trabalho.var2 ?         or empregos.var3 ?         or empregos.var4 ?         ;";   $variables_form = array($var1,$var2,$var3,$var4);  $this->db->limit($limit, $start); $query2 = $this->db->query($sql,$variables_form); return $query2->result(); }

the controller:

$config['base_url'] = base_url().'index.php/main_controller/index'; $config['total_rows'] = 10; $config['per_page'] = 5; $config['num_links'] = 2; $config["uri_segment"] = 3; $config['use_page_numbers'] = true; $this->pagination->initialize($config);  $page = ($this->uri->segment(3)) ? $this->uri->segment(3) : 0;  $data["info"] = $this->search_display_m->                     index($config["per_page"], $page,                      $var1 = 'a', $var2 = 'a',                      $var3 = 'a', $var4 = 'a',                     );  $data["links"] = $this->pagination->create_links();

and view:

<?php echo $this->pagination->create_links(); ?>

and there way simplify uri?

this work

public function index(  $limit,$start,      $var1,$var2,$var3,$var4 ){  $sql = "select          trabalho.var1         trabalho.var2         empregos.var3         empregos.var4         trabalho.empregos         join trabalho.empresas         on empregos.id_empresa = empresas.id_empresa                       trabalho.var1 ?         or trabalho.var2 ?         or empregos.var3 ?         or empregos.var4 ?         limit $start, $limit     ;";   $variables_form = array($var1,$var2,$var3,$var4);   $query2 = $this->db->query($sql,$variables_form);  return $query2->result(); }

Comments

Post a Comment

Popular posts from this blog

c# - Store DBContext Log in other EF table -

-
i want store logs in db table (imported ef code). my code looks this: public pmcontext() : base("myentities") { configuration.proxycreationenabled = false; configuration.lazyloadingenabled = false; this.database.log = s => logstore(s); } private void logstore(string message) { tlog log = new tlog(); log.description = message; log.insertdate = datetime.now; logs.add(log); savechanges(); } public virtual dbset<tlog> logs { get; set; } i cannot use savechanges() (get error "sqlconnection not support parallel transactions") , if remove line nothing stored in db table. how can fix this? i think happens during savechanges call anywhere in app, because sql generated call logged, triggers nested savechanges call tries start own transaction. and there thing: savechanges call in logstore method trigger logging itself, you'd end starting infin...
Read more

c# - Display ASPX Popup control in RowDeleteing Event (ASPX Gridview) -

-
i have aspxgridview includes new , delete button. delete button includs gv_rowdeleting event. want show aspxpopupcontrol (id="pupconfirm"). want user have confirm password delete item. tried: protected void gv_rowdeleting(object sender, devexpress.web.data.aspxdatadeletingeventargs e) { pupconfirm.showonpageload = true; } but nothing happened. please me. !!! you can create template column javascript prompt confirmation. <itemtemplate> <asp:linkbutton id="btndelete" runat="server" text="delete" commandname="delete" onclientclick="javascript:if(!confirm('are sure want delete record?')){return false;}"> </asp:linkbutton> </itemtemplate>
Read more

Nuget pack csproj using nuspec -

-
i want create nuget package contains specified in nuspec file, still version csproj. in order use token have pack like: nuget pack myproj.csproj but when adds dependencies , creates unwanted folder in nuget package. nuspec file is: <?xml version="1.0" encoding="utf-8"?> <package xmlns="http://schemas.microsoft.com/packaging/2011/08/nuspec.xsd"> <metadata> <id>test</id> <version>$version$</version> <title>test</title> <authors>test</authors> <owners>test</owners> <requirelicenseacceptance>false</requirelicenseacceptance> <description>test</description> <summary>test</summary> <releasenotes>test</releasenotes> <copyright>test</copyright> </metadata> <files> <file src="bin\debug\*.dll" target="lib\net45" /> <file s...
Read more