• Member Avatar for cereal
    cereal

    Began Watching Multiple schema.org items with the same URL

    Using microdata markup such as this on Dani's profile page with URL http://www.example.com/dani.html <body itemscope itemtype="http://schema.org/ProfilePage"> <h1 itemprop="name">About Dani</h1> <div itemscope itemprop="about" itemtype="http://schema.org/Person"> <link itemprop="url" href="http://www.example.com/dani.html" /> </div> </body> Is …
  • Member Avatar for cereal
    cereal

    Stopped Watching Multiple schema.org items with the same URL

    Using microdata markup such as this on Dani's profile page with URL http://www.example.com/dani.html <body itemscope itemtype="http://schema.org/ProfilePage"> <h1 itemprop="name">About Dani</h1> <div itemscope itemprop="about" itemtype="http://schema.org/Person"> <link itemprop="url" href="http://www.example.com/dani.html" /> </div> </body> Is …
  • Member Avatar for cereal
    cereal

    Began Watching Changing A Select Statement

    Hi guys. I wanted to create a quiz for my website. I have found some code from a website called (getcode.org) (prev world of webcraft). The quiz now works as …
  • Member Avatar for cereal
    cereal

    Replied To a Post in how to inserting files on mysql using LARAVEL

    Wait, how big are these files? Also, try to download one of these files through a test script, for example: <?php # database credentials $dbhost = 'localhost'; $dbname = 'dbname'; …
  • Member Avatar for cereal
    cereal

    Began Watching Kannel SmS Gateway

    i use kannel sms gateway i want that our school teacher send question and its answer from phone to my kannel number i want to parse the question and answer …
  • Member Avatar for cereal
    cereal

    Replied To a Post in How do I fetch data from table into dropdown in mysql

    Hi, let me understand: do you want an autocomplete function over an input text field? Or a select dropdown? Also, can you show the form?
  • Member Avatar for cereal
    cereal

    Replied To a Post in array shift on 2 dim array

    Hi, can you show some example data and the table structure?
  • Member Avatar for cereal
    cereal

    Replied To a Post in how to inserting files on mysql using LARAVEL

    Ok, the variable `$data` is used for the binary data not for the file name, so change the line `4`: $data = $file[0]->filename; to: $data = $file[0]->data; And it should …
  • Member Avatar for cereal
    cereal

    Replied To a Post in how to inserting files on mysql using LARAVEL

    > what 200 stands for on the get file function. 200 is the HTTP status used for successful HTTP requests, for more information check: * http://httpstatus.es/ I suppose there is …
  • Member Avatar for cereal
    cereal

    Replied To a Post in How to check IP of my website, exactly?

    Hi, to be sure ask to the hosting support, regarding OpenShift check this link: * https://www.openshift.com/developers/openshift-environment-variables it seems you can get the listening IP by echoing few system variables: * …
  • Member Avatar for cereal
    cereal

    Replied To a Post in codeigniter sessions

    If you use: $config['sess_encrypt_cookie'] = TRUE; $config['sess_use_database'] = TRUE; And create a session table: CREATE TABLE IF NOT EXISTS `ci_sessions` ( session_id varchar(40) DEFAULT '0' NOT NULL, ip_address varchar(45) DEFAULT …
  • Member Avatar for cereal
    cereal

    Replied To a Post in how to inserting files on mysql using LARAVEL

    Ok, check **/app/config/app.php** to be sure that `debug` is set to `true` then, if this is still your table structure: CREATE TABLE docs ( gov_docs_id int(11) NOT NULL AUTO_INCREMENT, personnel_id …
  • Member Avatar for cereal
    cereal

    Began Watching Multiple schema.org items with the same URL

    Using microdata markup such as this on Dani's profile page with URL http://www.example.com/dani.html <body itemscope itemtype="http://schema.org/ProfilePage"> <h1 itemprop="name">About Dani</h1> <div itemscope itemprop="about" itemtype="http://schema.org/Person"> <link itemprop="url" href="http://www.example.com/dani.html" /> </div> </body> Is …
  • Member Avatar for cereal
    cereal

    Replied To a Post in how to inserting files on mysql using LARAVEL

    Hi, what kind of error you get?
  • Member Avatar for cereal
    cereal

    Began Watching Jquery UI Datepciker

    Hi Team, I am trying to enable only the upcoming 2weeks i.e from current week friday to the second week thursday. For example: today's date is 25th so the upcoming …
  • Member Avatar for cereal
    cereal

    Replied To a Post in How to populate data from database

    Line `36`: <?}?> change it to: <?php } ?> Or to: <? } ?> In practice provide some space.
  • Member Avatar for cereal
    cereal

    Replied To a Post in Multiple uploads

    Hi, start from PHP documentation: * http://www.php.net//manual/en/features.file-upload.post-method.php * http://www.php.net/manual/en/features.file-upload.multiple.php Then, if you have difficults, show your code.
  • Member Avatar for cereal
    cereal

    Replied To a Post in How to populate data from database

    Hi, remove the curly bracket `}` at line 8.
  • Member Avatar for cereal
    cereal

    Replied To a Post in CodeIgniter session cookie vulnerability

    Sorry, I was referring to CI, in reply to: > It seems it is fixed in 3.0 but I know that version isn't stable. EllisLab made this upgrade to fix …
  • Member Avatar for cereal
    cereal

    Replied To a Post in PDO Query Fatal error:Call to a member function query() on a non-object

    The error: Fatal error: Call to a member function query() on a non-object in index.php on line 25 Is a consequence of: SQLSTATE[HY000] [1045] Access denied for user 'demo'@'localhost' (using …
  • Member Avatar for cereal
    cereal

    Replied To a Post in CodeIgniter session cookie vulnerability

    Version **2.2.0**, released few days ago, fixes this bug. Bye!
  • Member Avatar for cereal
    cereal

    Replied To a Post in Count rows from two tables

    Also, each subquery requires an alias, for example: select a.total from (select count(*) as total from tablename) as a; Otherwise you get an error, to see it use `mysql_error()`. In …
  • Member Avatar for cereal
    cereal

    Replied To a Post in How to use select_last_id on laravel 4

    If you use the method `insertGetId()`, Laravel will return correctly, basing on the value of the `auto_increment` column. Docs: * http://laravel.com/api/source-class-Illuminate.Database.Query.Processors.Processor.html#20 * http://dev.mysql.com/doc/refman/5.5/en/information-functions.html#function_last-insert-id By using Eloquent, instead, change the column …
  • Member Avatar for cereal
    cereal

    Replied To a Post in How to use select_last_id on laravel 4

    Are you using Eloquent? If yes, right after you save something call the `id` property, for example: $post = new Post; $post->title = 'Title'; $post->body = 'Bla bla bla...'; $post->save(); …
  • Member Avatar for cereal
    cereal

    Replied To a Post in PDO Query Fatal error:Call to a member function query() on a non-object

    > what should I do? Use the correct credentials (user and password) to access the database, so change these values in your config file: $username = "demo"; $password = "demo"; …
  • Member Avatar for cereal
    cereal

    Replied To a Post in how to inserting files on mysql using LARAVEL

    Ok, then how this should work? Route::get('/getfile/{id}', function($id) { $file = DB::select('SELECT * FROM docs WHERE gov_docs_id = ?', array($id = Input::get('id')) $data = $file[0]->file; return Response::make( $data, 200, array('Content-type' …
  • Member Avatar for cereal
    cereal

    Replied To a Post in how to inserting files on mysql using LARAVEL

    Can you show your table structure? In a MySQL client run: show create table docs; And post the results here. The problem can depend on the data saved in the …
  • Member Avatar for cereal
    cereal

    Replied To a Post in PHP MYSQL Array Error

    Hi, at line `10` use `mysqli_error()`: if ( ! $result = mysqli_query($con, $query)) { printf("Errormessage: %s\n", mysqli_error($con)); } It should explain the reason that makes the query return boolean `FALSE`. …
  • Member Avatar for cereal
    cereal

    Replied To a Post in how to inserting files on mysql using LARAVEL

    Yes, in the viewlist, replace the previous loop with a table, for example: <?php if($id) { ?> <table> <thead> <tr> <th>Filename</th> <th>Data</th> </tr> </thead> <tbody> <?php foreach($id as $sid) { …
  • Member Avatar for cereal
    cereal

    Replied To a Post in how to inserting files on mysql using LARAVEL

    So, I see: 1. a view to display the buttons in which you want to load the links to get the files 2. a controller to save the file 3. …
  • Member Avatar for cereal
    cereal

    Replied To a Post in how to inserting files on mysql using LARAVEL

    Ok, it will be easier to help you if we can see the controller from which you load the ids of all the files uploaded, for example you're probably using …
  • Member Avatar for cereal
    cereal

    Replied To a Post in how to inserting files on mysql using LARAVEL

    Good! Are you using Blade? If yes then the id must be `$id` and surrounded at least from **two** consecutive curly brackets, **three** if you want also to sanitize the …
  • Member Avatar for cereal
    cereal

    Replied To a Post in PDO Query Fatal error:Call to a member function query() on a non-object

    Ok, then check the contents of the file **PDOErrors.txt**, you should be able to read the reason why the connection to the database is failing.
  • Member Avatar for cereal
    cereal

    Replied To a Post in PDO Query Fatal error:Call to a member function query() on a non-object

    Hi, check line `12` in your config file: the `host` and `dbname` values are hardcoded, change the line with: $db = new PDO("mysql:host={$host};dbname={$dbname}", $username, $password);
  • Member Avatar for cereal
    cereal

    Replied To a Post in how to inserting files on mysql using LARAVEL

    > by the way i tried to look at my database and i saw that the files i've been stored was convert to .TMP ? Or you're trying to get …
  • Member Avatar for cereal
    cereal

    Replied To a Post in how to inserting files on mysql using LARAVEL

    No, you're still saving the path and the file name which is the temporary name given by the `$_FILES` array. In your previous code, you wrote only: $data = fread(Input::file('file')->getRealPath()); …
  • Member Avatar for cereal
    cereal

    Replied To a Post in how to inserting files on mysql using LARAVEL

    Try this in your **router.php** file: Route::get('/getfile/{id}', function($id) { $file = Attachment::find($id); $data = $file->doc_attachment; return Response::make($data, 200, array('Content-type' => $file->mime, 'Content-length' => $file->size)); }); Again, if you're not using …
  • Member Avatar for cereal
    cereal

    Replied To a Post in how to inserting files on mysql using LARAVEL

    Ok, I'm assuming your form is using the `enctype` attribute, correct? <form method="post" enctype="multipart/form-data" action="/upload_file"> Otherwise the file will not be uploaded. Also the `name` attribute in your input field …
  • Member Avatar for cereal
    cereal

    Replied To a Post in how to inserting files on mysql using LARAVEL

    Can you show the form and your updated code? Also which version of Laravel are you using?
  • Member Avatar for cereal
    cereal

    Replied To a Post in how to inserting files on mysql using LARAVEL

    Use `Input::file('file')` instead of `Input::get('file')`, the `file()` method gives you access to the `$_FILES` array. After doing this you need to read the contents from the path of the temporary …
  • Member Avatar for cereal
    cereal

    Replied To a Post in how to inserting files on mysql using LARAVEL

    Do you want to save the files or only the names? In the former case then use something like this: <form method="post" enctype="multipart/form-data" action="/upload_file"> <input type="file" name="file" /> <input type="submit" …
  • Member Avatar for cereal
    cereal

    Replied To a Post in TEXTBOX converted to DROPBOX

    In particular search for **autocomplete** scripts, for example this: * http://jqueryui.com/autocomplete/ * http://api.jqueryui.com/autocomplete/ bye!
  • Member Avatar for cereal
    cereal

    Replied To a Post in Hyperlink on BLOB image

    That happens if the GET request exceeds the `LimitRequestLine` directive (if you're using Apache), this limit cannot be higher than 8190 bytes, to change it you should modify the source …
  • Member Avatar for cereal
    cereal

    Replied To a Post in Hyperlink on BLOB image

    Create a script, for example **display.php**: $f = $_GET['image']; header("Content-type: image/jpeg"); echo base64_decode($f); Now your link becomes: <a href="display.php?image=<?php echo $img_str; ?>"> <img src="data:image/jpeg;base64,<?php echo $img_str; ?>" width=150 height=150 /> …
  • Member Avatar for cereal
    cereal

    Replied To a Post in Deleting a record from multiple tables

    You could use foreign keys constraints: * http://dev.mysql.com/doc/refman/5.5/en/create-table-foreign-keys.html If you have doubts, show us the tables schema.
  • Member Avatar for cereal
    cereal

    Replied To a Post in CI 3.0 is out

    > I thought EllisLabs announced that they were looking for a new maintainer for CodeIgniter? Correct. Version 3.0 is in the repo since 2011 or so, the development slowed down …
  • Member Avatar for cereal
    cereal

    Replied To a Post in CI 3.0 is out

    The stable version is 2.2.0, which is a security upgrade. Version 3.0 is not stable: * http://ellislab.com/blog/entry/codeigniter-2.2.0-released * https://github.com/EllisLab/CodeIgniter/tree/release/3.0 I will try it, however I would wait a stable release …
  • Member Avatar for cereal
    cereal

    Replied To a Post in getimagewidth width to array

    What if two or more images are the largest? Anyway, here's an example with `glob()`: <?php $f = glob('./path/*.{jpg,png,gif}', GLOB_BRACE); $r = array(); foreach($f as $file) { list($w, $h) = …
  • Member Avatar for cereal
    cereal

    Replied To a Post in How to make a domain name point to another domain name.

    From your panel you should be able to set up a redirect, check this: * http://support.hostgator.com/articles/cpanel/url-redirect-how-to-create
  • Member Avatar for cereal
    cereal

    Replied To a Post in Modify password issue

    Hi, It seems you're using some **user defined** functions: `apologize()`, `query()`, `render()` and `redirect()` are not PHP functions, so we cannot help much. Check the included file at the top …

The End.