Thank you... Actually I tried running the same script locally (by the way, I am running all this on a dedicated Unix machine and not a web server as such) and the same problem repeated. I mean, its doing everything with the same degree of slowness...
What I'm trying to do is an adjacent row comparison and if they are different, I'm copying them onto a different table. The code goes something like this:
As you can observe, there are many queries and this is the only way I thought would work... Do you think because I'm trying to say "SELECT * FROM trace WHERE ID=" so many times and that the trace databases is big (around 200 MB) this problem is occuring? But I've actually indexed ID and ip fields...
I want to design a database, using mysql as a backend, and PHP as the frontend, I wanna be able to easily build forms in PHP to communicate with MySQL, is there any programs that will allow this, I really dont want to program all the forms by hand..
thankyou (2 Replies)
Okay, I'm new to this PHP and MySQL stuff, so help would be VERY much appreciated. :)
On my iMac runnning Panther, it has MySQL and PHP installed.
Yet when I view a PHP file from the iMac or another computer at my house, I get the source code.
What's wrong? (11 Replies)
Hi All,
I have a problem with my database having lots of 'stale' slow_queries. I think the problem may be because of the following code:
$numresults=mysql_query("select * from links where catagory=".$catagory." order by linknum");
$numrows=mysql_num_rows($numresults);
I believe this... (4 Replies)
Hello every one
i have question i want to build DATAbase using PHP as interface
i use shell to access to linux . i have in linux psql and SQLplus
i'll call all html files that has db tabels from shell directory.
what should to do before design php pages. can build the database sql design... (3 Replies)
Hi,
The php is not able to connect into my mysql database. But i can able to connect by manually.
I think that I have missed some points.
Please guild for the same.
Thanks,
Mani (1 Reply)
Hi,
I have two websites:
website1.com and website2.com
I didn't write either but have successfully moved all the files from website1.com to website2.com
I (thought) I installed all the correct php modules and website2 is mostly up and running. However, my boss found that when we go to a... (15 Replies)
Hello,
While I was interpretation the PHP manual on database security the recent past, it said that you should by no means connect to the database as the super user but rather as one more user with more limited options.
My question is:
How do you generate new users and set access... (2 Replies)
Hi,
I'm on a Raspberry Pi with Raspbian Wheezy.
I urgently need to get MySQL running with PHP, but I get an error.
For example:
$con=mysql_connect("127.0.0.1","root","******","ids");
gives
PHP Fatal error: Call to undefined function mysql_connect()
So, I found I needed to install some... (2 Replies)
Discussion started by: FreddoT
2 Replies
LEARN ABOUT PHP
mysql_get_proto_info
MYSQL_GET_PROTO_INFO(3) 1 MYSQL_GET_PROTO_INFO(3)mysql_get_proto_info - Get MySQL protocol infoSYNOPSIS
Warning
This extension is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQL extension should
be used. See also MySQL: choosing an API guide and related FAQ for more information. Alternatives to this function include:
omysqli_get_proto_info(3)
int mysql_get_proto_info ([resource $link_identifier = NULL])
DESCRIPTION
Retrieves the MySQL protocol.
o $
link_identifier -The MySQL connection. If the link identifier is not specified, the last link opened by mysql_connect(3) is
assumed. If no such link is found, it will try to create one as if mysql_connect(3) was called with no arguments. If no connection
is found or established, an E_WARNING level error is generated.
Returns the MySQL protocol on success or FALSE on failure.
Example #1
mysql_get_proto_info(3) example
<?php
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
printf("MySQL protocol version: %s
", mysql_get_proto_info());
?>
The above example will output something similar to:
MySQL protocol version: 10
mysql_get_client_info(3), mysql_get_host_info(3), mysql_get_server_info(3).
PHP Documentation Group MYSQL_GET_PROTO_INFO(3)