jbitkill
Nov 1 2007, 12:20 AM
| | Hi!, what is MySQL with MySQLi because i am hosting phpbb3 site and i got a database types of
MySQL
MySQL with MySQLi
PrestigeSQL
I have choosed MySQL now but i am willing to reinstall.
xxxx-jozh-xxxx
|
Reply
TavoxPeru
Nov 1 2007, 04:25 AM
QUOTE(jbitkill @ Oct 31 2007, 07:20 PM)  Hi!, what is MySQL with MySQLi because i am hosting phpbb3 site and i got a database types of
MySQL
MySQL with MySQLi
PrestigeSQL
I have choosed MySQL now but i am willing to reinstall.
xxxx-jozh-xxxx I guess that to access your databases phpbb3 uses for your MySql databases prior to ver 4.1.0 the MySql extension and for your MySql databases from ver. 4.1 -exactly with ver. 4.1.3- and above the MySqli php extension. This last one is an improved extension that allows to access all of the functionality provided by MySQL 4.1 and above. Also with this extension you can develop your php code to work with your databases in a procedural or an object oriented style. For more information visit the following pages at the php website: Regarding the PrestigeSQL, well only to say that it is the first time i hear about it. Best regards,
Reply
Chesso
Nov 2 2007, 11:05 PM
Maybe the OP means Postgre SQL or what ever it is in the cPanel. I can't even remember the exact name but it is something like that (I think it has some elephant/mammoth icon or some such).
Reply
TavoxPeru
Nov 3 2007, 01:14 AM
QUOTE(Chesso @ Nov 2 2007, 06:05 PM) Maybe the OP means Postgre SQL or what ever it is in the cPanel.
I can't even remember the exact name but it is something like that (I think it has some elephant/mammoth icon or some such). If it's icon is an elephant/mammoth as you say, well, in this case you are correct it is refering to a PostgreSQL database, if not, as i say in my previous post, i don't know anything about it. Best regards,
Reply
yordan
Nov 24 2007, 02:53 PM
QUOTE(jbitkill @ Nov 1 2007, 01:20 AM) Hi!, what is MySQL with MySQLi because i am hosting phpbb3 site and i got a database types of
MySQL
MySQL with MySQLi
PrestigeSQL
I have choosed MySQL now but i am willing to reinstall.
xxxx-jozh-xxxx MySQL is a good choice. Simply, the menu you have seen states that PHPBB3 has detected three possible database systems effectively installed on your host. However, remember that you have to create a database and a database user before starting up your installation. For instance, if you choose to create a PostgreSQL database, you choose postre in the database type. Because you seem more familiar with standard MySQL, simply choose MySQL the next time you install your database. And, of course, perform a backup before destroying your current forum ; so, if you happen to change your mind, you will be able to restore your data and bring your old forum up again. Regards Yordan
Reply
vujsa
Nov 25 2007, 02:22 AM
Your phpBB3 installation want to know what PHP functions to use for your installation. This is puzzling since most systems that can use a variety of SQL functions have the ability to choose the correct set automatically! For example, Joomla checks the version of PHP installed and if the mysqli functions are included, then that is what it uses since those are the better choice. If you have a server with PHP 5, then by default, the mysql functions are not supported and only the mysqli functions will work. Most hosts turn the mysql functions on to avoid problems with older script installations that are only able to use the older functions. The only reason that the installer asks is because different versions of SQL software use different PHP functions and it needs to know which functions to use. For AstaHost, you can use mysql and mysqli for any MySQL database you setup! Again, the program really should just check and use the proper functions automatically but then again, when did phpBB do what makes sense. To explain, Postgre SQL, is just the name of the SQL software you could use like MySQL or MS-SQL. That's right Microsoft has their on SQL version as well... The MS-SQL version isn't as popular as the other two mostly because Windows servers aren't quite as popular. MySQL is most popular since is is most easily supported by PHP. Since PHP is such a popular choice for web development, MySQL benefits from that relationship. vujsa
Reply
yordan
Nov 27 2007, 06:09 PM
Personnally, I like the way PHPBB3's installer works. It looks what is available, and then suggests you what it thinks is better, but lets you choose something different. This allows me to use phpbb3 with an Oracle database, just for fun.
Reply
Recent Queries:--
joomla mysql mysqli - 26.52 hr back. (1)
-
install mysqli on cpanel - 27.34 hr back. (1)
-
mysqli on cpanel - 28.34 hr back. (1)
-
mysqli - 30.94 hr back. (1)
-
mysqli explained - 37.31 hr back. (1)
-
prestigesql - 12.11 hr back. (2)
-
php how to connect with mysqli - 107.24 hr back. (1)
-
php connect to mysql with mysqli - 107.28 hr back. (1)
-
access mysql with mysqli - 109.57 hr back. (1)
-
phpbb3 mysql mysqli - 125.29 hr back. (1)
-
free host with mysqli - 127.77 hr back. (1)
-
how do i know if mysqli is installed - 132.86 hr back. (1)
-
mysqli extension phpbb3 - 141.93 hr back. (1)
-
what is mysqli - 2.89 hr back. (7)
Similar Topics
Keywords : mysql, mysqli
- Login System
I want to make a login system using Mysql. I am amateur in these thing (6)
Mysql Overhead
(3) Sometimes in a table especially if i do alot of things in it i start seeing overhead then a size
near it? what is overhead? and is it essential to optimize the table to fix it? I know its just a
press of a button but i'd like to know what happens when i optimize a table. Also when you make
a new table you can limit the size of VARCHAR to a number, that number would be the number
characters allowed in that column per entry. I'd like to know how the limit works for texts, is
it in KB? or number of characters? Cuz i made a messaging system. And i remember reading s....
Mysql Multiple Tables
(1) It is good practice to use multiple tables to sort out big amounts of data. But once you do that it
becomes increasingly hard to cross reference the tables. Mysql has a little beautiful command
structure that they have added. You can select multiple tables within one sql query. Example of a
basic sql query CODE $sql = "SELECT * FROM table WHERE row=1"; If you noticed that I selected
all of the rows in the table. Normally you will try to not select the entire table from the database
unless you absolutely want all of the table. I would recommend against it; just gra....
Any Website Provide Free Host Mysql Host?
(4) any website provide free host mysql host? i need it because i am using 000webhost.com now but it
only provide 2 mysql database... can i know where or how can i get more databases regards....
Mysql On Computer
XD (9) I posted PHP on computer? , but for some reason it doesn't show :/. Anyways I am wondering if
there is MYSQL on my computer, meaning can i make a data base on my computer? that way i make what i
want and upload it when i get hosted =)....
Mysql Database Entry By Excel Sheets
(2) Hello .. I would like to ask if i can use use Microsoft excel files in order to make entries to
mysql database. Thanks....
Mysql Database Management
(1) Hi i am new, I have a problem in understanding the query decomposition in D-DB. Can anyone help me
to understand the first question of the exercise 25.21 of Elmasri-Navath 4th edition? Consider the
following relations: BOOKS (Book#, Primary_author, Topic, Total_stock, $price) BOOKSTORE (Store#,
City, State, Zip, Inventory_value) STOCK (Store#, Book#, Qty) Consider a distributed database for a
bookstore chain called National Books with 3 sites called EAST, MIDDLE, and WEST. Consider that
BOOKS are fragmented by $price amounts into: B1:BOOK1:up to $20. B2:BOOK2:from ....
Mysql And User File_priv
(0) HI, I've hit the grain while trying to import file to mysql database - I need to enable file
permissions of the database user but this seems not possible with most of the hosting providers.
The problem is to set file_priv of the database user to "Y" . This is done in the "user" table of
the maintanance database named "mysql". cPanel doesn't allow this. Via the cPanel you can only
allow privileges on table querries but you cannot grant host file privileges to the database user -
which makes querries like: "LOAD DATA INFILE 'filename' INTO TABLE tablen....
I Have An Error With My Mysql Connection
mysql connection error (7) ok so here's my web page... http://lacrossems.t35.org/ it only lags cause its trying to
connect to the my sql server...i followed this guide
http://forum.ragezone.com/showthread.php?t=387249 and when i edit my config.php to my host and
login info i always get the error cannot connect to the database here is my config.php if you can
help me CODE $host = 'CENSORED'; // my host $host =
'righto'; // my database username $host = 'CENSORED'; // my database
password $host = 'odinms'; // my datab....
Mysql Backup With Another Address?
(4) I just got my site hacked!! (don't worry because it is not on astahost) Actually it is a
wordpress blog. So I backed up my MySQL Databases with cpanel. Now when I get my hosting approved
here at astahost, can I restore those backups? Is the change of the site address going to interfere
with this? Is there anyway I can edit those databases to work with my new address? Please help me
out here!....
Sun Bought Mysql
(6) SUN bought the swedish company MYSQL for much money, around 2million each worker got in the company,
they did it to come in to the database market, is it a good reson to buy it?....
Mysql Problem
Linking tables (1) Hello guys, I'm making a PHP/MySQL site for a friend of mine who plays an online game where you
can create towns, add buildings to them and upgrade them to a newer level. I've offered to make
him a small site where he can input his data into a database and keep track of his towns, buildings
and levels. I'll show you my database design and then explain what i want to do. Table: towns
field 1: TownID (primary key, auto-increment) field 2: TownName field 3: TownType field 4: Town
Description Table: buildings field 1: BuildingID (primary key, auto-incremen....
Mysql - So Hard
Come in here if you think MySQL is soo hard! (14) Doesn't anybody think MySQL is so hard to code? I mean think about it, you need loads of
databases just for one little script and you have to type things in like ;Host-Username:
(blahblah) ;Host-Password: (blahblah) ;Host-DatabaseName: (blahblah) Ok, that MySQL code was
random, and it is alot harder than that. If you have expierenced it being hard, you are free to
post right in here, mate.....
Mysql Script Help
help me lol, (3) ok im a real noob to this myswql stuff i know what its for but can any1 write me a script for it for
user sigh up and like a myspace type of profile with a forms peferbly Wii FC code Games. Also can
some1 explain how to add the forms if it doset bother u guys too much TY....
Not Understanding Mysql
(4) Im not understanding MySql stuff can someone help me when u got to the MySql site and all that other
stuff is this like a log of your web stuff or does it help u desigen your website just wanted to
know what it does and how do u use this thing.....
Apache Php With Mysql On Windows [solved]
(9) I have problems running PHP MySQL function in a windows set web environment. PhP scripts are
executed but if I try to use mysql connect and other like functions I get a blank window (while
using the browser). The command line client is working...I've added the path to libmysql.dll
and the extension=php_mysql.dll in the php.ini.....
Subqueries In Mysql
Using subqueries in MySQL. Very helpful. (1) This method is very useful. I always use this when simple queries of linking two tables is not
enough. This method is putting a query inside a query. Example: SELECT * FROM table1 LEFT JOIN
(SELECT * FROM table2 WHERE field1='id') AS subtable or joining multiple queries SELECT *
FROM (SELECT * FROM table1 WHERE userid='001') AS subtable1 LEFT JOIN (SELECT * FROM table2
WHERE field1='id') AS subtable2 You can join more than two queries depending on the output
you want. If someone already posted this topic here I'm sorry I don't know.....
Oracle Vs. Mysql Vs. Postgresql
POLL!! Choses you preferred db s/w! (9) Hey Everyone!, Please choose your preferred database s/w! Regards, Avell....
Login System Using A Mysql Db
How do i do this? (5) Hi guys, ive got a registration system that looks something like the one below: Firstname:
Lastname: Then i have inset.php, which looks like the following: $con =
mysql_connect("localhost","autobot","abc123"); if (!$con) { die('Could not connect: ' .
mysql_error()); }mysql_select_db("my_db", $con);$sql="INSERT INTO person (username, password) VALUES
('$_POST ','$_POST ')";if (!mysql_query($sql,$con)) { die('Error: ' .
mysql_error()); } echo "1 record added";mysql_close($con) ?> Now my question is, how do i creat....
Problems With Php Saving Data Into Mysql
HELP! I can't get my php documents to work with the mySQL (6) i have a server that says it allows php and mysql and in the control panel i can access mysqladmin
and phpmyadmin but i cant get the php to save data into the mysql, i am trying to make a text-based
MMOG so i need to save my users/passwords into a database(i thought) and it won't do it, can
anyone help me....
Mysql And Php
When trying to install Joomla (15) I don't know if this is the correct forum, but here is my question: I'm trying to test
Joomla and some forums in my computer, I have already installed MySQL with the GUI tools, Apache,
and PHP with the MySQL and MySQLi extensions, but when I'm trying to install Joomla I get this
error: Required Settings Check: ------------------------------------- PHP version >= 4.1.0
Yes - zlib compression support Available - XML support Available - MySQL support
Unavailable configuration.php Writeable Session save path Unwriteable Not ....
Permission Problem With Mysql Database Creation
Please Help! (8) I seem to have a problem with accessing my database with proper permissions. I have set the my
database correctly giving my db username all priviliges yet i seem to be unable to even log on with
this username with a denied access error. Any ideas on resolving this?....
Navcat For MySQL
is Navcat any good? (9) Hello all, i ve recently come across NavCat (GUI tool) for MySQL. I have not bought a copy yet, just
played around with the demo. Has any one used it beore, if so please let me know if its worth
buying. I already have PhpMyadmin, Just wanna know if NavCat is better than PhpMyAdmin in usibility
and functionality. Regards....
MySQL, Multiple Tables
(24) Ok, I'm coding a project which is a leap than what I'd normally do. Before, I've always
learned ONE table... put EVERYTHING in one database table. I'm making a profile system so there
needs to be at least two tables: 1 for users, 1 for content. My problem is, how do I link the two
together? I could probably figure this out faster if someone explained and posted sample SQL code
that shows how the two are linked together. Thanks!! F....
MySQL Output Database Question
(18) I am new to MySql and have just created a database after using a script. My problem is not the
script, but what it says about putting it into the output file. I cant figure out the right terms
to put it in, I keep getting errors. I try using; SELECT*FROM 'database name' WHERE
'location' but it isnt working. I'm lost with this stuff, I really am. Can someone
please help me out?....
How To Connect MySQL With Flash?
Help me connect my flash Work with MySql (8) I know Flash and mysql but could not figure out if I could ever connect these? I want to have a
dynamic content in my flash object that could be retrieved from the database directly without myself
needing to update it again and again. How can I achieve this ? Do I have to install any additional
controls or connectors to do that ? If yes any one tell me....
Mirror My MySQL Database To Another Mysql Server
(4) Hi..I want to ask if its possible to automatically mirror my mysql databases into another mysql
server?or create a small php script to do this? The reason is because, we all know that database is
very improtant if we have dynamic website. I have my forum hosted and i want to automatically
mirror this or backup into another mysql server(free). Like in freesql.org. So that im not afraid
that i forgot to backup my database..also i have one central backup database. Thanks for the
help..Im looking forward for this posibility.....
Recover Tables From A MySQL .frm File
(8) I have a couple of .frm files with no corresponding data or index files. Is it possible to recover
the table structure (field names, types, sizes, rows,col, etc) from these files? The table type is
innodb....
MySQL Realtime Replication
how to replicate mysql in realtime (4) i dont know if this might be useful to ppl here, but this is a very good knowledge for serious
siteadmins. while i was digging for mysql backup techniques, i've found that mysql is able to
do realtime replication. the idea is that there are master server and slave server. both are having
the same version of mysql installed. the data flows; Master >copy> Slave ( in realtime!)
you'll never have to manually copy the database file of wasting your time to manually use the
mysqldump command. here are the links; http://dev.mysql.com/doc/mysql/en/Replication_HOWTO.h....
MySQL - Trouble With Bulk Insert Statements
(3) I'm trying to insert about 500 rows into mysql, but I keep getting errors. If I copy and paste
too many (about 50) insert statements at a time I get errors sometimes. I sometimes even get errors
but then the row is skipped so I don't know there was an error (I'm using linux and SSH).
What's the best way to get my insert statements to put the data in MySQL? Is there anyway that I
can have it tell me if there where any errors all the statements are executed? Thanks for your
help.....
Looking for mysql, mysqli
|
*SIMILAR VIDEOS*
Searching Video's for mysql, mysqli
|
advertisement
|
|
