Linked Questions
60 questions linked to/from MySQL vs MySQLi when using PHP
28
votes
2
answers
87k
views
Difference between mysql & mysqli [duplicate]
Possible Duplicate:
mysql vs mysqli in php
What is the difference between mysql_* functions and mysqli_* functions? Is there any technical reasons behind we shouldn't use mysql_* functions?
- 980
-5
votes
3
answers
836
views
The mysql extension is deprecated [duplicate]
Aaalright, i really need some help to this, because im really confused. Im trying to connect to a database on phpmyadmin.
<?php
mysql_connect('localhost', 'root', '');
mysql_select_db('...
- 147
15
votes
5
answers
25k
views
When should I use MySQLi instead of MySQL?
Can someone clarify for me what the advantages and disadvantages of using MySQLi instead of MySQL? Are there situations where I should not use MySQLi? Do I need to configure my server differently in ...
- 4,036
5
votes
5
answers
35k
views
Difference between mysqli and mysql? [duplicate]
Possible Duplicate:
Advantages Of MySQLi over MySQL
I am building a large database and wondered which is the best to use?
I am sanitizing my values now and escaping characters for security but I ...
- 1,866
4
votes
5
answers
15k
views
MYSQL: Insert column if not exists
I am trying to add a column by checking if it exists. If not it should give message that it already exists with the code below.
$prefix = 'vm_';
$col_name = 'checking';
$col = "SELECT ".$col_name." ...
- 8,408
4
votes
3
answers
7k
views
MySQL vs MySQLi in PHP [duplicate]
What are the differences/advantages of each? Disadvantages?
I'm not looking for coding preferences or subjective answers.
What are practical diferences? (Storage, implementation, how the code looks, ...
- 58.2k
8
votes
3
answers
1k
views
Switching on mysqli over mysql
I have mysql installed and now I want to work on mysqli with new database.
Does it affect my previous database which is in mysql if I enable mysqli in phpmyadmin?
- 109
1
vote
3
answers
6k
views
making php web application secure
to protect my project from attacks (example: SQL injection) im using the below for query
parameter pages(*.php?query=value) :
$id=strip_tags($id);
$id=mysql_real_escape_string($id);
if(is_numeric(...
- 491
6
votes
4
answers
3k
views
In PHP, how do I make a mySQL select query that contains both quotation marks and apostrophes?
I'm getting data into my database without any problem using mysql_real_escape_string.
So an entry in the database might be:
1/4" Steve's lugnuts
So that's perfectly in the database.
Now I want to ...
- 267
1
vote
6
answers
10k
views
call to undefined function php mysql
I am new to coding and keep getting this error and I am not sure what the reason is... I am trying to search/retrieve data from a Mysql database... Idea is that someone selects a category of search (...
- 165
-4
votes
5
answers
25k
views
Connection refused "mysqli_connect(): (HY000/2002): Connection refused in **************************conn.php on line 6 Failed
Hey guys I have problem with connecting my .php file to database, I've tried different ways but still the same response.
Here is my code (updated):
<?php
$server_name = "localhost";
$...
- 518
0
votes
3
answers
10k
views
PHP Server Side Validation
Using various tutorials namely here and here I've managed to put together the following PHP script which performs server side validation on the form being submitted. (I already have script which is ...
- 1,316
0
votes
4
answers
683
views
PHP / MYSQL - Can't get ID for each entry
I am at scripting a customer database. When I wanted to implement the "manage customers" site where you can edit, delete and view details of each entry, I encountered a strange problem. Everything ...
- 117
-1
votes
1
answer
6k
views
Enabling mysql support in PHP
I am trying to add MySql support in PHP. I am using PHP version 7.2.11. When i'm trying to run my application, it shows the following error:
Your PHP installation does not have MySQL support. Please ...
0
votes
2
answers
5k
views
Fatal Error: Uncaught error Call to undefined function mysql_real_escape_string() HTML/PHPMYADMIN
I am currently stocked :( basically I am doing a login page There is no problem with the login page but once i submit it... this is my code for my login page.
<form action= "process.php" method="...
- 23