7

Not able to link mysql database with php

view full story
linux-howto

http://stackoverflow.com – I am using mysql version Server version: 5.0.77 and php version PHP 5.1.6 (cli) (built: Nov 29 2010 16:47:37) My code is below: <?php $username="root"; $password=""; $hostname="localhost"; $dbhandle = mysql_connect($hostname, $username, $password) or die("Unable to connect to MySQL"); echo "Connected to MySQL<br>"; $selected = mysql_select_db("examples",$dbhandle) or die("Could not select examples"); //execute the SQL query and return records $result = mysql_query("SELECT id, model,year FROM cars"); //fetch tha data from the database while ($row = mysql_fetch_array($result)) { (HowTos)

linuxletgo's picture
Submitted by linuxletgo on 01/18/2013 – Made popular on 01/18/2013

Stories similar to Not able to link mysql database with php

I have limited knowledge of PHP. I would really appreciate your help.

I want to edit/change the value of a specific column value with PHP. For example, let's say that I have thousands of records and I want to change every record's column value to 1. How would I do this in PHP?

storing into an array 3 years 10 weeks ago

can anyone offer some help here i have a string that contains course codes. i separate the string into the individual course codes using the explode function. however i want to run a query on each of the course codes that was present in the string and store the result in an array that i have created this is the code that i have thus far

<?php

implode function issues 3 years 10 weeks ago

i have a multiple select drop down menu and i want to implode all the selections that were chosen. can any one offer some assistance on how to do this please. this is what i have so far

<?php

function form()  { $hostname = "localhost"; $username = "root"; $password = "hayden";

I have configured my MySQL Database to require passwords on all users, even root from the machine itself.

Now I discovered that there are empty Users in my Database

Reproduce: mysql -u root -p and then use mysql; & select * from user;

it gives me 2 entries, one with "localhost" and user and one with the machine's hostname and .

now i tried to access the account with mysql -u ' ' (yes it's

in Mysql-Workbench,i clicked on open connection to start querying and i get a dialog where i get the hostname,username,password,etc... in hostname it has 127.0.0.1, user set as root, and i've enter the root password for mysql and i get this:

Cannot Connect to Database Server Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Lost connection to MySQL serve

I'm trying to create a MySQL user which will only be allowed to connect to the MySQL database from a specific hostname.

grant all on db_name.* to 'user_name'@'appserver-lan.mydomain.com' identified by 'some_passwd'

By checking the user table on the mysql db, I can see that the user was created successfully:

use mysql; select * from user where User='user_name' and Host='appse

Sql issue in shell scripting 22 weeks 4 days ago

HI friends , i am also facing an issue in mysql

i ma trying to insert detail in a variable but not got success

Code: #!/bin/sh mysql -u<username> -p<password> <dbname> << EOF DEV=`mysql --skip-column-names <dbname> -e "SELECT timestamp from process_record where id = 1"` EOF echo $DEV ERROR 1064 (42000) at line 1: You have an error in your SQL

HI I am sending a username to my php file located on the server to check if the username exists in my database.