• Member Avatar for cereal
    cereal

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

    **@Raj_17** Hi, I suppose you were referring to [this thread](https://www.daniweb.com/programming/web-development/threads/480731/how-to-inserting-files-on-mysql-using-laravel) but it seems you already got a reply here: * http://stackoverflow.com/questions/38221239/cli-stopped-working-error Follow **sunny kashyap** suggestion and use `Illuminate\Http\Request`, check the …
  • Member Avatar for cereal
    cereal

    Replied To a Post in PHP doesn't render entire "echo".

    In addition, you can also do: echo " AS " . ($index - 10) . " - " . $index . " SA ";
  • Member Avatar for cereal
    cereal

    Edited Message Inbox > Conversation failed post

    Hello, I was trying to send a PM but it seems to hang: after clicking the submit button this disappears and it does not happen anything else. With short messages …
  • Member Avatar for cereal
    cereal

    Created Message Inbox > Conversation failed post

    Hello, I was trying to send a PM but it seems to hang: after clicking the submit button this disappears and it does not happen anything else. With short messages …
  • Member Avatar for cereal
    cereal

    Replied To a Post in Php Soap Client

    Ok, look at the request: <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:tem="http://tempuri.org/"> <soapenv:Header></soapenv:Header> <soapenv:Body> <tem:GetIndividualCourseDetail> <!--Optional:--> <tem:CourseId>12262</tem:CourseId> </tem:GetIndividualCourseDetail> </soapenv:Body> </soapenv:Envelope> Here the only element you have to add, to the `<tem:GetIndividualCourseDetail>` method, is `<tem:CourseId>12262</tem:CourseId>`, …
  • Member Avatar for cereal
    cereal

    Replied To a Post in Php Soap Client

    Hi, if you add `echo $client->__getLastRequest();` you can see what is sent to the SOAP server, in this case it will not set the `sol` namespace, see: <?xml version="1.0" encoding="UTF-8"?> …
  • Member Avatar for cereal
    cereal

    Began Watching Php Soap Client

    Hi, I am gone crosseyed from trying to figure this out. I dont ususally post on this site I am half scared of getting told off for being out of …
  • Member Avatar for cereal
    cereal

    Replied To a Post in Problem posting

    test
  • Member Avatar for cereal
    cereal

    Marked Solved Status for Dazah edit profile

    Hello Dani, how can I remove my image from the Dazah.com profile? It seems it was acquired through the GMail access. Thanks!
  • Member Avatar for cereal
    cereal

    Gave Reputation to Dani in Dazah edit profile

    At the current time, you can't (You'll be able to soon). In the meantime, just upload a new photo in its place (or something blank, if you prefer.)
  • Member Avatar for cereal
    cereal

    Replied To a Post in Dazah edit profile

    > Your profile picture on Dazah? Yes, I went to _Control Panel > Edit Profile_, but I don't find how to remove it.
  • Member Avatar for cereal
    cereal

    Created Dazah edit profile

    Hello Dani, how can I remove my image from the Dazah.com profile? It seems it was acquired through the GMail access. Thanks!
  • Member Avatar for cereal
    cereal

    Replied To a Post in Database connectivity issue

    Hi, if you're trying to run the script outside the 000webhost.com hosting and you don't have a premium account, then the connection will fail, read: * https://www.000webhost.com/website-faq/how-can-i-connect-to-mysql-from-my-computer-27
  • Member Avatar for cereal
    cereal

    Gave Reputation to Dani in Unsubscribing from Daniweb

    If he attempted that, he would get an error message saying that you need to have no posts for 7 days before you can delete your membership (to avoid people …
  • Member Avatar for cereal
    cereal

    Replied To a Post in Unsubscribing from Daniweb

    Hi, go to the dropdown menu with your username, click on **Edit My Profile**, scroll the page down, until you get the **Permanently Delete Membership** button, click it. Bye bye!
  • Member Avatar for cereal
    cereal

    Replied To a Post in php array_diff function

    Hi, `array_diff()` will return the index key, so you can get the corresponding values for each array, as example: <?php $a = [4711, 4712, 4713, 4714]; $b = ['ALFA ROMEO', …
  • Member Avatar for cereal
    cereal

    Replied To a Post in How to create Smart Auto complete without Jquery

    In short you need a script that can receive a GET request, filter it and use it to perform a query, in which case would be something like: SELECT `last_name` …
  • Member Avatar for cereal
    cereal

    Replied To a Post in Fatal error: Allowed memory size of 67108864 bytes exhausted

    Ok, then it can be the result set, that is buffered into PHP and that hits the limit. You can limit the query, but if you are retrieving blob data …
  • Member Avatar for cereal
    cereal

    Replied To a Post in Fatal error: Allowed memory size of 67108864 bytes exhausted

    Hi, check if the new value was applied by using [`ini_get()`:](http://php.net/ini-get) echo ini_get('memory_limit'); some hostings does not allow to change the core directives.
  • Member Avatar for cereal
    cereal

    Replied To a Post in How to use triggers in PHP?

    Hi, do you mean database triggers?
  • Member Avatar for cereal
    cereal

    Gave Reputation to rproffitt in play embedded youtube video in fullscreen automatically

    OK, your tag is PHP but you didn't specify that this was in a browser. As you know you may not take over the screen like that. You could if …
  • Member Avatar for cereal
    cereal

    Replied To a Post in play embedded youtube video in fullscreen automatically

    By the way, have you tried through their API? https://codepen.io/bfred-it/pen/GgOvLM
  • Member Avatar for cereal
    cereal

    Replied To a Post in Image upload

    Before that line check if the $_FILES array exists: if the form is submitted without appending a file, or if the upload fails (file too big, for example), then you …
  • Member Avatar for cereal
    cereal

    Replied To a Post in How to create Smart Auto complete without Jquery

    Hi, you still need a client side script to submit the on going request, you can do that without a framework, look for an example at the autocomplete.js code: * …
  • Member Avatar for cereal
    cereal

    Began Watching referential integety

    What type or version of mysql do you need to run to have referential inegrety, withhout having to reley on using triggers?
  • Member Avatar for cereal
    cereal

    Replied To a Post in A Simple HTML Login page using JavaScript

    > I realize it is not secure and as you stated in the beginning, it was just for beginners [...] Some of us appreciate someone taking the time to try …
  • Member Avatar for cereal
    cereal

    Replied To a Post in how to get id from an insert statement

    After the `execute()` do: $id = $con->lastInsertId(); Docs: http://php.net/manual/en/pdo.lastinsertid.php
  • Member Avatar for cereal
    cereal

    Replied To a Post in Help needed with regualar expressions

    Hi, you can get a list in JSON format here: * http://openexchangerates.org/currencies.json you can get a free API key for 1000 request per month and get currency rates hourly updated: …
  • Member Avatar for cereal
    cereal

    Replied To a Post in Unknown column ---' in 'field list'

    Ok, it happens because the `topics` table is not listed it the FROM statement, add it as a JOIN, it should fix this issue.
  • Member Avatar for cereal
    cereal

    Replied To a Post in Unknown column ---' in 'field list'

    Good, can you show also the query cited in your first post?
  • Member Avatar for cereal
    cereal

    Replied To a Post in Unknown column ---' in 'field list'

    Ok, can you show the full query and the create table statement? Run: `show create table topics;`
  • Member Avatar for cereal
    cereal

    Replied To a Post in Unknown column ---' in 'field list'

    Hi, `topics.id` stands for `tableName.columnName`, if this is not the case and you have a column name with a dot, then do: SELECT `topics.id` FROM `topics`; This will select the …
  • Member Avatar for cereal
    cereal

    Replied To a Post in Int

    > A string is not an integer. in PHP, from the POST and GET arrays, you always get strings, even if submitting integers. PHP does automatic type casting, but it …
  • Member Avatar for cereal
    cereal

    Replied To a Post in Code continues execution even after header redirect

    Set `exit;` after the redirect, as in this comment: * http://php.net/manual/en/function.exit.php#90713 That will stop the execution of the following code. Bye!
  • Member Avatar for cereal
    cereal

    Replied To a Post in How does a new post inserted into wp_post updates wp_postmeta in wordpress

    Hi, use the search box in the developers website: * https://developer.wordpress.org/reference/ From there you can see how the add and update metadata functions are used and in which files are …
  • Member Avatar for cereal
    cereal

    Replied To a Post in How to automatically create dummy content?

    Hi, I use this tool: http://www.generatedata.com/ The online version is limited to 100 entries, but it can be downloaded for free from github and loaded in local PHP server, just …
  • Member Avatar for cereal
    cereal

    Replied To a Post in Replace eregi_replace expression with preg_replace

    Hi, just add delimiters to the pattern variable, in your case it's `$word`, for example: <?php $color = 'red'; $text = 'This is an example text sentence.'; $eregPattern = 'example'; …
  • Member Avatar for cereal
    cereal

    Replied To a Post in Attendance form and healthcheck form help

    The `$id` variable is undefined, at line 96 you check if it's empty but you're not defining it anywhere, so the condition will always be false and you will get …
  • Member Avatar for cereal
    cereal

    Replied To a Post in Return array from prepared statement

    > But what if I cannot install anything? This isn't my server. I'm using hosting. In this case ask the provider if they will introduce it and/or use the fetch …
  • Member Avatar for cereal
    cereal

    Replied To a Post in Return array from prepared statement

    You get *undefined* because `get_result()` is a function introduced by the `mysqlnd` (MySQL Native Driver). Usually if you're using **PHP 5.4** and above this is the default, otherwise PHP will …
  • Member Avatar for cereal
    cereal

    Replied To a Post in How do prepared statements even work?

    After the `execute()` do: $stmt->store_result(); Then you can call `$num_rows`: $stmt->execute(); $stmt->store_result(); if ($stmt->num_rows > 0) { http://php.net/manual/en/mysqli-stmt.num-rows.php
  • Member Avatar for cereal
    cereal

    Replied To a Post in How do prepared statements even work?

    > But what is $stmt->bind_result($district); does it just store result in $district? Yes, but only for the current result pointer. > Is this correct: You have to store the result, …
  • Member Avatar for cereal
    cereal

    Replied To a Post in How do prepared statements even work?

    Hi, `s` stands for string, if you want two conditions, for example a string and a digit you will write: $city = 'Aurora'; $state_id = 1; bind_param("si", $city, $state_id) Read …
  • Member Avatar for cereal
    cereal

    Replied To a Post in What's wrong with this SQL query?

    You can enable the compatibility to the ANSI standard by switching the SQL mode, see: * http://dev.mysql.com/doc/refman/5.7/en/compatibility.html * http://dev.mysql.com/doc/refman/5.7/en/sql-mode.html With that you, then, can use double quotes to define the …
  • Member Avatar for cereal
    cereal

    Replied To a Post in What's wrong with this SQL query?

    Hi, don't use single or double quotes around table and column names, otherwise these are interpreted as strings, use backticks, so: INSERT INTO `members` (`username`, `password`, `email`) VALUES ('axe', 'axe', …
  • Member Avatar for cereal
    cereal

    Replied To a Post in Attendance form and healthcheck form help

    Could you paste the code here?
  • Member Avatar for cereal
    cereal

    Replied To a Post in Excel Upload fast

    Hi, can you show us the insert script?
  • Member Avatar for cereal
    cereal

    Replied To a Post in Session variables ($_SESSION['username']) inside a function

    Hi, in this case it would be `bindColumn()` instead of `bind_result()` as the OP is using PDO, not MySQLi: * http://php.net/manual/en/pdostatement.bindcolumn.php // edit I added the PDO tag to the …
  • Member Avatar for cereal
    cereal

    Replied To a Post in what should i study to learn ORACLE?

    Hi, I would probably start from this link: * http://www.oracle.com/technetwork/database/features/plsql/index.html
  • Member Avatar for cereal
    cereal

    Replied To a Post in Insert 10000 records in MYSQL using php

    **@Awais_2** hello, please: follow the community rules, open a new thread and share the code that is giving you the issue.

The End.