-
Replied To a Post in help in inserting data from one table into another table
Hi, in my opinion you don't strictly need a new table. To generate a live rank you could add an internal counter to the query, select the results as a … -
Replied To a Post in help in inserting data from one table into another table
Hi, remove the `WHERE` condition and add `GROUP BY student_code` to the **select** statement and it should work fine, but consider that you could use a view, otherwise when you … -
Began Watching IIS WSDL Caching
Hi All We are having an issue where a WSDL is loading another WSDL into it when we call it. This call takes a while on the first call which … -
Began Watching Your opinion about abandoning InnoDB and return to MyISAM?
I am posting it here because I would really like to read other opinions. I am creating a module for a framework that anyone could install in its system and … -
Gave Reputation to donz365 in Soap Query Parameter Head Ache ;(
Thanks Cereal for helping with this. The problem was my client was sending back extra charaters which were causing errors. These articles explain it in detail... [qa-byte-order-mark](http://www.w3.org/International/questions/qa-byte-order-mark.en.php) [detecting-utf-bom-byte-order-mark](https://web.archive.org/web/20100430055100/http://www.dotvoid.com/2010/04/detecting-utf-bom-byte-order-mark/) I was … -
Began Watching PDF Studio and dynamic XFA forms. Help for Linux?
I am mostly working in Linux and it is very frustrating that there are few PDF tools on Linux have limited functionality. This is especially true when trying to manipulate … -
Replied To a Post in Query database from two different server using php
There are two problems here: $query = $query1." ".UNION." ".$query2; $resultID = mysql_query($query); First: UNION will be evaluated by PHP as a constant, not as a string part of a … -
Replied To a Post in Sql injection securtiy
A prepared statement consists in a group of SQL commands submitted by the MySQL client: * https://dev.mysql.com/doc/refman/5.6/en/sql-syntax-prepared-statements.html These are supported by both PDO and MYSQLi. When you see the `->` … -
Replied To a Post in Sql injection securtiy
**@phoenix** that's why I was writing about prepared statements, the quote is not supposed to be submitted to the query, unless is escaped correctly, and that's why the security test … -
Gave Reputation to diafol in Insert Multiple Records with PDO Prepared Statement
I've been playing with PDO and got quite a shock, so I thought I'd run this past you all. I love PDO, and I thought that the "prepare once, execute … -
Replied To a Post in Sql injection securtiy
Hi all! **@phoenix** I suppose you have a form with an input field like this: <input type="text" name="ITEM" id="ITEM"> From which you set the `$ITEM` variable, so try to send … -
Replied To a Post in Soap Query Parameter Head Ache ;(
Hi, I would like to help, if you can, send me the link. -
Replied To a Post in http header request does not connect from remote server
> My local system being my cell phone ? No, it should be a computer in your local network, this will use a script to get the information from the … -
Began Watching Code Quality Check
Hello all, I am wondering if someone could comment on the quality of my code. I am working on a project and would like to know whether what I am … -
Replied To a Post in http header request does not connect from remote server
No problem, with patience we can try to fix it. Until the SMS gateway is behind your router the only methods to access it directly are those already suggested in … -
Replied To a Post in http header request does not connect from remote server
Ok, when connecting to your public IP from remote you're connnecting to the router, what you have to do is to redirect the connection from the router to the internal … -
Stopped Watching Error in send messages
hi i have the following error in my sent message file Warning: date_diff() expects at least 2 parameters, 1 given in /home/letsswin/public_html/sent_mail.php on line 146 Show Heres code section for … -
Replied To a Post in http header request does not connect from remote server
It could be the link, the above would work only in the intranet. To connect to an external remote server, you must point the server to use the public IP. … -
Replied To a Post in Apache applicaiton crash
Hi, have you tried the solution offered in their forum? Here's the link: * http://forum.uniformserver.com/index.php?showtopic=2961&hl=%2Bcrash+%2Bevent -
Replied To a Post in Error in send messages
The `date_diff()` function requires two arguments, also both must be resources of the *DateTimeInterface*, if you pass a string, as in your example, the function will fail. So, you must … -
Began Watching Error in send messages
hi i have the following error in my sent message file Warning: date_diff() expects at least 2 parameters, 1 given in /home/letsswin/public_html/sent_mail.php on line 146 Show Heres code section for … -
Replied To a Post in Save record and send email in php
Add `or die(mysql_error());` to the insert query, it seems correct to me, so if it fails is because there could some constraint that is not satisfied, like a `NOT NULL` … -
Began Watching Save record and send email in php
Hi, i have problem to save record and send email in php. After selecting the responsible person, the system supposed to save the responsible person in the database and then … -
Began Watching shared memory in linux
Hi everyone , i have this code and i know that the problem is in the While loop but i cant clearly identify the problem , i know its about … -
Replied To a Post in Save record and send email in php
You're welcome. Let's try to simplify the task: 1. you have a form to select a responsible, populated by user table 2. basing on selection you get an email address … -
Replied To a Post in "open with openjdk" is missing from the menu
Hi! If using Ubuntu then open the terminal and type: locate java.desktop It should find few entries under `/usr/share/app-install/desktop/`, these are the files used to generate the desktop entries. If … -
Replied To a Post in Error in SQL Syntax and I have tried changing the NOT NULL and DEFAULT
Works fine for me: CREATE TABLE `user` ( `userid` char(50) NOT NULL default '', `password` char(12) NOT NULL default '', `lastlogin` timestamp NOT NULL, `newmessage` int(4) unsigned NOT NULL DEFAULT … -
Replied To a Post in Error in SQL Syntax and I have tried changing the NOT NULL and DEFAULT
Ok, here there are two errors on this line: `newmessage`int(4) unsigned NOT NULL DEFAULT `0`, The space between the column name and the type is missing, and the default value … -
Replied To a Post in Change Ruby to PHP
I've registered an account and got your same result, probably their system requires some time (few hours) to enable the API key. If by waiting you don't solve try to … -
Replied To a Post in mysql procedure call with out parameter not working in PHP
Whoops! Sorry, wait a moment. I thought you were using **PDO** when you started your thread, so I've been referring to it: * http://php.net/manual/en/book.pdo.php Your error: > call to undefined … -
Replied To a Post in mysql procedure call with out parameter not working in PHP
Are you setting the connection? For example: $servername = "localhost"; $dbname = "test"; $dbusername = "root"; $dbpassword = ""; $conn = new PDO("mysql:host=$servername;dbname=$dbname", $dbusername, $dbpassword); Otherwise PHP will send a … -
Replied To a Post in redirect page
Hi, in this case you can use `header()`, you could setup actions.php like an hub and define specific redirect links: switch($_GET['action']): { case 'send': # run insert query $redirectTo = … -
Replied To a Post in mysql procedure call with out parameter not working in PHP
The user connecting from the PHP script does have the **Execute** privilege to run procedures? Docs: * https://dev.mysql.com/doc/refman/5.6/en/grant.html * https://dev.mysql.com/doc/refman/5.6/en/privileges-provided.html You can verify this with a try/catch block: <?php $conn->setAttribute(PDO::ATTR_ERRMODE, … -
Replied To a Post in Save record and send email in php
Ok, the only form elements I see here are: <form name="progress" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>"> <input type="hidden" name="Progressid" value="<?php echo $_SESSION['Progressid']; ?>" /> <input type="submit" name="Notify2" value="Notify"/> </form> So … -
Began Watching targeting iFrame in PHP
Hi, all I'm working on a website that is comprised of two iframes within several nested divs ( the frames named "frame-menu" and "frame-main"). Displaying as such: <div id="wrapper"> <div … -
Replied To a Post in Access denied for user
Hi, are you using MySQL on Windows? Is this a new installation? Which version? Could you paste the specific message and code error? -
Replied To a Post in Database for Result website in php
Hi, check the data models in the Education section at: * http://www.databaseanswers.org/data_models/ If it does not help, write about your project, try to define the basic information you would need … -
Replied To a Post in Change Ruby to PHP
Hi, I got the same issues that you have described with both APIs, but standing at the documentation I cannot help: * https://www.scribd.com/developers/platform/api/docs_search * http://api.elsevier.com/documentation/SCIDIRSearchAPI.wadl as it seems that your … -
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 mysql procedure call with out parameter not working in PHP
Try if it works fine from the mysql client, because it returns this error to me: ERROR 1414 (42000): OUT or INOUT argument 2 for routine dbase.test_proc is not a … -
Replied To a Post in Change Ruby to PHP
To define different formats you have to append the parameter `httpAccept` to the link, for example: &httpAccept=application/json &httpAccept=application/xml &httpAccept=application/atom+xml &httpAccept=application/rss+xml Documentation: http://www.nature.com/developers/documentation/api-references/opensearch-api/#apiref So to get the document in XML format … -
Replied To a Post in Save record and send email in php
@Sophia hi, could you show us the **form** used to submit the POST values to your script? -
Stopped 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 = … -
Gave Reputation to coreyavis in Change Ruby to PHP
Use cURL. $token = 'your_nypl_api_token'; $curl = curl_init(); curl_setopt($curl, CURLOPT_RETURNTRANSFER, true); curl_setopt($curl, CURLOPT_URL, 'http://api.repo.nypl.org/api/v1/items?identifier_type=local_bnumber&identifier_val=b########'); curl_setopt($curl, CURLOPT_HTTPHEADER, array( 'Authorization: Token', "Token: $token" )); $resp = curl_exec($curl); curl_close($curl); echo $resp; You can … -
Replied To a Post in mail.php problem
> Erorare reference : This email was looking for a about is sent without authentication It means that the SMTP server used to send the email requires the authentication for … -
Replied To a Post in Bootstrap Test Page
Hi, open the Developer Tools console in Google Chrome, then click on the smartphone icon, it allows to test some device resolutions, here's a screenshot: http://i.imgur.com/cs3ZeA7.png -
Replied To a Post in Change Ruby to PHP
SimpleXML should not replace the underscore with an hyphen, probably the XML generated by the NYPL has already that format. Could you provide the query link? In any case, when … -
Replied To a Post in Change Ruby to PHP
Hi, you don't need `file_get_contents()` in this case, if you get the results in XML format then use `simplexml_load_string()`, like this: $xml = simplexml_load_string($resp); It returns an object, for example: … -
Replied To a Post in Where is quoting here and its usage
Hi, read this: https://www.daniweb.com/community/syntax#quotes The syntax help is accessible by clicking on the `?` icon in the text editor. -
Replied To a Post in No data supplied for parameters in prepared statement
Oh that's correct: if you define four types, then submit four variables. For example, with one variable to submit you would write: $stmt->bind_param('s', $nm); To submit two variables: $stmt->bind_param('ss', $nm, …
The End.