• Member Avatar for cereal
    cereal

    Replied To a Post in Mysql load infile

    Hi, look at the result message: Query OK, 0 rows affected, 33 warnings (0.00 sec) Records: 11 Deleted: 0 Skipped: 11 Warnings: 33 by running `SHOW WARNINGS;` after the load …
  • Member Avatar for cereal
    cereal

    Replied To a Post in information not adding to database

    No, she's checking if the article exists in the `articles` table, if TRUE then she adds the rating to the `articles_rating` table.
  • Member Avatar for cereal
    cereal

    Replied To a Post in information not adding to database

    Hi, it seems fine to me. Make sure the database connection is available by adding an error check: if ($db->connect_errno) { die('Connect Error: ' . $db->connect_errno); } Check also if …
  • Member Avatar for cereal
    cereal

    Replied To a Post in Size in mb of a fb feed

    Hi, check these white papers: * https://research.facebook.com/publications/storage-infrastructure-behind-facebook-messages-using-hbase-at-scale/ * https://research.facebook.com/publications/finding-a-needle-in-haystack-facebook-s-photo-storage/ * https://research.facebook.com/publications/f4-facebook-s-warm-blob-storage-system/
  • Member Avatar for cereal
    cereal

    Replied To a Post in Does $_GET and AJAX perform well?

    Look also at a PHP Accellerator like APC: https://en.wikipedia.org/wiki/List_of_PHP_accelerators
  • Member Avatar for cereal
    cereal

    Gave Reputation to FarrisFahad in Can someone help me understand PayPal IPN

    For anybody who is still struggling ... Here is what I have understood: 1. The request type which is equal to Notify Validate, which means we want to validate that …
  • Member Avatar for cereal
    cereal

    Gave Reputation to ryantroop in Ajax call returning unprocessed PHP

    I disagree that changing the header type of the AJAX call is the ONLY change that needs to be changed. The reality is, as long as a request without headers …
  • Member Avatar for cereal
    cereal

    Gave Reputation to ryantroop in Ajax call returning unprocessed PHP

    I disagree that changing the header type of the AJAX call is the ONLY change that needs to be changed. The reality is, as long as a request without headers …
  • Member Avatar for cereal
    cereal

    Replied To a Post in SQL Like Command - how to find records without 1-9 but using 0

    The column is a string type and the value is literally something like `0 values` or is an integer, float column? Can you show the table schema and an example …
  • Member Avatar for cereal
    cereal

    Replied To a Post in Attachments in Email

    Hi, the attachment is sent to Gmail servers. Yahoo will only deliver the mail. In practice the email body attachment part is composed by an header and by the content, …
  • Member Avatar for cereal
    cereal

    Gave Reputation to diafol in 2016

    I'm going to be adding my name to the MIAs. Nothing left on here to do, been run into the ground. Take care and good luck all. May see you …
  • Member Avatar for cereal
    cereal

    Began Watching 2016

    Posts | Posters 0 | 15 1-10 | 4 11-20 | 1* 51-60 | 1 61-70 | 1 > 100 | 3 (missing ranges = 0 posters) Apart from the …
  • Member Avatar for cereal
    cereal

    Replied To a Post in fg_membersite.php

    Which PHP version are you using? Note that the fork is using at least a function available only on PHP 5.5.0+, `hash_pbkdf2` used to hash the password: * http://php.net/hash-pbkdf2 Consider …
  • Member Avatar for cereal
    cereal

    Replied To a Post in fg_membersite.php

    You could try to add some conditions to the methods involved in the process, to see if you can track down the error, otherwise try to contact the current maintainer, …
  • Member Avatar for cereal
    cereal

    Replied To a Post in fg_membersite.php

    Hi, you can find a fork of the original code on GitHub, which has been updated to MySQLi, here's the link to the code: * https://github.com/ug2215/RegistrationForm The upgraded fork was …
  • Member Avatar for cereal
    cereal

    Replied To a Post in Color while printing

    It's used to load an external resource, in this case a stylesheet with specific rules for a printer version of the HTML page, check: * https://developer.mozilla.org/en-US/docs/Web/HTML/Element/link * https://www.smashingmagazine.com/2011/11/how-to-set-up-a-print-style-sheet/ The above …
  • Member Avatar for cereal
    cereal

    Replied To a Post in What are the steps to integrate a PayPal IPN system in my website

    Do you mean a payment from **user A** to **user B** without involving your account? Check the **Adaptive Payments API**: * https://developer.paypal.com/docs/classic/products/adaptive-payments/
  • Member Avatar for cereal
    cereal

    Replied To a Post in mysql memory usage

    Hi, it could be a problem with the `innodb_buffer_pool_size`, the default value is 128MB of RAM, try to increase it, you can follow the suggestions in the documentation: * https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html#sysvar_innodb_buffer_pool_size …
  • Member Avatar for cereal
    cereal

    Gave Reputation to gentlemedia in web design

    By downloading and implementing Bootstrap you will not learn how to create responsive websites. It's a shortcut and you can create them, but without knowing the core concept of RWD …
  • Member Avatar for cereal
    cereal

    Stopped Watching Simple instant price quote javascript

    Hi there, I'm trying to create an instant price calculator in Javascript . Similar to https://mixam.co.uk/brochures but hopefully less complicated. I have 4 fields; 'Paper Size' 'Pages' 'Numbering' 'Quantity' I've …
  • Member Avatar for cereal
    cereal

    Began Watching Simple instant price quote javascript

    Hi there, I'm trying to create an instant price calculator in Javascript . Similar to https://mixam.co.uk/brochures but hopefully less complicated. I have 4 fields; 'Paper Size' 'Pages' 'Numbering' 'Quantity' I've …
  • Member Avatar for cereal
    cereal

    Replied To a Post in Connecting to remote hidden mySQL server

    2 & 3 are obvious, yes, I was repeating them just to clarify point 7: not all hostings will allow Tor nodes in their networks, so it would be difficult …
  • Member Avatar for cereal
    cereal

    Began Watching Connecting to remote hidden mySQL server

    A theoretical question about connecting to hidden services through PHP. Say I am writing an application on the clearnet that relies on data stored within a mySQL database that is …
  • Member Avatar for cereal
    cereal

    Replied To a Post in cURL Doesn't Work On Same Host Anymore

    Hi, what's the result of curl_error()?
  • Member Avatar for cereal
    cereal

    Replied To a Post in Connecting to remote hidden mySQL server

    Is there a specific reason for this setup? Some points to consider: 1. MySQL does not support socks connections, you can create a socket unix file, but it's not the …
  • Member Avatar for cereal
    cereal

    Replied To a Post in mysqli_real_escape_string is not working properly

    Then add error checking to the connection and to the query: $link = @mysqli_connect($servername, $username, $password, $dbname); if ( ! $link) die('Connect Error: ' . mysqli_connect_error()); # . . . …
  • Member Avatar for cereal
    cereal

    Replied To a Post in Color while printing

    Hi, how did you applied the color to the box? Stylesheets? And if affirmative, did you used a media print stylesheet? For example: <link rel="stylesheet" href="/styles/print.css" media="print"> And: are you …
  • Member Avatar for cereal
    cereal

    Replied To a Post in mysqli_real_escape_string is not working properly

    Hi, you're mixing *object* `$conn` with *procedural* `$link` and opening two indipendent connections to the database, if you want to stick with procedural, then change: $result = mysqli_query($conn, $sql); to: …
  • Member Avatar for cereal
    cereal

    Replied To a Post in Adult Website On Portfolio?

    > I'm thinking not because I don't really want "smutt" related to my website. It's probably the same for your other clients, I doubt they would like to be associated …
  • Member Avatar for cereal
    cereal

    Replied To a Post in What are the steps to integrate a PayPal IPN system in my website

    Hi, in practice this is a page that waits for a POST form submission, made by the PayPal service. An example can be found in their GitHub account: * https://github.com/paypal/ipn-code-samples/blob/master/paypal_ipn.php …
  • Member Avatar for cereal
    cereal

    Replied To a Post in Supervisord restart script only if it crashed

    Hi, check the **Process States** documentation: * http://supervisord.org/subprocess.html#process-states * http://supervisord.org/configuration.html?highlight=exitcodes In practice: define the expected `exitcodes` for the script and then set `autorestart=unexpected` so that it will restart only when …
  • Member Avatar for cereal
    cereal

    Replied To a Post in Android Checkbox Update PHP MySql

    By the way, you're missing the `$` symbol in the `$_POST` array: $blood_typeA = _POST['Blood_TypeA']; $blood_typeB = _POST['Blood_TypeB']; $blood_type0 = _POST['Blood_Type0']; $blood_typeAB = _POST['Blood_TypeAB']; Should be: $blood_typeA = $_POST['Blood_TypeA']; And …
  • Member Avatar for cereal
    cereal

    Replied To a Post in Convert PHP dates

    Hi, if you have, or can enable, the **intl** extension then use the [`IntlDateFormatter`](http://php.net/manual/en/class.intldateformatter.php) class: * http://php.net/manual/en/intldateformatter.format.php Look also at the comments in the documentation page.
  • Member Avatar for cereal
    cereal

    Replied To a Post in Fatal error

    Hi, A good point to start to investigate the issue is **sale2.php on line 58**, can you show us that part of code? I mean: paste the relevant code not …
  • Member Avatar for cereal
    cereal

    Replied To a Post in PHP adding variables to string

    When you use double quotes you can include the variable and this will be expanded to the associated value. The curly braces `{$var}` are used to write complex expressions when …
  • Member Avatar for cereal
    cereal

    Replied To a Post in Php MySql Multiple Insert

    **@Natsu123** please reply with a post, not with comments. Can you show the table schema for `T_school`? In practice run: show create table T_school; And return the output here.
  • Member Avatar for cereal
    cereal

    Replied To a Post in Php MySql Multiple Insert

    Not tested but try: $sql = <<<EOD INSERT INTO T_Student(Name, Surname, Street, City, F_ID_Teacher) VALUES('$Name', '$Vorname', '$Strasse', '$Plz', '2'); SET @id = last_insert_id(); INSERT INTO T_Class(Subjekt, Number, F_ID_Student) VALUES('', '', …
  • Member Avatar for cereal
    cereal

    Replied To a Post in HTTP PUT method confusing

    Hi, PHP does not have a $_PUT method (unfortunately) so, in order to accept such input you have to listen for stdin streams. The following documentation explains how you can …
  • Member Avatar for cereal
    cereal

    Replied To a Post in difference between '$x' and "$x" in php?

    Hi, if you want to return the value of a variable then use double quotes, if you want to return plain text, then use single quotes. For more information check …
  • Member Avatar for cereal
    cereal

    Replied To a Post in why i cannot connect the the server

    > i have deleted them and placed my files there. Maybe its because of them ? This should not affect the execution of your scripts or the connection, in general, …
  • Member Avatar for cereal
    cereal

    Replied To a Post in why i cannot connect the the server

    Hi, supposing `31.170.161.176` was your IP address, you cannot connect directly from your computer to the 000webhost MySQL server because remote connection is disabled, unless you upgrade your account: * …
  • Member Avatar for cereal
    cereal

    Replied To a Post in Impossible to download jquery

    Hi, which error? Can you be more specific?
  • Member Avatar for cereal
    cereal

    Replied To a Post in Insert json data into mysql table

    Hi, it should be possible, try by decoding the json data to array and use `array_column()`, see the examples in the documentation: * http://php.net/array-column If you need more help, open …
  • Member Avatar for cereal
    cereal

    Replied To a Post in Uploading multiple images in codeigniter??

    Hi, this should work: public function upload_multi() { $config['upload_path'] = FCPATH . 'uploads/'; $config['allowed_types'] = 'gif|jpg|png'; $config['remove_spaces'] = TRUE; $config['encrypt_name'] = TRUE; $config['max_size'] = '10000'; $config['overwrite'] = FALSE; $this->load->library('upload', $config); …
  • Member Avatar for cereal
    cereal

    Replied To a Post in display particular images in codeigniter

    Hi, first of all, you have to run `$this->load->view('page', $data);` in your method controller. Also could you indent your code of the **view page**?
  • Member Avatar for cereal
    cereal

    Replied To a Post in Codeigniter

    Hi, you can use the Form helper, like in the documentation example: * https://codeigniter.com/user_guide/helpers/form_helper.html?highlight=form#form_dropdown Otherwise you can use custom code. Have you tried to write some code? Show it to …
  • Member Avatar for cereal
    cereal

    Replied To a Post in PHP/MySQL login error

    It was `$rows` not `$row`, the variable was overwriting itself, anyway to avoid confusion do: $sql = "SELECT * FROM admin WHERE username = '$username'"; $rows = query($sql); if(is_array($rows) && …
  • Member Avatar for cereal
    cereal

    Replied To a Post in PHP/MySQL login error

    If the **functions.php** file is included by the **config.php** file then try: $rows = query($rows); It should work and return an associative array.
  • Member Avatar for cereal
    cereal

    Replied To a Post in PHP/MySQL login error

    I was talking about these lines: // query database for user $rows = "SELECT * FROM admin WHERE username = '$username'"; // if we found user, check password if (count($rows) …
  • Member Avatar for cereal
    cereal

    Replied To a Post in How to install and use pyinstaller in Kali linux

    Ops! I forgot to complete the command: sudo ln -s $PWD/pyinstaller.py /usr/bin/ Bye!

The End.