Update: If you get an error that says 'call to undefined function mysql_connect()', it means that this function was already removed in newer versions. Use mysql_connect() or PDO functions instead. See official documentation on php dot net. Also, if you're a mac user, you might have problems accessing htdocs repository. In XAMPP application go to 'Volumes' tab and press 'Mount'. A new directory will open under Locations in you Finder. Press there, go to lampp folder and you will find htdocs there. Good luck!
Warning: mysqli_select_db() expects exactly 2 parameters, 1 given in C:\xampp\htdocs\manex.php on line 8 Connected Why it's like this bro? Thank you in advance
Tutorial is good. Thanks for making. But i would request you to increase video quality as we are having little bit problem to see some PHP scripts. and it seems you have not shared annoted doc as you mentioned in the video.
Looked everywhere for a simple solution, this worked the first try. Thank you so much!!! Quick question, if i wanted to create a mySQL table and insert data using a php page I made instead of making one through phpMyAdmin and adding data would that work?
After using mysqli I get error like "The server requested authentication method unknown to the client [caching_sha2_password]. Please help me with this @solutioncone
excellent tutorials....moreover in hindi its much understandable..ty for this.....I have one query ...I am making a web page for students to see solution of questions. I have takes all questions and answers in png form seperately. Now i want them to fill a scrollable form with option to get there desired question and answer. For ex, they will choose fst class, then subject, then chapter, then exercise, and then question. then after clicking submit button both pics must be displayed in a panel. Please tell me how to do this.
Rishta kya kehlata hai soundtrack in the background proves that in all Indian households, the remote belongs to the women, hence men are confined to connect MySQL and PHP :P
Fatal error: Uncaught Error: Call to undefined function mysql_connect() in C:\xampp\htdocs\d.php:3 Stack trace: #0 {main} thrown in C:\xampp\htdocs\d.php on line 3
I selected xampp control from my local disk and clicked on php and apache after doing that when i try to browse localhost it's not showing localhost/xampp
Fatal error: Uncaught Error: Call to undefined function mysql_connect() in E:\xamp\htdocs\php\practise.php:6 Stack trace: #0 {main} thrown in E:\xamp\htdocs\php\practise.php on line 6 plzzzzzzzzzz help me why its error is arise
Hi, I seem to have the same problem. The sqli works for me when connecting, but not the sql. Why is that? Is there something else I can do to get the sql_connect to work instead?
This is the error I am getting: Warning: mysqli_select_db() expects exactly 2 parameters, 1 given in C:\xampp\htdocs\connect.php on line 12 Connected What is the other parameter I need?
i have downloaded xamp and localhost home page is not opening . i dont know what to do next?? i already have a prototype designed on which i will work. please guide soon
MR PLEASE IF YOU CAN HAVE TIME. I NEED THIS TUTORIAL ON MAC BECOUSE IAM USING THE MAC SO HOW TO BYPASS ON MAC.I KNOW YOU CAN DO IT TRUST YOU SO PLEASE IF YOU CAN MANAGE JUST CREATOR ONE VIDEO FOR ME.I LIKE YOUR VIDEO VERY MUCH
After using mysqli I get error like "The server requested authentication method unknown to the client [caching_sha2_password]. Please help me with this
Fatal error: Uncaught Error: Function name must be a string in C:\Users\Daniel\Desktop\XAMPP\htdocs\connection.php:2 Stack trace: #0 C:\Users\Daniel\Desktop\XAMPP\htdocs\login.php(2): include() #1 {main} thrown in C:\Users\Daniel\Desktop\XAMPP\htdocs\connection.php on line 2
Followed the same instructions as shown in video, Yet after trying to run on localhost, the connect.php file i got this error: Warning: mysql_connect(): Access denied for user 'username'@'localhost' (using password: YES) in C:\xampp\htdocs\core\database\connect.php on line 7 connected to db where if success, i echoed connected to db. it is showing both the lines. what does this mean ?? Also i have localhost and username as root and password as blank. My connect.php file is as below: Please help for the above
Fatal error: Uncaught Error: Call to undefined function mysql_connect() in C:\xampp\htdocs\database.php:8 Stack trace: #0 {main} thrown in C:\xampp\htdocs\database.php on line 8
I followed your instruction but i couldn't get this to connect. What i did was change the code to this $connected = mysql_connect("localhost", "root"); and then it worked.
atal error: Uncaught Error: Call to undefined function mysql_connect() in C:\xampp\htdocs\php\connect.php:6 Stack trace: #0 {main} thrown in C:\xampp\htdocs\php\connect.php on line 6 Why ? :(
Thank you soooo much . May you help me? I got this error : Warning: mysqli_select_db() expects exactly 2 parameters, 1 given in C:\xampp\htdocs\youtube\database\connect1.php on line 11 Connected successfully This is my code :
Warning: mysql_connect(): Access denied for user 'root'@'localhost' (using password: YES) in C:\xampp\htdocs\form\insert.php on line 2 Could not connect: Access denied for user 'root'@'localhost' (using password: YES)
Fatal error: Uncaught Error: Call to undefined function mysql_real_escape_string() in C:\xampp\htdocs\login\process.php:9 Stack trace: #0 {main} thrown in C:\xampp\htdocs\login\process.php on line 9
Update: If you get an error that says 'call to undefined function mysql_connect()', it means that this function was already removed in newer versions. Use mysql_connect() or PDO functions instead. See official documentation on php dot net.
Also, if you're a mac user, you might have problems accessing htdocs repository. In XAMPP application go to 'Volumes' tab and press 'Mount'. A new directory will open under Locations in you Finder. Press there, go to lampp folder and you will find htdocs there. Good luck!
You can use mysqli_connect() instead
thanks bro it helps a lot and anyone who is facing regarding the error "Call to undefined function mysql_connect()" try using this
Warning: mysqli_select_db() expects exactly 2 parameters, 1 given in C:\xampp\htdocs\manex.php on line 8
Connected
Why it's like this bro? Thank you in advance
Tutorial is good. Thanks for making.
But i would request you to increase video quality as we are having little bit problem to see some PHP scripts.
and it seems you have not shared annoted doc as you mentioned in the video.
Sure.. Will upload entire new video series for Core Php. Bootstrap, and many more
Excellent tutorials, question Can I do this with my website, accessing a remote local ms-sql-server database?
Good job bro! Really clear instructions, best video out there for connecting to database using xampp!
+Khalil Najjar
Thanks and welcome :)
Looked everywhere for a simple solution, this worked the first try. Thank you so much!!!
Quick question, if i wanted to create a mySQL table and insert data using a php page I made instead of making one through phpMyAdmin and adding data would that work?
+Daniel Gallardo yes definitely it will work
Fatal error: Call to undefined function mysql_connect() in C:\xampp\htdocs\test3\conn.php on line 7 i need help for this !
+Argjend Bytyqi
Start using mysqli functions for MySql uses
After using mysqli I get error like
"The server requested authentication method unknown to the client [caching_sha2_password]. Please help me with this @solutioncone
@@prajwalshetty9968 same error bro u get solutions of this error
Thank you, but could you update the PHP script to the new format using mysqli_ , instead of mysql ?
Yes.
I will update it
excellent tutorials....moreover in hindi its much understandable..ty for this.....I have one query ...I am making a web page for students to see solution of questions. I have takes all questions and answers in png form seperately. Now i want them to fill a scrollable form with option to get there desired question and answer. For ex, they will choose fst class, then subject, then chapter, then exercise, and then question. then after clicking submit button both pics must be displayed in a panel. Please tell me how to do this.
Thank you, From Philippines
You are most welcome to Solutioncone...
🇮🇳 🤝 🇵🇭
Rishta kya kehlata hai soundtrack in the background proves that in all Indian households, the remote belongs to the women, hence men are confined to connect MySQL and PHP :P
LOL 😆
Why do you need quotes around $username when you use it as a parameter for mysql_connect, but not when you use $db as a parameter for mysql_select_db?
See in PHP
Output :
$a 1 1
Means if you include double quotes then its same as not including a quote. You can use any one of the conventions..
Fatal error: Uncaught Error: Call to undefined function mysql_connect() in C:\xampp\htdocs\d.php:3 Stack trace: #0 {main} thrown in C:\xampp\htdocs\d.php on line 3
same here . Were you able to figure it out
Thanks, however it didn't connect until I changed mysql to mysqli . The "i" is important.
Welcome
Good job buddy I support you
+Harsath Bill Gates thank u
thank you, simple and useful and helpful!
Welcome.. Mny More to come
Good one for a beginner
Welcome...
Parse error: syntax error, unexpected '$pass' (T_VARIABLE) in C:\xampp\htdocs\galactica\connect.php on line 5
why shows this error
+Quick Media Solution
can you show entire code of the connect.php file, so that we can help you
I selected xampp control from my local disk and clicked on php and apache after doing that when i try to browse localhost it's not showing localhost/xampp
hi can you pls explain where you put mysql file and where you put php file?
OH Thank you Soo much💖🤭🤭🥳🤭🙋✌️✋
Welcome to Solutioncone
Fatal error: Uncaught Error: Call to undefined function mysql_connect() in E:\xamp\htdocs\php\practise.php:6 Stack trace: #0 {main} thrown in E:\xamp\htdocs\php\practise.php on line 6
plzzzzzzzzzz help me why its error is arise
Can you show me the script ?
Or try
$conn = mysqli_connect("localhost","root","","database_name") or die("Error in Connection");
+Preeti Thakur ? Is your problem resolved ?
use mysqli_connect(...);
preeti without using mysql_connection use mysqli_connection()
Hi, I seem to have the same problem. The sqli works for me when connecting, but not the sql. Why is that? Is there something else I can do to get the sql_connect to work instead?
Hello bruther , i am a new member of your centeen . I want to learn how to create a MySQL Database using XAMPP.
+Md. Arafat Hossain okk I will make a series on it.. That will help you
I am using ubuntu 16.04.
My XAMPP folder is located in opt directory,in which directory do I need to save the php file .
I think in
mnt -> www
/opt/lampp/htdocs
xampp will look for your files in htdocs dir, put your files in htdocs, and then you can browse localhost/yourfilename.php
Thank You !! u are too helpful
Welcome...
it is an old version of xammp. But it may be useful. Thanks
Thank you for this clearful tutorial
Most Welcome
This is the error I am getting:
Warning: mysqli_select_db() expects exactly 2 parameters, 1 given in C:\xampp\htdocs\connect.php on line 12
Connected
What is the other parameter I need?
My Code:
+Jeremy Tom remove mysqli_select_db
i have downloaded xamp and localhost home page is not opening . i dont know what to do next?? i already have a prototype designed on which i will work. please guide soon
Appreciated a lot bruhh
Welcome ... Enjoy the full series
Why didn't you put a double quote on $db? and why does it still works?
+Pixelite just to slow that.. "$var" Is valid one.. And '$var' is not..
So you can use.. "$var" or $var but not '$var'
may I known what to do if not showing the add new account in uer account
Which account ?
MR PLEASE IF YOU CAN HAVE TIME. I NEED THIS TUTORIAL ON MAC BECOUSE IAM
USING THE MAC SO HOW TO BYPASS ON MAC.I KNOW YOU CAN DO IT TRUST YOU SO
PLEASE IF YOU CAN MANAGE JUST CREATOR ONE VIDEO FOR ME.I LIKE YOUR VIDEO
VERY MUCH
I don't have Mac!
After using mysqli I get error like
"The server requested authentication method unknown to the client [caching_sha2_password]. Please help me with this
hi i having a problem in first, I typed localhost and i dont see like yours..
Help me please.. Thank you in advance..
Can you tell me which port is configured as your localhost?
my ports for mySQL is 3306 while the Apache port is 88,443 I don't have any idea of this port so far...
I really love this video :)
Fatal error: Uncaught Error: Function name must be a string in C:\Users\Daniel\Desktop\XAMPP\htdocs\connection.php:2 Stack trace: #0 C:\Users\Daniel\Desktop\XAMPP\htdocs\login.php(2): include() #1 {main} thrown in C:\Users\Daniel\Desktop\XAMPP\htdocs\connection.php on line 2
If I want to use a seperate sql database how would I do that?
mssql_connect($host, $username, $pass, $db)
Refer :
php.net/manual/en/function.mssql-connect.php
Thank you bro !!
Welcome
Followed the same instructions as shown in video,
Yet after trying to run on localhost, the connect.php file i got this error:
Warning: mysql_connect(): Access denied for user 'username'@'localhost' (using password: YES) in C:\xampp\htdocs\core\database\connect.php on line 7
connected to db
where if success, i echoed connected to db.
it is showing both the lines. what does this mean ??
Also i have localhost and username as root and password as blank.
My connect.php file is as below:
Please help for the above
May be your password will not be empty, make it root and try again...
thanks
good job man
Welcome..
Can we create database without phpMyAdmin.
I mean is there any other alternative other than phpMyAdmin
Fatal error: Uncaught Error: Call to undefined function mysql_connect() in C:\xampp\htdocs\database.php:8 Stack trace: #0 {main} thrown in C:\xampp\htdocs\database.php on line 8
i am getting an error saying that object not found.. can someone help me out
still getting error..................Object not fount help me to figure out it
This means there is some issue with linking the page.
Please rectify
Thank you!!
Welcome
Fatal error: Uncaught ArgumentCountError: mysqli_select_db() expects exactly 2 arguments, 1 given in C:\xampp\htdocs\php\connect.php:10 Stack trace: #0 C:\xampp\htdocs\php\connect.php(10): mysqli_select_db('solutioncone') #1 {main} thrown in C:\xampp\htdocs\php\connect.php on line 10
nice
Thanks
Where can I access dbhost & username and look up the password though? Would be great to know
I followed your instruction but i couldn't get this to connect. What i did was change the code to this
$connected = mysql_connect("localhost", "root");
and then it worked.
Ok Cool.. At the end you sorted your problem thats great...
thanks man..
+Ravi sharma welcome
Thank you
Welcome
Admin please tell me how to fix caching_sha2_password in php error
Bro it is not visible to learn proper cotes its double cote or single cot
you can make a habbit
Not to write variables in quotes..
thanks alot.
Welcome
atal error: Uncaught Error: Call to undefined function mysql_connect() in C:\xampp\htdocs\php\connect.php:6 Stack trace: #0 {main} thrown in C:\xampp\htdocs\php\connect.php on line 6
Why ? :(
try mysqli_connect
Thank you .
India❤
any help pliz,how do i create a database for my website
Go to PhpMyAdmin and create a database
I tried this but It didnt get connected. (localhost/php/connect.php) This is not getting connected. Please help.
What error do you see?
Solution Cone - it's not getting connected..I tried the same which is shown in the video. Please show me other solution for getting g it connected.
love you buddy :D
+Hemant Bisht enjoy bro
Thank you soooo much . May you help me? I got this error :
Warning: mysqli_select_db() expects exactly 2 parameters, 1 given in C:\xampp\htdocs\youtube\database\connect1.php on line 11
Connected successfully
This is my code :
Thank you .
Why will it display "connected" but shows errors?
but shows warnings*
What warning ?
Quality of video in not up to mark
Sorry about that
plz give me the solution
where is connect.php fil?
+Gulfam Haider go trough the video
already i have seen this video
by this video you use connect.php file
where is connect.php file saved?
Can you help me trough skype?
+- DarkS997™ -
sure..
What is your skype?
#Akashdewangan
Nice video good job...👍
Syntax error😔😔
Please check properly or follow the video again
Warning: mysql_connect(): Access denied for user 'root'@'localhost' (using password: YES) in C:\xampp\htdocs\form\insert.php on line 2
Could not connect: Access denied for user 'root'@'localhost' (using password: YES)
need help on skype
+whitemamba00
What the issue ?
Mail us : contact@solutioncone.com
+Solution Cone sent it.
To much adds!!
Can I have a bit of help as well please on Skype.
+HorizonGBRS
Sure, msg your skype id
Jack Davie it's a pic of a blue car.
localhost is not running
mysqli_real_connect(): Server sent charset (255) unknown to the client. Please, report to the developers
Fatal error: Uncaught Error: Call to undefined function mysql_real_escape_string() in C:\xampp\htdocs\login\process.php:9 Stack trace: #0 {main} thrown in C:\xampp\htdocs\login\process.php on line 9