-
Replied To a Post in No data supplied for parameters in prepared statement
Hi, you're defining the variables after the binding, this will lead to an error, try: $nm = $_POST['nm']; $nm = $_POST['ln']; $gd = $_POST['gd']; $tl = $_POST['tl']; $ar = $_POST['ar']; … -
Replied To a Post in send mail : use an image as body cotent
In addition, if you're using Laravel, then you can use the `asset()` helper: $link = asset("/images/Work_Anniversary.png"); This will prepend the application url. -
Replied To a Post in Change Ruby to PHP
Try to change the header to: curl_setopt($curl, CURLOPT_HTTPHEADER, array( "Authorization: Token token=$token" )); Then it should work fine. To debug the request add: curl_setopt($curl, CURLINFO_HEADER_OUT, true); And: $info = curl_getinfo($curl, … -
Began Watching space & not displaying in some iOS devices
I've had two users request that we add a space between their first and last names as displayed in a table. Problem is: there is a space. Common denominator is … -
Began Watching Change Ruby to PHP
How can I convert this Ruby Gem to PHP? token = "your_nypl_api_token" client = NyplRepo::Client.new(token) ``` ``` token = "your_nypl_api_token" options = {:debug => true, :server_url => "http://api.repo.nypl.org/api/v1"} client = … -
Replied To a Post in Codeigniter DB Active Record Join
Hi, I haven't tested this but try to set the subquery in the `select()` method: $this->db->distinct(); # select $this->db->select("*, (SELECT GROUP_CONCAT(cd1.name ORDER BY level SEPARATOR ' > ') FROM " . $this->db->dbprefix … -
Began Watching Classified software
Hello All, We have created classified software for real estate market. We could say that software is now ready for additional niche markets. Markets that we are intend to market: … -
Replied To a Post in works on local server but not live
In addition, you could use `mysqli_fetch_all()` to retrieve all the rows: $result = mysqli_fetch_all($query, MYSQLI_ASSOC); foreach($result as $key => $row) { echo $row['title'].'<br>'; } But it requires Mysqlnd (the native … -
Began Watching Retrieve html/DOM using Selenium/PHPUnit and PHP/cURL
Hey guys, this seems to be a thorn in my side. I've been working on scraping a website which uses aspx and has eventvalidation/viewstate inputs. Every other scraping experiment I've … -
Replied To a Post in Need help in PHP/MYSQL Code
It happens because `$connect` is defined out of the scope of the function, to fix it do: <?php include 'config.php'; function findProducts($connect) { $query = mysqli_query($connect, "SELECT * FROM cart"); … -
Replied To a Post in My first custom PC
In these cases you should hear some beeps from the motherboard, the sequence can help you to understand the issue, in the documentation you should find the meaning of each … -
Gave Reputation to diafol in relationships between tables
Providing you with answers to homework (if that's what it is), will not help you. Helping you understand relationships may. For example: One-to-one One-to-many Many-to-many One-to-one may be useful if … -
Replied To a Post in problem with initializing a counter in a for loop in php script
@Nilo, do: $row = $conn->query("SELECT MAX(id) AS last_id FROM Posts")->fetch(PDO::FETCH_OBJ); echo $row->last_id; It's important to define an alias `MAX(id) AS last_id` otherwise you get: stdClass Object ( [MAX(id)] => 100 … -
Replied To a Post in problem with initializing a counter in a for loop in php script
If there are not previous insert queries, then `lastInsertId()` will return `0`, for this reason the loop does not run. The MySQL documentation explains the reason: > The ID that … -
Replied To a Post in problem with initializing a counter in a for loop in php script
Hi, can you show the query? -
Replied To a Post in return value from If statement scope
Once you get through the IF statement the new value, for the **$level** variable, will be valid for the remaining code: $level = 0; echo $level; # outputs: 0 # … -
Replied To a Post in Without clicking browse button on image upload, how can we give name.
You're welcome! -
Replied To a Post in Password Displaying in Address Bar After Form Submission
I suppose you're using this plugin: http://jqueryvalidation.org/ If yes, then it seems you can define only one validation process for the chosen form, so don't set two of them: $('#DemoForm').validate({ … -
Replied To a Post in Without clicking browse button on image upload, how can we give name.
Hi, this is an intended behaviour of the browser, a website cannot define the file to upload from a client system, otherwise it could be used to steal anything. In … -
Marked Solved Status for "read" icon
Hi all! I don't know if this occurs only to me but in the forum list view the **read** text icon wraps to a new line, like this:  Here's … -
Replied To a Post in "read" icon
It's fine, thank you Dani! -
Began Watching Corrupt MySQL db - I'm a noob lost in the woods
I work for a small company made up of a salesman, a graphic artist, and an engineer. The engineer writes and maintains all of his own software to run a … -
Replied To a Post in Password Displaying in Address Bar After Form Submission
Ok, I think you have to fix the opening form tags, at the moment you have three of them, the first is not closed and it will lead to some … -
Replied To a Post in Password Displaying in Address Bar After Form Submission
A POST request does not append any information to the url, it uses a separated request body, but it is possible to append GET variables to a POST request url. … -
Replied To a Post in Password Displaying in Address Bar After Form Submission
It happens when you use the GET method, use POST instead. -
Created "read" icon
Hi all! I don't know if this occurs only to me but in the forum list view the **read** text icon wraps to a new line, like this:  Here's … -
Replied To a Post in Php+ Google Maps javascript Api v3
Hi, it is possible, read these articles: * https://developers.google.com/maps/articles/phpsqlajax_v3 * https://developers.google.com/maps/articles/phpsqlsearch_v3 but your question is a bit vague. If you offer more details, maybe we can suggest you better. Bye! -
Replied To a Post in how to format date in db with php
Hi! That's the format supported by the database, save it like this, then when your get the result set format as you prefer. You can do it directly at query … -
Replied To a Post in changing python code to php
Hi, if I'm not wrong, this script is creating database tables and procedures, I suppose for MS SQL, so all you need is to convert them to queries that you … -
Gave Reputation to Niloofar24 in problem with putting variable sending with submit button into LIMIT part
Yes it work ok now. Thank you @cereal for clear explanation and for updating my code:) I understood it well. -
Replied To a Post in problem with putting variable sending with submit button into LIMIT part
Ok, I got it, your code is perfect, the issue is in my logic. By starting everything by zero I wasn't considering that when the **$pages** variable was divisible by … -
Replied To a Post in Why doesnt worki this code ?
You're welcome! ;) -
Replied To a Post in Why doesnt worki this code ?
The query is still a problem, it is not correct to add an `or die()` statement to a query string that needs to be executed. Regarding the IF condition fix … -
Replied To a Post in Why doesnt worki this code ?
A problem is this: $sql ="UPDATE login SET firstname = '$newfirstname' WHERE ID=$dbid" or die ("cant update " . mysqli_error($con)); Do only: $sql = "UPDATE login SET firstname = '$newfirstname' … -
Replied To a Post in problem with putting variable sending with submit button into LIMIT part
> Why you set $error = FALSE; and $result = FALSE; to False? This is done to initialize the variables in my test script, otherwise if the database fails for … -
Began Watching jQuery - Disabling Submit Button for Multiple Fields
Hello, I am experimenting with implementing jQuery to validate my form (I hired a programmer one year ago to do this but it seems she made a mess of it … -
Replied To a Post in How to retrieve a single row
No problem & happy holidays ;) It can be done with MySQLi but you're mixing procedural and object oriented (OOP) styles. In OOP the connection is open like this: $db … -
Replied To a Post in problem with putting variable sending with submit button into LIMIT part
Hmm, no I don't think so. I wrote a test script, check if it works for you: <?php $servername = "localhost"; $dbname = "mydbname"; $dbusername = "mydbusername"; $dbpassword = "mydbpassword"; … -
Replied To a Post in Help decoder files!
Hi, why don't you contact the developer? You can find his name and email address in the first bits of each file. -
Replied To a Post in problem with putting variable sending with submit button into LIMIT part
Whoops! I'm sorry, I did a mistake when I defined the default values, change lines from `11` to `19` with this: $get_pages = isset($_GET['page']) ? $_GET['page'] : 0; $data = … -
Began Watching Most suitable Linux for server that only needs to receive (and process)data
I just couldn't fit all of it in the title, actual title is: **How to send and receive messages (data packets) between UI and the server. And what would be … -
Began Watching remove portion of a string
hello everyone, I am looking to remove some stuff from my string: $list = "7:2,3:1,5:1,33:1,23:2"; $list = "7:2,3:1,33:1,23:2"; // REMOVE THE "5:1," OR ANY OTHER DINAMICALY AT ANY POSITION $list … -
Replied To a Post in problem with putting variable sending with submit button into LIMIT part
The `trim()` function is used to remove leading and trailing spaces, for example: $a = ' 1'; var_dump($a); Outputs: `string(2) " 1"`, instead: $b = trim($a); var_dump($b); Outputs: `string(1) "1"` … -
Replied To a Post in problem with putting variable sending with submit button into LIMIT part
My fault, sorry: you have to pass an integer to the bind method, from the form it receives a string and so the query will output badly, something like: LIMIT … -
Replied To a Post in problem with putting variable sending with submit button into LIMIT part
Ok, it works fine for me. Can you show your current code? -
Replied To a Post in Error message
It returns boolean (`FALSE` in this case) because the query will generate an error, due to a quote placed in the wrong place `s.type='c)'`, so change this: $sql = "SELECT … -
Replied To a Post in problem with putting variable sending with submit button into LIMIT part
Hi, add a space after `LIMIT`, at the moment when executed it will print `LIMIT20, 3` instead of `LIMIT 20, 3`. But validate and sanitize the number. For example: $number … -
Replied To a Post in How to retrieve a single row
The variable `$pdo`, in my example, is the object that carries the connection to the database, for example: $pdo = new PDO("mysql:dbname=DATABASE", "USERNAME", "PASSWORD"); Documentation: http://php.net/manual/en/pdo.query.php -
Began Watching Ignore temporary tables in replication
Hi all, Is it possible to ignore temporary tables in mysqlbinlog file for replication. -
Replied To a Post in How to retrieve a single row
Ok, if `country_id` is unique then you don't need the `limit` statement. Use `mysql_fetch_row()` instead of `mysql_fetch_array()`, but you really should not use these function anymore, these are deprecated and …
The End.