-
Replied To a Post in Community related e-mail
It works, thank you as always Dani! -
Gave Reputation to Dani in Community related e-mail
OK, I am able to reproduce it. I will investigate :) -
Created Community related e-mail
Hello, everytime I set the checkbox to get community related e-mails and update the profile, it seems to work and if it occurs an event I get the notification, but … -
Replied To a Post in Best Practice for Using HTTP Referrer with CGI/Perl
Hello, are you aware that the referrer can be spoofed? Simple test: 1. open a terminal and type: `nc -l 8000` 2. open another terminal and type: `curl --verbose --header … -
Replied To a Post in How to syncronize local database (MySQL) and web database (MySQL) using VB
Hi, you can setup a replication model: master to master or master to slave. See: * http://dev.mysql.com/doc/refman/5.7/en/replication-howto.html I suggest you to do a research on Google about **MySQL Replication**, you … -
Replied To a Post in AM/PM in ASC MYSQL
**@Antony** try: SELECT * FROM `TABLENAME` ODER BY date_format(str_to_date(`TIME_COLUMN`, '%r'), '%T') ASC; This will convert the string to a timestamp that MySQL can parse, then use `%T` to get the … -
Replied To a Post in Trouble with Codeigniter + AR + Highcharts
Addition: I forgot CI ships with an Output class, which is loaded by default, so you can also send JSON data in this style: $this->output ->set_header('HTTP/1.1 200 OK') ->set_content_type('application/json', 'utf-8') … -
Replied To a Post in $this->load function in Core file of codeigniter
Hello, in `./application/core/` create the file **MY_Controller.php** and extend it to `CI_Controller` and add a public (or protected) **$data**: class MY_Controller extends CI_Controller { public $data; public function __construct() { … -
Replied To a Post in Trouble with Codeigniter + AR + Highcharts
**@Mario** no problem. The blank page can be caused by a PHP error, check the PHP error log or the log file created by CodeIgniter, it should be in `./application/logs/` … -
Replied To a Post in Regular Expression
Hi, go to http://regexr.com/3eb88 and mousehover the components of the expression (or hit the Explain tab), it will explain the meaning of each block. If you have some sample data … -
Replied To a Post in Trouble with Codeigniter + AR + Highcharts
Hi, in your method controller `data_fik()` replace this: print json_encode($result, JSON_NUMERIC_CHECK); $data['body'] = 'hchart_elec'; $this->load->view('main', $data); with: header('Content-Type: application/json; charset=utf8'); echo json_encode($result, JSON_NUMERIC_CHECK); You don't neet to load a view, … -
Replied To a Post in Website loads weird
**@rproffitt** hi, that bit.ly points to http://renardwatches.com/ (it seems to work for me) -
Began Watching 1 to 1 chat script using php mysql websocket
I have created template for user to user chat module. Need help to complete realtime chat. Need some validations like highlight chat window on message received if it is inactive. … -
Gave Reputation to Amaina in PHP SimpleXML parsed data into MySQL table
Thank you @Cereal and @Taywin for the thoughtful and useful comments. The ` implode()`option has given me what i wanted. -
Replied To a Post in PHP SimpleXML parsed data into MySQL table
Hello, so, standing at the original example you want two rows for each `date > item`, correct? Use `implode()` after each cycle, change this: # loop each date > item … -
Replied To a Post in Notepad remove everything after '('
Yes, I noticed that only after your answer. Usually Stefan writes about PHP, so I went in automatic. My bad. -
Gave Reputation to Reverend Jim in Notepad remove everything after '('
You might want to use [Notepad++](https://notepad-plus-plus.org/) instead of Notepad. It's better, supports regular expressions, and is free. Your search term as a regex is \(.*$ and your replacement text is … -
Replied To a Post in Notepad remove everything after '('
Wait, was it about the editor?! O_O I thought it was about PHP, sorry! -
Replied To a Post in Notepad remove everything after '('
If you just need to remove what comes after the first occurrence of the bracket and display what is remaining, then you could basically loop the input into `strstr()`, like … -
Replied To a Post in Parsing Xml to extract attributes
It happens because you have to manually move to the next node, you can do like this: <?php $file = 'dates.xml'; $xml = simplexml_load_file($file); # loop each <date> node foreach($xml->date … -
Replied To a Post in php
Hello, you can use sessions to restrict the access only to authenticated users, see: * http://php.net/manual/en/book.session.php * http://php.net/manual/en/session.security.php -
Gave Reputation to rproffitt in php on Mysql
Here's what I do to prototype such a search. I usually have an example output (report) that I am attempting to achieve. Then I manually craft a SQL command using … -
Replied To a Post in Need some download help in Codeigniter
**@mohammad** Hello, please provide more information (e.g. are you using CodeIgniter?) and your current code, also **open your own thread.** -
Replied To a Post in How to scrap a website in node.js
Hello, I have not tested but check this module, it seems interesting: * https://www.npmjs.com/package/simplecrawler * https://github.com/cgiffard/node-simplecrawler -
Replied To a Post in IMAP & junk mail
Turns out they don't support custom flags, they only support those listed here: string (59) "* FLAGS (\Seen \Answered \Flagged \Deleted \Draft $MDNSent)" When custom flags are enabled then there … -
Replied To a Post in Send HTML Mail with Values via PHP
Hi, see example #4 in the PHP documentation for the `mail()` function: * http://php.net/manual/en/function.mail.php however, there are some libraries that can help when you want to add other features, like … -
Created IMAP & junk mail
Hello, on Hotmail/Outlook webmail, when I receive an email message in the spam folder (formally Junk), I can mark the message as **Not Junk**. The server will then start to … -
Replied To a Post in programming
In addition: if 2FA is enable the script will need an **application password.** See: https://support.google.com/mail/answer/185833?hl=en -
Began Watching Mysql Migration To Elasticsearch
Hi, I was asked by my lead engineer to configure and migrate current database to elasticsearch that he believe will overcome the slow query issues . We are using laravel … -
Replied To a Post in MYSQL Excel Upload
Hi, you can convert the XLS to a CSV file and then import. Some forks of MySQL allow connection to outer data sources, through ODBC, so you can open an … -
Replied To a Post in insert user details with photo into database
Hi, the file does not get into the database or it is just corrupted? A blob type column of which size? If you are using, say `BLOB`, then it can … -
Replied To a Post in Looping through rows and replace values
Hi, I have an idea for this. You could write a sequencer function, to keep track of the count. You need InnoDB tables to do this, transactions and a function: … -
Began Watching Looping through rows and replace values
I have 2 tables that look like this.(see below). Table one is named tableX and table 2 is named tableY. +-------+---------+ | count | post_id | +-------+---------+ | 3 | … -
Gave Reputation to happygeek in How do i publish my website on my PC?
> How do I learn web development as quickly as possible? Hypnotism. -
Replied To a Post in Option List
Hi, you have to fetch results, see the following thread for details, it seems the same issue: * https://www.daniweb.com/programming/web-development/threads/504502/only-first-sql-row-is-getting-understood -
Replied To a Post in help i used forms html with php and getting the wrong email!
Did you fix it? In practice, you have to change these lines: if (isset($play)) {$play="yes";} else {$play="NO";} if (isset($work)) {$work="yes";} else {$work="NO";} if (isset($movies)) {$movies="yes";} else {$movies="NO";} if (isset($other)) {$other="yes";} … -
Replied To a Post in Cannot Retrieve Pdf From Mysql Using Fpdi In Php
Hi, according to FPDF manual the `Output()` arguments must be reversed, instead of: $pdf->Output('newpdf.pdf', 'D'); Do: $pdf->Output('D', 'newpdf.pdf'); Documentation: * http://www.fpdf.org/en/doc/output.htm Also, if you want to force the download, then … -
Replied To a Post in help i used forms html with php and getting the wrong email!
Hi, it seems you're trying to access the variables, sent by the POST request, through the `register_globals` directive, which initialize new variables basing on what is sent to the script, … -
Replied To a Post in How to PM
I have different results here: under the *All my conversations* tab I have only the messages of the last two months, starting from the switch. All previous messages never showed. -
Gave Reputation to AndrisP in getting “mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean
For first: $id = $_GET['id']; $action = $_GET['action']; is not good practice! It raise PHP error if not set. All request variables initialize like this: $id = ( isset($_GET['id']) ? … -
Replied To a Post in unsigned smallint in sqlite
Hi, try the `CHECK()` constraint, for example: CREATE TABLE test ( number SMALLINT CHECK(number BETWEEN 0 AND 65535) ); When you try to insert something out of that range, it … -
Replied To a Post in PHP login Form
Hi, can you describe the problem? -
Gave Reputation to diafol in Is Search Broken Again?
Still a month later? Search is sucking large: https://www.daniweb.com/search/index/0?q=php+mysql#gsc.tab=0&gsc.q=php%20mysql&gsc.page=1 Only one result with "php mysql". Most searches I try with my name in them, give no results. -
Replied To a Post in Security question
**@TexWiller** sorry, I explain you why I asked if the database is in the OP location and not in the web server: in that case he would have to setup … -
Replied To a Post in Security question
I have some questions to ask here: * is the database in your location? * can the database accept remote connections? * can you define which IPs are allowed to … -
Replied To a Post in Help, can't get images to upload with php...
Hi, the target directory must be an internal path, not the domain as defined here: $target_dir = "http://www.XXXXXX.com/uploads/"; Start by changing that. -
Began Watching MySQL restored files
After a server issue, my client has restored the MySQL files before their issue, but MySQL is having problems bringing their database back up. (i'm waiting for more information as … -
Replied To a Post in error sourcing file, MariaDB/MySQL
Hi, in the first line (`drop ...`) is missing the separator (the semi-colon in this case), so all the following falls into a syntax error. -
Replied To a Post in is it possible to run php page from lua code?
Hi, I don't know LUA, but I'm sure there are some functions that allow to execute system commands, check the documentation and the wiki of the LUA page, as test … -
Gave Reputation to diafol in Mysqli Syntax Error keeps coming up
OK. Sometimes fieldnames or tablenames for that matter share their names with reserved words: https://dev.mysql.com/doc/refman/5.7/en/keywords.html In this case, it could be ambiguous to the query parser, so we enclose fieldnames …
The End.