| CARVIEW |
Select Language
HTTP/2 302
server: nginx
date: Fri, 16 Jan 2026 13:52:45 GMT
content-type: text/plain; charset=utf-8
content-length: 0
x-archive-redirect-reason: found capture at 20100725002325
location: https://web.archive.org/web/20100725002325/https://codeigniter.com/forums/rss/
server-timing: captures_list;dur=0.486279, exclusion.robots;dur=0.038953, exclusion.robots.policy;dur=0.030089, esindex;dur=0.008516, cdx.remote;dur=8.928111, LoadShardBlock;dur=501.441692, PetaboxLoader3.resolve;dur=84.432093, PetaboxLoader3.datanode;dur=311.096889
x-app-server: wwwb-app217-dc8
x-ts: 302
x-tr: 531
server-timing: TR;dur=0,Tw;dur=0,Tc;dur=0
set-cookie: wb-p-SERVER=wwwb-app217; path=/
x-location: All
x-as: 14061
x-rl: 0
x-na: 0
x-page-cache: MISS
server-timing: MISS
x-nid: DigitalOcean
referrer-policy: no-referrer-when-downgrade
permissions-policy: interest-cohort=()
HTTP/2 200
server: nginx
date: Fri, 16 Jan 2026 13:52:46 GMT
content-type: text/xml; charset=utf-8
x-archive-orig-date: Sun, 25 Jul 2010 00:23:24 GMT
x-archive-orig-server: Apache
x-archive-orig-x-powered-by: PHP/5.3.2-1ubuntu4.2
x-archive-orig-set-cookie: bb2_screener_=1280017404+174.129.228.67; path=/
x-archive-orig-set-cookie: exp_last_activity=1280035404; expires=Mon, 25-Jul-2011 00:23:24 GMT; path=/; domain=.codeigniter.com
x-archive-orig-set-cookie: exp_tracker=a%3A5%3A%7Bi%3A0%3Bs%3A12%3A%22%2Fforums%2Frss%2F%22%3Bi%3A1%3Bs%3A21%3A%22%2Fforums%2Fmember%2F85362%2F%22%3Bi%3A2%3Bs%3A21%3A%22%2Fforums%2Fmember%2F80882%2F%22%3Bi%3A3%3Bs%3A21%3A%22%2Fforums%2Fmember%2F60187%2F%22%3Bi%3A4%3Bs%3A21%3A%22%2Fforums%2Fmember%2F57509%2F%22%3B%7D; path=/; domain=.codeigniter.com
x-archive-orig-expires: Sun, 25 Jul 2010 06:23:24 GMT
x-archive-orig-last-modified: Sun, 25 Jul 2010 05:23:24 GMT
x-archive-orig-cache-control: no-store, no-cache, must-revalidate
x-archive-orig-cache-control: post-check=0, pre-check=0
x-archive-orig-pragma: no-cache
x-archive-orig-connection: close
x-archive-orig-vary: Accept-Encoding, User-Agent
cache-control: max-age=1800
x-archive-guessed-content-type: text/xml
x-archive-guessed-charset: utf-8
memento-datetime: Sun, 25 Jul 2010 00:23:25 GMT
link: ; rel="original", ; rel="timemap"; type="application/link-format", ; rel="timegate"
content-security-policy: default-src 'self' 'unsafe-eval' 'unsafe-inline' data: blob: archive.org web.archive.org web-static.archive.org wayback-api.archive.org athena.archive.org analytics.archive.org pragma.archivelab.org wwwb-events.archive.org
x-archive-src: 52_16_20100725001440_crawl102-c/52_16_20100725002230_crawl100.arc.gz
server-timing: captures_list;dur=2.088621, exclusion.robots;dur=0.018668, exclusion.robots.policy;dur=0.009519, esindex;dur=0.009147, cdx.remote;dur=48.903331, LoadShardBlock;dur=333.734893, PetaboxLoader3.resolve;dur=174.653662, PetaboxLoader3.datanode;dur=166.392904, load_resource;dur=203.670716
x-app-server: wwwb-app217-dc8
x-ts: 200
x-tr: 616
server-timing: TR;dur=0,Tw;dur=0,Tc;dur=0
x-location: All
x-as: 14061
x-rl: 0
x-na: 0
x-page-cache: MISS
server-timing: MISS
x-nid: DigitalOcean
referrer-policy: no-referrer-when-downgrade
permissions-policy: interest-cohort=()
CodeIgniter Forums
https://codeigniter.com/forums/
CodeIgniter Forums
en
Copyright 2010
2010-07-24T19:06:23-06:00
-
Passing data from controller to model in an array. Please help!
https://codeigniter.com/forums/viewthread/162006/
https://codeigniter.com/forums/viewthread/162006/#When:09:37:32Z
<p>Hello!</p>
<p>I am trying to pass an array of POST data from a controller into a model.<br />
How is this done? How can I then access the data in the model?</p>
<p>The controller code look like this (is it correct?):</p>
<div class="codeblock"><code><span style="color: #000000">
<span style="color: #0000BB">$result </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">items_model</span><span style="color: #007700">-></span><span style="color: #0000BB">add</span><span style="color: #007700">( array( <br /> <br /> </span><span style="color: #DD0000">'ite_owner' </span><span style="color: #007700">=> </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">post</span><span style="color: #007700">(</span><span style="color: #DD0000">'user'</span><span style="color: #007700">), <br /> </span><span style="color: #DD0000">'ite_type' </span><span style="color: #007700">=> </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">post</span><span style="color: #007700">(</span><span style="color: #DD0000">'type'</span><span style="color: #007700">),<br /> </span><span style="color: #DD0000">'ite_value_1' </span><span style="color: #007700">=> </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">post</span><span style="color: #007700">(</span><span style="color: #DD0000">'value_1'</span><span style="color: #007700">), <br /> </span><span style="color: #DD0000">'ite_value_2' </span><span style="color: #007700">=> </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">post</span><span style="color: #007700">(</span><span style="color: #DD0000">'value_2'</span><span style="color: #007700">), <br /> </span><span style="color: #DD0000">'ite_value_3' </span><span style="color: #007700">=> </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">post</span><span style="color: #007700">(</span><span style="color: #DD0000">'value_3'</span><span style="color: #007700">), <br /> </span><span style="color: #DD0000">'ite_value_4' </span><span style="color: #007700">=> </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">post</span><span style="color: #007700">(</span><span style="color: #DD0000">'value_4'</span><span style="color: #007700">),<br /> </span><span style="color: #DD0000">'ite_value_5' </span><span style="color: #007700">=> </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">post</span><span style="color: #007700">(</span><span style="color: #DD0000">'value_5'</span><span style="color: #007700">), <br /> </span><span style="color: #DD0000">'ite_access' </span><span style="color: #007700">=> </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">post</span><span style="color: #007700">(</span><span style="color: #DD0000">'access'</span><span style="color: #007700">)<br /> <br /> )); </span>
</span>
</code></div>
<p>Please help!
</p>
2010-07-24T09:37:32-06:00
-
Trouble inserting date in to datetime field
https://codeigniter.com/forums/viewthread/162016/
https://codeigniter.com/forums/viewthread/162016/#When:11:30:04Z
<p>I’m having trouble inserting the date from a form field in to the datetime field of my table. The code below takes any date string from the form and inserts it as ‘0000-00-00 00:00:00’. The `date` field is listed as a datetime field in MySQL. Can someone see something I’m overlooking for why this doesn’t work? Thanks!</p>
<p>Model methods from MY_Model:
</p><div class="codeblock"><code><span style="color: #000000">
<span style="color: #007700">protected function </span><span style="color: #0000BB">convert_date_to_sqldate</span><span style="color: #007700">(</span><span style="color: #0000BB">$date</span><span style="color: #007700">)<br /></span><span style="color: #0000BB">{<br /> </span><span style="color: #007700">return </span><span style="color: #0000BB">date</span><span style="color: #007700">(</span><span style="color: #DD0000">'Y-m-d hh:mm:ss'</span><span style="color: #007700">, </span><span style="color: #0000BB">strtotime</span><span style="color: #007700">(</span><span style="color: #0000BB">$date</span><span style="color: #007700">));<br /></span><span style="color: #0000BB">}<br /><br /></span><span style="color: #007700">public function </span><span style="color: #0000BB">add</span><span style="color: #007700">(</span><span style="color: #0000BB">$insert_information </span><span style="color: #007700">= array(), </span><span style="color: #0000BB">$explict_types </span><span style="color: #007700">= array())<br /></span><span style="color: #0000BB">{<br /> </span><span style="color: #007700">if(</span><span style="color: #0000BB">count</span><span style="color: #007700">(</span><span style="color: #0000BB">$insert_information</span><span style="color: #007700">) == </span><span style="color: #0000BB">0</span><span style="color: #007700">)<br /> </span><span style="color: #0000BB">{<br /> </span><span style="color: #007700">return </span><span style="color: #0000BB">FALSE</span><span style="color: #007700">;<br /> </span><span style="color: #0000BB">}<br /><br /> </span><span style="color: #007700">foreach(</span><span style="color: #0000BB">$insert_information </span><span style="color: #007700">as </span><span style="color: #0000BB">$key </span><span style="color: #007700">=> &</span><span style="color: #0000BB">$value</span><span style="color: #007700">)<br /> </span><span style="color: #0000BB">{<br /> </span><span style="color: #007700">if(isset(</span><span style="color: #0000BB">$explict_types[$key]</span><span style="color: #007700">))<br /> </span><span style="color: #0000BB">{<br /> </span><span style="color: #007700">switch(</span><span style="color: #0000BB">$explict_types[$key]</span><span style="color: #007700">)<br /> </span><span style="color: #0000BB">{<br /> </span><span style="color: #007700">case </span><span style="color: #DD0000">'date'</span><span style="color: #007700">:<br /> </span><span style="color: #0000BB">$insert_information[$key] </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">convert_date_to_sqldate</span><span style="color: #007700">(</span><span style="color: #0000BB">$value</span><span style="color: #007700">);<br /> break;<br /> </span><span style="color: #0000BB">}<br /> } <br /> }<br /><br /> $this</span><span style="color: #007700">-></span><span style="color: #0000BB">db</span><span style="color: #007700">-></span><span style="color: #0000BB">insert</span><span style="color: #007700">(</span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">primary_table[</span><span style="color: #DD0000">'name'</span><span style="color: #0000BB">]</span><span style="color: #007700">, </span><span style="color: #0000BB">$insert_information</span><span style="color: #007700">);<br /><br /> if(</span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">db</span><span style="color: #007700">-></span><span style="color: #0000BB">affected_rows</span><span style="color: #007700">() > </span><span style="color: #0000BB">0</span><span style="color: #007700">)<br /> </span><span style="color: #0000BB">{ <br /> </span><span style="color: #007700">return </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">read</span><span style="color: #007700">(</span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">db</span><span style="color: #007700">-></span><span style="color: #0000BB">insert_id</span><span style="color: #007700">());<br /> </span><span style="color: #0000BB">}<br /> </span><span style="color: #007700">else<br /> </span><span style="color: #0000BB">{<br /> </span><span style="color: #007700">return </span><span style="color: #0000BB">FALSE</span><span style="color: #007700">;<br /> </span><span style="color: #0000BB">}<br />} </span>
</span>
</code></div>
<p>Code on page:
</p><div class="codeblock"><code><span style="color: #000000">
<span style="color: #0000BB">$insert_data </span><span style="color: #007700">= array(<br /> </span><span style="color: #DD0000">'date' </span><span style="color: #007700">=> </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">input</span><span style="color: #007700">-></span><span style="color: #0000BB">post</span><span style="color: #007700">(</span><span style="color: #DD0000">'date'</span><span style="color: #007700">),<br /> </span><span style="color: #DD0000">'amount' </span><span style="color: #007700">=> </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">input</span><span style="color: #007700">-></span><span style="color: #0000BB">post</span><span style="color: #007700">(</span><span style="color: #DD0000">'amount'</span><span style="color: #007700">),<br /> </span><span style="color: #DD0000">'account_number' </span><span style="color: #007700">=> </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">input</span><span style="color: #007700">-></span><span style="color: #0000BB">post</span><span style="color: #007700">(</span><span style="color: #DD0000">'account_number'</span><span style="color: #007700">),<br /> </span><span style="color: #DD0000">'type' </span><span style="color: #007700">=> </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">input</span><span style="color: #007700">-></span><span style="color: #0000BB">post</span><span style="color: #007700">(</span><span style="color: #DD0000">'transaction_type'</span><span style="color: #007700">)<br />);<br /> <br /></span><span style="color: #0000BB">$explicit_types </span><span style="color: #007700">= array(</span><span style="color: #DD0000">'date' </span><span style="color: #007700">=> </span><span style="color: #DD0000">'date'</span><span style="color: #007700">);<br /> <br />if(</span><span style="color: #0000BB">$query </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">Transaction</span><span style="color: #007700">-></span><span style="color: #0000BB">add</span><span style="color: #007700">(</span><span style="color: #0000BB">$insert_data</span><span style="color: #007700">, </span><span style="color: #0000BB">$explicit_types</span><span style="color: #007700">))<br /></span><span style="color: #0000BB">{<br /> redirect</span><span style="color: #007700">(</span><span style="color: #DD0000">'transactions/browse'</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">}<br /></span><span style="color: #007700">else<br /></span><span style="color: #0000BB">{<br /> </span><span style="color: #007700">echo </span><span style="color: #DD0000">'Insert failed'</span><span style="color: #007700">;<br /></span><span style="color: #0000BB">} </span>
</span>
</code></div>
2010-07-24T11:30:04-06:00
-
Parentheses escaping within ActiveRecord
https://codeigniter.com/forums/viewthread/162036/
https://codeigniter.com/forums/viewthread/162036/#When:18:07:09Z
<p>I have to perform the following database query:</p>
<div class="codeblock"><code><span style="color: #000000">
<span style="color: #0000BB">SELECT </span><span style="color: #007700">* </span><span style="color: #0000BB">FROM albums<br />WHERE artist_name </span><span style="color: #007700">= </span><span style="color: #DD0000">'Bedrock'<br /></span><span style="color: #007700">AND </span><span style="color: #0000BB">album_name </span><span style="color: #007700">= </span><span style="color: #DD0000">'Emerald (including Charlie May remix)' </span>
</span>
</code></div><p>
which works within the mysql console.</p>
<p>I am using ActiveRecord within C.I.:
</p><div class="codeblock"><code><span style="color: #000000">
<span style="color: #0000BB">$q </span><span style="color: #007700">= </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">db</span><span style="color: #007700">-></span><span style="color: #0000BB">get_where</span><span style="color: #007700">(</span><span style="color: #DD0000">'albums'</span><span style="color: #007700">,array(</span><span style="color: #DD0000">'artist_name'</span><span style="color: #007700">=></span><span style="color: #0000BB">$artist</span><span style="color: #007700">, </span><span style="color: #DD0000">'album_name'</span><span style="color: #007700">=></span><span style="color: #0000BB">$album</span><span style="color: #007700">)); </span>
</span>
</code></div>
<p>However the parentheses are automatically escaped before querying the database:
</p><div class="codeblock"><code><span style="color: #000000">
<span style="color: #0000BB">SELECT </span><span style="color: #007700">*<br /></span><span style="color: #0000BB">FROM </span><span style="color: #007700">(`</span><span style="color: #DD0000">albums</span><span style="color: #007700">`)<br /></span><span style="color: #0000BB">WHERE </span><span style="color: #007700">`</span><span style="color: #DD0000">artist_name</span><span style="color: #007700">` = </span><span style="color: #DD0000">'Bedrock'<br /></span><span style="color: #007700">AND `</span><span style="color: #DD0000">album_name</span><span style="color: #007700">` = </span><span style="color: #DD0000">'Emerald & # 4 0 ;including Charlie May remix& # 4 1 ;' </span>
</span>
</code></div><p>
(EDIT: <b>I have added spaces within the escaped characters</b>, the forum converted them to their ASCII form)<br />
....and nothing is returned</p>
<p>I have tried <a href="https://codeigniter.com/wiki/Category:Libraries:ActiveRecord:Including_Parenthesis/">the C.I. wiki work around</a> but still no success.</p>
<p>How can I query the database with field values that contain parenthesis?<br />
Kind regards,<br />
Stegre.
</p>
2010-07-24T18:07:09-06:00
-
PDO SQLite3
https://codeigniter.com/forums/viewthread/161737/
https://codeigniter.com/forums/viewthread/161737/#When:01:10:02Z
<h4>Update: 22 July 2010</h4><p>
The driver is missing the _truncate() function and the $_count_string variable, which are required for some SQL operations. The following changes must be made to pdo_driver.php:</p>
<p>After line 47, add the following:
</p><div class="codeblock"><code><span style="color: #000000">
<span style="color: #007700">var </span><span style="color: #0000BB">$_count_string </span><span style="color: #007700">= </span><span style="color: #DD0000">"SELECT COUNT(*) AS "</span><span style="color: #007700">; </span>
</span>
</code></div>
<p>Around line 530, change the _delete() function so it reads as follows:
</p><div class="codeblock"><code><span style="color: #000000">
<span style="color: #007700">function </span><span style="color: #0000BB">_delete</span><span style="color: #007700">(</span><span style="color: #0000BB">$table</span><span style="color: #007700">, </span><span style="color: #0000BB">$where</span><span style="color: #007700">=</span><span style="color: #0000BB">null</span><span style="color: #007700">)<br /> </span><span style="color: #0000BB">{<br /> $sql </span><span style="color: #007700">= </span><span style="color: #DD0000">"DELETE FROM "</span><span style="color: #007700">.</span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">escape_table</span><span style="color: #007700">(</span><span style="color: #0000BB">$table</span><span style="color: #007700">);<br /> if (!empty(</span><span style="color: #0000BB">$where</span><span style="color: #007700">)) </span><span style="color: #0000BB">{<br /> $sql </span><span style="color: #007700">.= </span><span style="color: #DD0000">" WHERE "</span><span style="color: #007700">.</span><span style="color: #0000BB">implode</span><span style="color: #007700">(</span><span style="color: #DD0000">" "</span><span style="color: #007700">, </span><span style="color: #0000BB">$where</span><span style="color: #007700">);<br /> </span><span style="color: #0000BB">}<br /> </span><span style="color: #007700">return </span><span style="color: #0000BB">$sql</span><span style="color: #007700">; </span>
</span>
</code></div><p> </p>
<p>Then add the following lines:
</p><div class="codeblock"><code><span style="color: #000000">
<span style="color: #FF8000">/**<br /> * Truncate statement<br /> *<br /> * Generates a platform-specific truncate string from the supplied data<br /> * If the database does not support the truncate() command<br /> * This function maps to "DELETE FROM table"<br /> *<br /> * @access public<br /> * @param string the table name<br /> * @return string<br /> */<br /> </span><span style="color: #007700">function </span><span style="color: #0000BB">_truncate</span><span style="color: #007700">(</span><span style="color: #0000BB">$table</span><span style="color: #007700">, </span><span style="color: #0000BB">$where</span><span style="color: #007700">=</span><span style="color: #0000BB">null</span><span style="color: #007700">)<br /> </span><span style="color: #0000BB">{<br /> </span><span style="color: #007700">return </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">_delete</span><span style="color: #007700">(</span><span style="color: #0000BB">$table</span><span style="color: #007700">, </span><span style="color: #0000BB">$where</span><span style="color: #007700">);<br /> </span><span style="color: #0000BB">} </span>
</span>
</code></div>
2010-07-22T01:10:02-06:00
-
CI2: data validation before inserting it in DB
https://codeigniter.com/forums/viewthread/162035/
https://codeigniter.com/forums/viewthread/162035/#When:18:03:21Z
<p>Hello, I’m just get started with CI(CI2) and i created simple newsletter-webapp.</p>
<p>But i’m not sure about my validation:
</p><div class="codeblock"><code><span style="color: #000000">
<span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">form_validation</span><span style="color: #007700">-></span><span style="color: #0000BB">set_rules</span><span style="color: #007700">(<br /> array(<br /> array(<br /> </span><span style="color: #DD0000">"field" </span><span style="color: #007700">=> </span><span style="color: #DD0000">"title"</span><span style="color: #007700">,<br /> </span><span style="color: #DD0000">"label" </span><span style="color: #007700">=> </span><span style="color: #DD0000">"Title"</span><span style="color: #007700">,<br /> </span><span style="color: #DD0000">"rules" </span><span style="color: #007700">=> </span><span style="color: #DD0000">"required|xss_clean"<br /> </span><span style="color: #007700">),<br /> array(<br /> </span><span style="color: #DD0000">"field" </span><span style="color: #007700">=> </span><span style="color: #DD0000">"body"</span><span style="color: #007700">,<br /> </span><span style="color: #DD0000">"label" </span><span style="color: #007700">=> </span><span style="color: #DD0000">"News body"</span><span style="color: #007700">,<br /> </span><span style="color: #DD0000">"rules" </span><span style="color: #007700">=> </span><span style="color: #DD0000">"required|xss_clean"<br /> </span><span style="color: #007700">),<br /> array(<br /> </span><span style="color: #DD0000">"field" </span><span style="color: #007700">=> </span><span style="color: #DD0000">"body_extra"</span><span style="color: #007700">,<br /> </span><span style="color: #DD0000">"label" </span><span style="color: #007700">=> </span><span style="color: #DD0000">"Body extra"</span><span style="color: #007700">,<br /> </span><span style="color: #DD0000">"rules" </span><span style="color: #007700">=> </span><span style="color: #DD0000">"xss_clean"<br /> </span><span style="color: #007700">),<br /> array(<br /> </span><span style="color: #DD0000">"field" </span><span style="color: #007700">=> </span><span style="color: #DD0000">"author_login"</span><span style="color: #007700">,<br /> </span><span style="color: #DD0000">"label" </span><span style="color: #007700">=> </span><span style="color: #DD0000">"Authors login"</span><span style="color: #007700">,<br /> </span><span style="color: #DD0000">"rules" </span><span style="color: #007700">=> </span><span style="color: #DD0000">"required|xss_clean"<br /> </span><span style="color: #007700">)<br /> )<br /> );<br /> </span><span style="color: #0000BB">$_POST[</span><span style="color: #DD0000">'id'</span><span style="color: #0000BB">] </span><span style="color: #007700">= </span><span style="color: #0000BB">0</span><span style="color: #007700">;<br /> </span><span style="color: #0000BB">$_POST[</span><span style="color: #DD0000">'author_id'</span><span style="color: #0000BB">] </span><span style="color: #007700">= </span><span style="color: #0000BB">0</span><span style="color: #007700">; </span><span style="color: #FF8000">//disable this in future<br /> </span><span style="color: #0000BB">$_POST[</span><span style="color: #DD0000">'mtime'</span><span style="color: #0000BB">] </span><span style="color: #007700">= </span><span style="color: #0000BB">date</span><span style="color: #007700">(</span><span style="color: #DD0000">"Y-m-d H:i:s"</span><span style="color: #007700">, </span><span style="color: #0000BB">3601 </span><span style="color: #007700">);<br /> </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">form_validation</span><span style="color: #007700">-></span><span style="color: #0000BB">set_error_delimiters</span><span style="color: #007700">(</span><span style="color: #DD0000">'<p class="error">'</span><span style="color: #007700">, </span><span style="color: #DD0000">'</p>'</span><span style="color: #007700">);<br /> <br /> if (!</span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">form_validation</span><span style="color: #007700">-></span><span style="color: #0000BB">run</span><span style="color: #007700">()) </span><span style="color: #0000BB">{<br /> $this</span><span style="color: #007700">-></span><span style="color: #0000BB">data[</span><span style="color: #DD0000">'title'</span><span style="color: #0000BB">] </span><span style="color: #007700">= </span><span style="color: #DD0000">"News: Add (errors)"</span><span style="color: #007700">;<br /> </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">load</span><span style="color: #007700">-></span><span style="color: #0000BB">view</span><span style="color: #007700">(</span><span style="color: #DD0000">'news_add'</span><span style="color: #007700">, </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">data</span><span style="color: #007700">);<br /> </span><span style="color: #0000BB">}<br /> </span><span style="color: #007700">else </span><span style="color: #0000BB">{<br /> $this</span><span style="color: #007700">-></span><span style="color: #0000BB">data[</span><span style="color: #DD0000">'title'</span><span style="color: #0000BB">] </span><span style="color: #007700">= </span><span style="color: #DD0000">"News: new post inserted"</span><span style="color: #007700">;<br /> </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">load</span><span style="color: #007700">-></span><span style="color: #0000BB">view</span><span style="color: #007700">(</span><span style="color: #DD0000">'news_inserted'</span><span style="color: #007700">, </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">data</span><span style="color: #007700">);<br /> </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">db</span><span style="color: #007700">-></span><span style="color: #0000BB">insert</span><span style="color: #007700">(</span><span style="color: #DD0000">'news'</span><span style="color: #007700">, </span><span style="color: #0000BB">$_POST</span><span style="color: #007700">);<br /> </span><span style="color: #0000BB">} </span>
</span>
</code></div>
<p>Web form, from which i sent data:
</p><div class="codeblock"><code><span style="color: #000000">
<span style="color: #0000BB"><?php </span><span style="color: #007700">if ( ! </span><span style="color: #0000BB">defined</span><span style="color: #007700">(</span><span style="color: #DD0000">'BASEPATH'</span><span style="color: #007700">)) exit(</span><span style="color: #DD0000">'No direct script access allowed'</span><span style="color: #007700">);</span><span style="color: #0000BB">?><br /></span><span style="color: #007700"><!</span><span style="color: #0000BB">DOCTYPE HTML </span><span style="color: #007700">PUBLIC </span><span style="color: #DD0000">"-//W3C//DTD HTML 4.01//EN"<br /> "https://www.w3.org/TR/html4/strict.dtd"</span><span style="color: #007700">><br /><</span><span style="color: #0000BB">html</span><span style="color: #007700">><br /><</span><span style="color: #0000BB">head</span><span style="color: #007700">><br /> <</span><span style="color: #0000BB">meta http</span><span style="color: #007700">-</span><span style="color: #0000BB">equiv</span><span style="color: #007700">=</span><span style="color: #DD0000">"Content-type" </span><span style="color: #0000BB">content</span><span style="color: #007700">=</span><span style="color: #DD0000">"text/html; charset=utf-8" </span><span style="color: #007700">/><br /> <</span><span style="color: #0000BB">title</span><span style="color: #007700">></span><span style="color: #0000BB"><?</span><span style="color: #007700">=</span><span style="color: #0000BB">$title?></span><span style="color: #007700"></</span><span style="color: #0000BB">title</span><span style="color: #007700">><br /></</span><span style="color: #0000BB">head</span><span style="color: #007700">><br /><</span><span style="color: #0000BB">body</span><span style="color: #007700">><br /></span><span style="color: #0000BB"><?</span><span style="color: #007700">=</span><span style="color: #0000BB">validation_errors</span><span style="color: #007700">()</span><span style="color: #0000BB">?><br /><?php<br /><br /></span><span style="color: #007700">echo </span><span style="color: #DD0000">"<p>"</span><span style="color: #007700">,<br /> </span><span style="color: #0000BB">form_open</span><span style="color: #007700">(</span><span style="color: #DD0000">'news/insert'</span><span style="color: #007700">, array(</span><span style="color: #DD0000">'class' </span><span style="color: #007700">=> </span><span style="color: #DD0000">'email'</span><span style="color: #007700">, </span><span style="color: #DD0000">'id' </span><span style="color: #007700">=> </span><span style="color: #DD0000">'myform'</span><span style="color: #007700">)), </span><span style="color: #DD0000">"</p>"</span><span style="color: #007700">,<br /> </span><span style="color: #DD0000">"<p>"</span><span style="color: #007700">, </span><span style="color: #0000BB">form_input</span><span style="color: #007700">(array(<br /> </span><span style="color: #DD0000">"name" </span><span style="color: #007700">=> </span><span style="color: #DD0000">"title"</span><span style="color: #007700">,<br /> </span><span style="color: #DD0000">"value" </span><span style="color: #007700">=> </span><span style="color: #0000BB">set_value</span><span style="color: #007700">(</span><span style="color: #DD0000">"title"</span><span style="color: #007700">, </span><span style="color: #DD0000">"Title"</span><span style="color: #007700">)<br /> )), </span><span style="color: #DD0000">"</p>"</span><span style="color: #007700">,<br /> </span><span style="color: #DD0000">"<p>"</span><span style="color: #007700">,</span><span style="color: #0000BB">form_textarea</span><span style="color: #007700">(array(<br /> </span><span style="color: #DD0000">"name" </span><span style="color: #007700">=> </span><span style="color: #DD0000">"body"</span><span style="color: #007700">,<br /> </span><span style="color: #DD0000">"value" </span><span style="color: #007700">=> </span><span style="color: #0000BB">set_value</span><span style="color: #007700">(</span><span style="color: #DD0000">"body"</span><span style="color: #007700">,</span><span style="color: #DD0000">"News Body"</span><span style="color: #007700">)<br /> )), </span><span style="color: #DD0000">"</p>"</span><span style="color: #007700">,<br /> </span><span style="color: #DD0000">"<p>"</span><span style="color: #007700">,</span><span style="color: #0000BB">form_textarea</span><span style="color: #007700">(array(<br /> </span><span style="color: #DD0000">"name" </span><span style="color: #007700">=> </span><span style="color: #DD0000">"body_extra"</span><span style="color: #007700">,<br /> </span><span style="color: #DD0000">"value" </span><span style="color: #007700">=> </span><span style="color: #0000BB">set_value</span><span style="color: #007700">(</span><span style="color: #DD0000">"body_extra"</span><span style="color: #007700">,</span><span style="color: #DD0000">"Extra body"</span><span style="color: #007700">)<br /> )), </span><span style="color: #DD0000">"</p>"</span><span style="color: #007700">,<br /> </span><span style="color: #DD0000">"<p>"</span><span style="color: #007700">, </span><span style="color: #0000BB">form_input</span><span style="color: #007700">(array(<br /> </span><span style="color: #DD0000">"name" </span><span style="color: #007700">=> </span><span style="color: #DD0000">"author_login"</span><span style="color: #007700">,<br /> </span><span style="color: #DD0000">"value" </span><span style="color: #007700">=> </span><span style="color: #0000BB">set_value</span><span style="color: #007700">(</span><span style="color: #DD0000">"author_login"</span><span style="color: #007700">,</span><span style="color: #DD0000">"Author"</span><span style="color: #007700">)<br /> )), </span><span style="color: #DD0000">"</p>"</span><span style="color: #007700">,<br /> </span><span style="color: #DD0000">"<p>"</span><span style="color: #007700">,</span><span style="color: #0000BB">form_submit</span><span style="color: #007700">(array(<br /> </span><span style="color: #DD0000">"value"</span><span style="color: #007700">=></span><span style="color: #DD0000">"Submit"<br /> </span><span style="color: #007700">)), </span><span style="color: #DD0000">"</p>"</span><span style="color: #007700">,<br /> </span><span style="color: #0000BB">form_close</span><span style="color: #007700">();<br /><br /></span><span style="color: #0000BB">?><br /></span><span style="color: #007700"></</span><span style="color: #0000BB">body</span><span style="color: #007700">><br /></</span><span style="color: #0000BB">html</span><span style="color: #007700">> </span>
</span>
</code></div>
<p>Table description in database:
</p><div class="codeblock"><code><span style="color: #000000">
<span style="color: #0000BB">CREATE TABLE </span><span style="color: #007700">`</span><span style="color: #DD0000">cms</span><span style="color: #007700">`.`</span><span style="color: #DD0000">news</span><span style="color: #007700">` (<br /> `</span><span style="color: #DD0000">id</span><span style="color: #007700">` </span><span style="color: #0000BB">int</span><span style="color: #007700">(</span><span style="color: #0000BB">10</span><span style="color: #007700">) </span><span style="color: #0000BB">unsigned NOT NULL AUTO_INCREMENT</span><span style="color: #007700">,<br /> `</span><span style="color: #DD0000">title</span><span style="color: #007700">` </span><span style="color: #0000BB">tinytext NOT NULL</span><span style="color: #007700">,<br /> `</span><span style="color: #DD0000">body</span><span style="color: #007700">` </span><span style="color: #0000BB">text NOT NULL</span><span style="color: #007700">,<br /> `</span><span style="color: #DD0000">body_extra</span><span style="color: #007700">` </span><span style="color: #0000BB">text NOT NULL</span><span style="color: #007700">,<br /> `</span><span style="color: #DD0000">ctime</span><span style="color: #007700">` </span><span style="color: #0000BB">timestamp NOT NULL </span><span style="color: #007700">DEFAULT </span><span style="color: #0000BB">CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT </span><span style="color: #DD0000">'creation time'</span><span style="color: #007700">,<br /> `</span><span style="color: #DD0000">mtime</span><span style="color: #007700">` </span><span style="color: #0000BB">timestamp NOT NULL </span><span style="color: #007700">DEFAULT </span><span style="color: #DD0000">'0000-00-00 00:00:00' </span><span style="color: #0000BB">COMMENT </span><span style="color: #DD0000">'modification time'</span><span style="color: #007700">,<br /> `</span><span style="color: #DD0000">author_id</span><span style="color: #007700">` </span><span style="color: #0000BB">int</span><span style="color: #007700">(</span><span style="color: #0000BB">11</span><span style="color: #007700">) </span><span style="color: #0000BB">NOT NULL</span><span style="color: #007700">,<br /> `</span><span style="color: #DD0000">author_login</span><span style="color: #007700">` </span><span style="color: #0000BB">tinytext NOT NULL</span><span style="color: #007700">,<br /> </span><span style="color: #0000BB">PRIMARY KEY </span><span style="color: #007700">(`</span><span style="color: #DD0000">id</span><span style="color: #007700">`)<br />) </span><span style="color: #0000BB">ENGINE</span><span style="color: #007700">=</span><span style="color: #0000BB">MyISAM AUTO_INCREMENT</span><span style="color: #007700">=</span><span style="color: #0000BB">64 </span><span style="color: #007700">DEFAULT </span><span style="color: #0000BB">CHARSET</span><span style="color: #007700">=</span><span style="color: #0000BB">latin1 </span>
</span>
</code></div><p>————————<br />
Do i forgot something to check?
</p>
2010-07-24T18:03:21-06:00
-
how to resize image and use watermark in the same time using image manipulation class ?
https://codeigniter.com/forums/viewthread/162030/
https://codeigniter.com/forums/viewthread/162030/#When:16:16:42Z
<p>Hello guys</p>
<p>i’m using image manipulation class, i’m using ‘dynamic_output’ and it’s necessary for my application. but i have a problem i want to resize an image and watermark it without saving it, i want only to resize and watermark the source image without affecting the source image. and i can’t save a temporary image. for example i can’t resize the image save it and watermark it again.</p>
<p>Thanks
</p>
2010-07-24T16:16:42-06:00
-
CI 2.0 - when?
https://codeigniter.com/forums/viewthread/161838/
https://codeigniter.com/forums/viewthread/161838/#When:13:59:44Z
<p>Is there any ideas, when CI 2.0 will be released?<br />
In other words, is there any information about current state of 2.0 version(which is currently in development), how much is CI 2 in development?</p>
<p>I want to start a new project with CI, but I’m worrying about current CI 2 dev-version security…
</p>
2010-07-22T13:59:44-06:00
-
Image Moo - Image manipulation library
https://codeigniter.com/forums/viewthread/161469/
https://codeigniter.com/forums/viewthread/161469/#When:09:10:10Z
<p>The CI library for image manipulation is great, but I found it awkward to use when doing multiple processes. So I wrote my own library which I’m happy for you to play with and send feedback. It is limited to PHP 5 and GD2 only, sorry, but that suits my needs.<br />
Example :-
</p><div class="codeblock"><code><span style="color: #000000">
<span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">load</span><span style="color: #007700">-></span><span style="color: #0000BB">library</span><span style="color: #007700">(</span><span style="color: #DD0000">'image_moo'</span><span style="color: #007700">);<br /> </span><span style="color: #FF8000">// single thumbnail<br /> </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">image_moo<br /> </span><span style="color: #007700">-></span><span style="color: #0000BB">load</span><span style="color: #007700">(</span><span style="color: #DD0000">"myfile.x"</span><span style="color: #007700">)<br /> -></span><span style="color: #0000BB">resize</span><span style="color: #007700">(</span><span style="color: #0000BB">200</span><span style="color: #007700">,</span><span style="color: #0000BB">200</span><span style="color: #007700">)<br /> -></span><span style="color: #0000BB">save</span><span style="color: #007700">(</span><span style="color: #DD0000">"thumb.x"</span><span style="color: #007700">);<br /> if (</span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">image_moo</span><span style="color: #007700">-></span><span style="color: #0000BB">error</span><span style="color: #007700">) print </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">image_moo</span><span style="color: #007700">-></span><span style="color: #0000BB">display_errors</span><span style="color: #007700">();<br /><br /> </span><span style="color: #FF8000">// thumbnail and large, large watermarked<br /> </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">image_moo<br /> </span><span style="color: #007700">-></span><span style="color: #0000BB">load</span><span style="color: #007700">(</span><span style="color: #DD0000">"myfile.x"</span><span style="color: #007700">)<br /> -></span><span style="color: #0000BB">resize</span><span style="color: #007700">(</span><span style="color: #0000BB">240</span><span style="color: #007700">,</span><span style="color: #0000BB">200</span><span style="color: #007700">)<br /> -></span><span style="color: #0000BB">save</span><span style="color: #007700">(</span><span style="color: #DD0000">"thumb.x"</span><span style="color: #007700">)<br /> -></span><span style="color: #0000BB">resize</span><span style="color: #007700">(</span><span style="color: #0000BB">1024</span><span style="color: #007700">,</span><span style="color: #0000BB">768</span><span style="color: #007700">)<br /> -></span><span style="color: #0000BB">save</span><span style="color: #007700">(</span><span style="color: #DD0000">"medium.x"</span><span style="color: #007700">)<br /> -></span><span style="color: #0000BB">resize</span><span style="color: #007700">(</span><span style="color: #0000BB">1600</span><span style="color: #007700">,</span><span style="color: #0000BB">1024</span><span style="color: #007700">)<br /> -></span><span style="color: #0000BB">save</span><span style="color: #007700">(</span><span style="color: #DD0000">"large.x"</span><span style="color: #007700">);<br /> if (</span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">image_moo</span><span style="color: #007700">-></span><span style="color: #0000BB">error</span><span style="color: #007700">) print </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">image_moo</span><span style="color: #007700">-></span><span style="color: #0000BB">display_errors</span><span style="color: #007700">();<br /><br /> </span><span style="color: #FF8000">// add watermarks<br /> </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">image_moo<br /> </span><span style="color: #007700">-></span><span style="color: #0000BB">load</span><span style="color: #007700">(</span><span style="color: #DD0000">"myfile.x"</span><span style="color: #007700">)<br /> -></span><span style="color: #0000BB">load_watermark</span><span style="color: #007700">(</span><span style="color: #DD0000">"image.x"</span><span style="color: #007700">)<br /> -></span><span style="color: #0000BB">resize</span><span style="color: #007700">(</span><span style="color: #0000BB">240</span><span style="color: #007700">,</span><span style="color: #0000BB">200</span><span style="color: #007700">)<br /> -></span><span style="color: #0000BB">save</span><span style="color: #007700">(</span><span style="color: #DD0000">"thumb.x"</span><span style="color: #007700">)<br /> -></span><span style="color: #0000BB">resize</span><span style="color: #007700">(</span><span style="color: #0000BB">1024</span><span style="color: #007700">,</span><span style="color: #0000BB">768</span><span style="color: #007700">)<br /> -></span><span style="color: #0000BB">watermark</span><span style="color: #007700">(</span><span style="color: #0000BB">2</span><span style="color: #007700">)<br /> -></span><span style="color: #0000BB">save</span><span style="color: #007700">(</span><span style="color: #DD0000">"medium.x"</span><span style="color: #007700">)<br /> -></span><span style="color: #0000BB">resize</span><span style="color: #007700">(</span><span style="color: #0000BB">1600</span><span style="color: #007700">,</span><span style="color: #0000BB">1024</span><span style="color: #007700">)<br /> -></span><span style="color: #0000BB">watermark</span><span style="color: #007700">(</span><span style="color: #0000BB">8</span><span style="color: #007700">)<br /> -></span><span style="color: #0000BB">save</span><span style="color: #007700">(</span><span style="color: #DD0000">"large.x"</span><span style="color: #007700">);<br /> if (</span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">image_moo</span><span style="color: #007700">-></span><span style="color: #0000BB">error</span><span style="color: #007700">) print </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">image_moo</span><span style="color: #007700">-></span><span style="color: #0000BB">display_errors</span><span style="color: #007700">();<br /><br /> </span><span style="color: #FF8000">// create watermark text<br /> </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">image_moo<br /> </span><span style="color: #007700">-></span><span style="color: #0000BB">load</span><span style="color: #007700">(</span><span style="color: #DD0000">"myfile.x"</span><span style="color: #007700">)<br /> -></span><span style="color: #0000BB">make_watermark_text</span><span style="color: #007700">(</span><span style="color: #DD0000">"copyright me"</span><span style="color: #007700">,</span><span style="color: #DD0000">"font.ttf"</span><span style="color: #007700">)<br /> -></span><span style="color: #0000BB">resize</span><span style="color: #007700">(</span><span style="color: #0000BB">1024</span><span style="color: #007700">,</span><span style="color: #0000BB">768</span><span style="color: #007700">)<br /> -></span><span style="color: #0000BB">watermark</span><span style="color: #007700">(</span><span style="color: #0000BB">2</span><span style="color: #007700">)<br /> -></span><span style="color: #0000BB">save</span><span style="color: #007700">(</span><span style="color: #DD0000">"medium.x"</span><span style="color: #007700">);<br /> if (</span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">image_moo</span><span style="color: #007700">-></span><span style="color: #0000BB">error</span><span style="color: #007700">) print </span><span style="color: #0000BB">$this</span><span style="color: #007700">-></span><span style="color: #0000BB">image_moo</span><span style="color: #007700">-></span><span style="color: #0000BB">display_errors</span><span style="color: #007700">(); </span>
</span>
</code></div><p>
Those are a couple of basic uses but it has a couple of extras for resize <img src="https://ellislab.com/images/smileys/smile.gif" width="19" height="19" alt="smile" style="border:0;" /><br />
resize($max_width,$max_height,$pad=FALSE)<br />
So resize will work as normal, e.g. an image of 1000 x 600. resize(200,200) your output image would be 200 x 120. Sometimes you want this as a square image, so set pad and the returned image will be 200 x 200 and the image centralised on to it. The background colour can be set with $this->image_moo->set_background_colour($html_colour=”#ffffff”) (default is white #ffffff.<br />
There is also another resize, resize_crop($x,$y) which is similar to resize but truncates the original image to get the largest part in the resize. e.g. a 1000 x 600 image resize_crop(200,200) returns a 200 x 200 image, but the source will be the centralised 600 x 600 part of the main image (does that sound right?!)</p>
<p>There are no docs at the moment as this is just version 0.7.2 while I continue the project I need this for, but all feedback is welcome.
</p>
2010-07-20T09:10:10-06:00
-
how to crop image in codeigniter using image manipulation class?
https://codeigniter.com/forums/viewthread/162003/
https://codeigniter.com/forums/viewthread/162003/#When:09:21:20Z
<p>Hello</p>
<p>i’m using codeigniter to build a project and right now i need to create a thumb depending on user choice. like he will give me X1,Y1,X2,Y2,X3,Y3,X4,Y4 i want to crop the image depending on that 4 points. i checked the image manipulation class. the crop function seems to be very strange. any help please ?</p>
<p>something like this </p>
<p>P1 = (100,100)<br />
P2 = (100,200)<br />
P3 = (200,100)<br />
P4 = (200,200)
</p>
2010-07-24T09:21:20-06:00
-
Storing a request URL
https://codeigniter.com/forums/viewthread/162017/
https://codeigniter.com/forums/viewthread/162017/#When:11:36:35Z
<p>Hi Guys,</p>
<p>First of all thanks a bunch for the great help so far - I am currently into my first steps on developing a website with CodeIgniter, and I absolutely love the framework.</p>
<p>I have noticed that, in a lot of cases, when I submit a form on a view I would just like to go back to the original page where the user filled out the form. This goes for a lot of things on the website I am creating, for example, the website includes a shopping cart - every time the cart is updated (I am using the Cart class…) I would just like to send the user back to where he came from.</p>
<p>Is there an easy way to do this? Can I tell a controller: “handle a user form, but when loading the view just go back to the original page”.</p>
<p>This also goes for example for clicking a link that adds a product to a cart, deleting an item from a cart , ...</p>
<p>Thanks in advance
</p>
2010-07-24T11:36:35-06:00