PHP - @mysql_connect General Question

I'm ready for the next step on my site, which is learning how to filter results down with a second search.

The scenario is: A viewer searches for a plant by 4 variables to describe the leaf. After submit, they go to the results page, with 200 paginated results. (This is where I've gotten to)

Now, on that same page, they choose to further narrow their results by searching those 200 results for plants that have purple flowers. Maybe they get 40 results and can use another variable to narrow further - and so on.

What's the best way to set this up? I've been looking into temporary tables, but it seems to be a challenge because the table deletes the moment they leave that page or close the connection? Sessions seem like another possibility, but I read there's security issues.

What's the best way to set this up? Just re-query the database with the entire set of variables from both the first and second searches? is it quicker to build some type of permanent table with a timestamp that I can use to delete it after the user has gone away?

Bear with me, as I'm still quite new at PHP.

I'm trying to figure out the best way to build a search function for a database that will eventually be quite large.

The path of the search I'm building is to go from a straight-forward javascript and html search page, to a paginated search result. Then the user can narrow down those query results based on a new search of their results.

In trying to get the pagination to work across several pages(unsuccessfuly, I might add), I've been learning about sessions and temporary tables. But, because the database will be very large, I'm wondering if they are the wrong way. Sessions have a time limit, and temporary tables delete once the connection is closed.

Is it possible/feasible to build a permanent table that puts in the search variables, with a unique id and use this to manage the searches, pagination and all that? Then, at some point in the process, I can put code to delete the corresponding row (or even make it a saveable search). Maybe somebody sees where I'm going with this and  can describe it better than me? I'm just thinking off the cuff at the moment. Maybe there's some terminology that will help me find a tutorial. Any bit helps.
thanks!

Hi All:
I have general question on php...

 if I have an "includes" folder, and on IE somebody goes directly to it, like:
http://www.site.com/includes
on IE, they can see the folder-tree- directory. So, files like config.php, or mysql.php could be visible.
My question is, is this safe?? couldnt people then just drag-copy the file over into their system? or somehow open it, view its contents?
I dragged-copied a .php file into my desktop, but nothing shows up when I open in in notepad. As opposed to opening another file that was also .php but which only had javascript code in it, and the javascipt did show up.
So, I take it, it should be ok?? as it seems like it works as if the .php page actually had been loaded on a web-browser... doesnt show the php code...

well, appreciate comments, feedback on this...
what woudl be the best way to protect files like this? htaccess-protect? or is this not something to be overly concerned about??
From what I can tell looks like a lot of site are setup this way... so must be ok... ha?

Thanks!

i think this has to do something with me dropping my table and trying to reinstall the blog but now i get


"can't connect to mysql5.000webhost.com"

so then i tried using localhost and i get...

"can't connect to localhost using password YES"

so i assume my password is right and for some reason it isnt connecting yet all the variables match up correct password, database,user i double and triple checked spelling 

mysql_connect("$host", "$username", "$password")or die("cannot connect to server");

i create a connection and let say there is a problem with the server so that the connection can't established

my question is how can i avoid the default error to be displayed which is

WARNING: mysql_connect() blablabla

as it is annoying to see such error message.

thanks in advance

When I try to connect to my database I am getting this error:
Quote

Warning: mysql_connect() [function.mysql-connect]: php_network_getaddresses: getaddrinfo failed: No such host is known. in C:\wamp\www\Envne\envne.com\mysqlAdmin\classes\Database.php on line 9

Warning: mysql_connect() [function.mysql-connect]: [2002] php_network_getaddresses: getaddrinfo failed: No such host is kn (trying to connect via tcp://root:3306) in C:\wamp\www\Envne\envne.com\mysqlAdmin\classes\Database.php on line 9

Warning: mysql_connect() [function.mysql-connect]: php_network_getaddresses: getaddrinfo failed: No such host is known. in C:\wamp\www\Envne\envne.com\mysqlAdmin\classes\Database.php on line 9


Here is the EXACT code on line 9:
mysql_connect('root', '', 'localhost');

I have never gotten this error before... how do I fix it?

I am trying to extend my knowledge from using basic mysql_connect etc. into something better.

I am searching on Google, and looking up as much info as possible but find that I learn best with a brief overview that allows me to channel down my searches.

(1) I know PDO v mysql_connect v mysqli isn;t right - I think PDO is a class, mysql_connect is a command and mysqli is something else. Am I on the right track?

(2) What is the best solution? I am using a full OOP coding style and want to learn the best - I am a novice at this but would consider myself an 8/10 programmer at other parts of PHP.

An very brief overview to get me started and channel my Google searches would be much appreciated.

- I have heard PDO is slower.
- I don't need support for different databases (only MySQL).

Thanks in advance.

Quote

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'nyhungry_builder'@'localhost' (using password: YES) in /home3/nyhungry/public_html/musicmakerstore/storescript/connect_to_mysql.php on line 19
could not connect to mysql



I am getting this error from the code below how come?

Code: [Select]
<! <?php 

// Place db host name. Sometimes "localhost" but 
// sometimes looks like this: >>      ???mysql??.someserver.net
$db_host = "localhost";
// Place the username for the MySQL database here
$db_username = "nyhungry_builder"; 
// Place the password for the MySQL database here
$db_pass = "blablabla"; 
// Place the name for the MySQL database here
$db_name = "nyhungry_musicbeatmaker";

// Run the actual connection here 
mysql_connect("$db_host","$db_username","$db_pass") or die ("could not connect to mysql");
mysql_select_db("$db_name") or die ("no database");             
?>

I am working on a cpanel kind of host and you know how the databases are setup like blablab_databasename etc..


What is going on here i have check the database name, the table, password and the host thousands of times and nothing..

Help

Hi, I currently have an HTML form that posts data (method:POST) to a PHP script. The PHP script then retrieves the data and displays it on screen so the user can do a final check. I then want to have a button, so that when pressed, the data gets sent to a MySQL database.

What I have so far is along these lines:
Code: [Select]
<?php

if(isset($_POST['var1'])) {$var1 = $_POST['var1'];} 
else {$var1 = "";}
if(isset($_POST['var2'])) {$var2 = $_POST['var2'];} 
else {$var2 = "";}

echo  "<b>You have entered the following:</b><p></p>",
          "$var1 <br>","$var2<p></p>",
                "If this is correct, please press continue.";

print        "<html><body><button name=Button1 onclick="">Continue</button></body></html>";

and onclick I want the following to run:
Code: [Select]
$link = mysql_connect  ('localhost', 'root');

if (!$link) {
    die('Could not connect: ' . mysql_error());
}
mysql_select_db ('DB1', $link);
mysql_query ("INSERT INTO table1 (field1, field2) VALUES ('$var1','$var2')");
mysql_close($link);
How can I do this?!
Is it neccesary to use another "submit" button that submits $var1 & $var2 to a different PHP script, which then runs the mysql_connect part? Or can I enclose the mysql_connect part in an IF statement that runs only if Button1 has been pressed (and I enclose the rest of the PHP script in an IF statement that runs only if Button1 has NOT been pressed) and get Button1 to reload the same PHP script?

Either way, how do I define an onclick event inside echo? This prob a noobish question, but I seem to get errors if I try to put (single) quotes "" ' ' inside the quotes of the echo:
echo "               onclick""            ";

Thanks!

Hi,

I get this error when I load the page, but after hitting ctrl f5 to refresh.. the error goes away and the page works perfectly.  I have edited out my details.

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'user'@'localhost' (using password: YES)
Access denied for user 'user'@'localhost' (using password: YES)

I know everything is set right.. I just don't get it.. I am going crazy of this. Ive cleared my browser cache.. even tried it on my android phone and it does the same thing.

Thanks,
Deceevn

I am using a script that gets connected to PHP table and returns the visitors country name from:

Database MyProjectA
Table: ip2country

and inside the script it uses the mysql_connect() function and it works fine BUT the code used in other pages to get data from other tables does not work.

I mean, I have a combo box for example, that populates data from:
Database MyProjectA
Table: mybookings

But it doesn't populate as long as the code for the 'user's country script' is active. The moment I comment out the 'user's country script', the combo box works.

Perhaps I am using 2 database pooling (or connection pooling) so what I did, I closed the previous connection after I get the visitor's country name but still the combo box has no values in it.

Do you get the picture. Please read the question again.

Thank you

I don't know how else to explain this.  I have two php pages in the same domain, same folder, with exact same line to connect to mysql, and one works, and the other doesn't.  I have no clue.  This is the line

$con = mysql_connect("localhost", "myusername", "mypassword");

Hi all

I have been trying to do a query but I get

Call to undefined function mysql_connect()

What other way can I perform a query? Or do I need to get something enabled?

Thank in advance

Dave

httpd-2.2.17-win32-x86-openssl-0.9.8o
php-5.3.6-Win32-VC9-x86
mysql-5.5.11-win32

PHP code:

$dbcnx = mysql_connect('localhost','root','admin');

Error message:

No connection could be made because the target machine actively refused it.

I used mysql.exe -u root -p to verify that mysql is working and using the right username and password.

Any ideas how to fix it?

Thanks,

Richard