I need PHP/MySQL (not too hard to find)- and POP/IMAP and SMTP would be nice. I don t mind spending a reasonable amount of money. The host has to say that it will host a .it domain- though.
Much appreciated!

For example xhtml- javascript- php- mysql- css...is there more or less and can you switch some out or what? Not just Myspace or Facebook but a website that requires member registration and login.

MediaWiki offers it- but I want something easy to deploy at home (single server- pHp or Python- Apache- MySQL). Open source solutions are preferred.

How can I export a SQL database to a flat file so that it can be replicated on another server?

Similar to a mysqldump...
It is SQL Server- but I don t have shell access. What type of file will bcp output?

I have a CSV format (saved from Excel spreadsheet) that I want to import to MySQL using PhpMyAdmin. I am not able to do that. The screen gives me three options: CSV- CSV Load Data- SQL. How can I convert the CSV to SQL format so I can import it? Do I have to get rid of table name on first row when I convert it to SQL format?

ive tried on and on again to figure out how to get the system ive thought of for my website to happen but so far ive only ruined my mysql and put errors on all my stuff and im tired of it. Can someone please help me php and script for my website. My plans are to make an account database for my website that allows people to have one account that they can upload videos to it- edit there profile and have friends and suscribers- Make it so they can play some flash games and put up there high score- make it so that they can put up a guild or clan website for them- and alot of other stuff. Im also working on a vip system so they pay monthly billing for all the extra stuff like with a free account you can only upload 3 videos per day but with the vip account you can upload as much as you want and with the video games- you can play for 30 minutes an hour with the free but with a vip you can play as much as you want. And for alot of accounts- you can pay only 5 dollars a month. Anybody. :D

I need help I ve been trying to get MySQL set up on my website for the past year so i can use wordpress and I can t get it to work. Every time I try it it says it can not connect to server or something else is wrong.

$group_ids = "6-2-7-74-75";

$sql = "SELECT count(*) as valid FROM ".$vb_prefix."user WHERE (membergroupids like

%$group_ids% or usergroupid= $group_ids ) and userid= " . $rut_row[ userid ] . " ";

Is there any way to make it check all of the listed usergroups in the MySQL code?

I found this account login code online:

<?php
require_once( connect.php );
$email = mysql_escape_string(trim(stripslashes($_...

if (!empty($email)) {
$query = "SELECT username- password FROM members WHERE email = $email ";
$result = mysql_query($query);
while ($row = mysql_fetch_object($result)) {
$username = $row->username;
$password = $row->password;
}
echo "Your username is $username";
echo "Your password is $password";
}
else {
echo "Please enter your email address!";
}

?>

My question is- isn t this very unsafe since if a malicious user does a little digging and finds a user s email address- they can pretty much get their password or am I incorrect? I have a mysql db and and trying to develop a secure php front end with user login. I haven t found any that use hashing algorythms.

I m playing with java jdbc with mysql- i ve had a webserver with mysql installed for awhile. The webserver is running Ubuntu linux.

I m trying to run a small java program i found somewhere to test the connection to the MySQL db. It will not connect with this error given:
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure.

But I sshed into my server and installed the jdbc driver and ran that program with localhost and it worked.

here s the line in the program that I tried to use to connect:
String url = "jdbc:mysql://myserversIP:3306/";

How can i narrow down the problem? Could it be the router? not allowing on that port or is the mysql server only allowing connections via localhost if so how do i change that? I created a new user for mysql and set the host to %.

thanks.

I was installing smf into my site- but when i click proceed- i get this:

Can t connect to local MySQL server through socket /var/run/mysqld/mysqld.sock (2)

i typed in all the info right- using localhost:3306 (default) as the server.
My hoster is Batcave.net- i have a subdomain- which gives 1 MySQL with enough kb for the site.

WHAT DO I DO??

I need the answers from a questionnaire to auto-populate portions of a report. We also need to create check boxes on the report and manually complete the report. The portions that don t get checked will hide/disappear from the report.

I have started in Drupal- but not sure how to complete it and wondering if it is the best option? I am not a programmer and need it to be user-friendly. Thank you!

heres the issue

Could Not Execute SQL Query ERROR:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near key- fname- lname- password- email) values( b0c72ca2804fcfe3ac43dd7bd48e5 at line 1

code:

$sql = "insert into temp_mems (key- fname- lname- password- email)
values( $code - $fname - $lname - $password - $email )";

$rs=mysql_query($sql- $con)or die ( Could Not Execute SQL Query ERROR: . mysql_error() );

any help?

$code=md5(uniqid(rand()- true));
is the code var and the table is fine its a problem with inserting the code its set to varchar 65 length not null and rest are defaults

heres the issue

Could Not Execute SQL Query ERROR:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near key- fname- lname- password- email) values( b0c72ca2804fcfe3ac43dd7bd48e5 at line 1

code:

$sql = "insert into temp_mems (key- fname- lname- password- email)
values( $code - $fname - $lname - $password - $email )";

$rs=mysql_query($sql- $con)or die ( Could Not Execute SQL Query ERROR: . mysql_error() );

any help?
sry $code=md5(uniqid(rand()- true)); is the code var and the table is fine its a problem with inserting the code its set to varchar 65 length not null and rest are defaults

How do I put it all together? How do I get my server to render images (png or jpg) into HTML webpages from a LaTeX code?

I have Apache web server- with the latest PHP and MySQL software.

I also have MikTeX and dvipng- etcetera... for converting LaTeX into images and pdfs.

But I cant get a web page that uses PHP to convert TeX and render it as an image.

Hello-
I just got the newest version of Joomla but I m having trouble finding a free sub-domain to host it on. Does anyone know of a free web hosting service that installs Joomla or has PHP- MySQL and Apache? Those are the three requirements to install Joomla but I know that there are some free web hosters that already offer Joomla installed. Please I need this urgently as I was charged with the duty of creating my schools website.

Thanks-

Pedro

Whenever I try to connect to my database- i always get the error "Can t connect to local MySQL server through socket /var/run/mysqld/mysqld.sock (2)". I ve heard that it has to do with the permission files but i tried changing the root and password- but nothing fixes the problem. If anyone knows how to solve this error it would be greatly appreciated.

I am new to MySQL and am planning my database now. I have a great interface that pretty much writes the database tables for me. My question is- I want to have users register with a username- password and email. Then it will send a confirmation email and if they confirm- it will create their account. They can then post to the db. How do I set up the tables for this? Do I create a separate table that contains the uername- password and email indexed by an account number and that account number is then a field in another table along with their postings? This is the way I envision it- but I am not sure this is the best way. Maybe there is an account creation script already written somewhere that is easy to use?
Thank you.

Three days ago i lost mysql access suddenly. All things are ok. I only receive a response from yahoo support.

"Alvaro- this is an ongoing issue that has been also reported by our customers. We are looking into any difficulties you reported in connecting/accessing or doing any activity with your MySQL database. We apologize for any inconvenience you may have experienced."

I dont receive any response more. I dont know how many time i have been without mysql access. I dont receive any response more. I dont know anything.

What can i do?

I dont know anything. Nobody solves my problem. Nobody tell me anything. Nobody help me.

I dont know anything.

Help!
phpmyadmin gives errors #2003 and #2013.
I run a wordpress blog.
Yahoo support dont tell me anything- nobody solve my problem. ¿What can i do?

I have the following code

function check_featured($prodID- $date){
$item = mysql_query("SELECT products_id- featured_date_added- expires_date FROM featured where products_id= $prodID ") or die(mysql_error());
$orders=mysql_fetch_array($item);
$num_rows=mysql_num_rows($item);
if($num_rows >0){
if($date >=$orders[ featured_date_added ] and $date <= $orders[ expires_date ]){
$featured = 1;}
else {$featured = 2; }
}
echo $featured;
return $featured;

}

It echos the variable $featured but does not return it and I don t know why any help is appreciated

I need to fetch a single result from my database that is that Maximum value of a single column- similar to SELECT MAX() but here s the catch- the table is set up so it has a column for "order" (as in arrangement within a page: 1 being top of the list and so on). The data is also sub divided into groups which is represented by a "groups" column- so "order" is relative strictly within a group. I need the query to be able to select the max value of "order" but only within the confines of "group x"
data needs to be able to be arranged in a specific order- (similar to a to do list). An order column was the best solution i could come up with- unless you have any suggestions.

Im quite new to PHP (been doing it for about 2 hours)- but not to MySQL databases. I only plan on using PHP once in my lifetime- and that is right now. I am designing a website at the moment that I would like to make a log-in interface for users. I have followed several guides- have the PHP done right- HTML done right etc. But I have a small problem- when I try to get the sign-up form to load the PHP page which is supposed to move the data into my database- I instead get a download popup asking me if I would like to open or save the PHP file. Im sure you can see my problem- any help would be appreciated.

By the way- this is only simple coding- so Im not using any fancy programs or anything. Ive seen this kind of thing done before on other peoples websites very easily- and from the guides Ive read- it should work. Is there line of code I need to put in my HTML file or PHP file to make it execute?
Well- the thing is its only a bare bones type of job at the moment- all on my PC.
*Does this need to be hosted to work?

I am about to start learning JSP . I want to setup an environment for that.. I have installe Tomcat server and now i can se ethe jsp pages through browser what i want to do next is work with jsp and mysql together i have installed mysql too but don t know which connector to use and where can i download ..
please help me find the right tools to make the jsp work with mysql i am an absolute beginner please explain the process.
thank you in advance

I m looking for a mysql-scritp that let me create a whole database with permissions and tables and relationships

Has anyone found an script like this ??

I am asking if i can hire someone and pay them for a system and tutorials on how to make a membership part of my website. I want the following and ill pay someone if they can php it for me:
1. Registration page
2. Connect it to mysql so when they create an account it goes to mysql.
3. Sign in Page
4. Profile Editing
5. Email System with a newsletter system.
6. Access Some Content Others Cant Do without an account.
7. A Credit Card System where i take there credit card and stuff.
8. A Shopping cart system.
9. A Paying System.
10. And a Support System.

If someone can do all that ill pay 50 dollars for it. Or depending on how cool it looks probably the price they choose.

I ve looked around on the web but I figured just to safe- I would ask someone who has knowledge about the details of MySQL and Apache.

I ve used both before but I can t seem to pick out the difference other then MySQL has somewhat of a GUI base to it via web browser for easy editing.

(Please- just don t give me links- but explain a few difference between them. Though the links are welcome nonetheless- it won t earn you any points just posting them.)

I’ve been told to develop a software that would enable users to upload and view the contents of a database. I’ve succeeded in the viewing aspect of the software but I’m having problem implementing the uploading of pictures in the software.

I want a table that can sort ascending and descending for 4 columns 3 columns will be words and 1 will be images (a rating system- highest stars to lowest stars and visa versa) Can somebody point me to a good example of this?

thanks.
Those just print it out in order. I need it so when i click on the header of a row it ascends or descends.

I can use mysql C api s
i want to upload file using C prg in BLOB field of mysql database.
I am able to successfully upload other data varchar- date- time- no and also can estabalish sql connection.

Hi-
I know php and mysql. I want to start a website myself which is useful to others. Like tutorials etc. I need few ideas on what to do. I even want to start a website that is targetted to my city. But was in a dilemma on what the people are in need now so that my business will be successful.
I am mentioning business because I want to give away information but also want to make money by advertisements.
Tierd of making websites. So- thought to stop it and want to make one for me and want to develop it.

Thanks in Advance.

does yahoo support php5 and mysql 5?

If Im using MySQL database- do I need to include the connect.php on every webpage Ive made to make sure its connect?

I always get an error while connecting to the MySQL for my account. I tried everything. Does anyone know what I should put in?

$10/year would be ideal
Thanks for the answers.. Looks like i wll get a better deal getting the domain reg and web host separately... point me to any domain reg sites.
i am looking for something like
vinodh.in
vinodhkumar.com
Thanks for the answers.. Looks like i wll get a better deal getting the domain reg and web host separately... point me to any domain reg sites.

Hi. I m new to java. I m using eclipse.
I m trying to write a data access layer- but i have no idea how to connect to mysql database. so the questions are:

How can i connect from java to a mysql database?
is there a jar file that i have to download?
do i need to istall anyhting for eclipse?

Thx
Wittigad that didn t work
i got a class not found exception

I m interested in running the open-source WordPress <http://wordpress.org/> blogging software and I was wondering if yahoo web hosting supports these:

PHP 4.3 or greater
MySQL 4.0 or greater
The mod_rewrite Apache module

ASP page connected to a mySQL database. The database text fields contain some special symbols- like french and german letters- how can I get ASP to display the characters correctly?

How do you make download links where its ?id=1- ?id=2- and so on? For example- if i were to have a page offering wallpaper downloads named "wallpaper.php" how can I make the download link of a wallpaper "wallpaper.php?id=#" where # is the wallpaper s ID number and afterwards it would take me to the wallpaper?

Through PHPMyAdmin- I m able to create tables in my database. However- when I try to create a View using a very simple SQL statement- I get an error!

Here is the statement:
CREATE VIEW myView AS SELECT * FROM utilisateur;

Here is the error message:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near VIEW myView AS Select * from utilisateur at line 1

Any ideas? I don t have duplicates names and the table utilisateur does exist. MYSQL is version 4.1.22

if the website is simple and contains one text area per page- so is it better to store this text in separate text files for each page in a folder- or a mysql database?

which one would you use?
and why?

Hi- I am making an auctions website. The query below returns items and their highest bid (amount = null if there are no bids).

How can I alter this query so that instead of returning the highest bid- it returns the second highest bid.

Thanks

select i.id-i.cat-i.title-i.end- max(a.amount) as amount from auction_item as i LEFT JOIN auction_itembids as a ON i.id = a.item WHERE i.end > 1209555636 GROUP BY i.id;
the end column is just a PHP time() timestamp.

Hi-

I m looking for a cheap and temporary web hosting site that requires no long term contract. I ll just need the site only for about a month- to upload my university project and be able to demonstrate it live. I would be needing the following:

- PHP4/5
- MySQL
- PhpMyAdmin
- SSL
- SMTP

Preferably instant activation and up and running of the site- and good technical support.

Any suggestions would be much appreciated.

Thanks.

I mean there are hosting services for free and databases- so if ever I created codes using php or whatever and I m connected to a database at home like mysql or postgresql- is it possible to maintain a system? like for filling out forms and storing it into the database?

I have attempted to install Magento e-commerce on my web server with Webcity.com.au- and have begun the install.php process- but in the third step I always get a message saying "PHP Extension "pdo_mysql" must be loaded". What us pdo_mysql and how do I install this on the server?

I have to pull some sales info from a mysql database I am checking to see if the product was featured for sales reporting. I have a table named featured that has two columns(there are more but I am just dealing with two) a date_added column and a date_expired. I don t know how to check to see if the date purchased is in between the date_added and the date_expired. How do I do this.

Can I do a simple if(date <= date_expired and >= date_added){ do something} is that possible when working with dates?

I would also want to have a database to load all the songs being discussed. Can anyone suggest a way to create such a database?

P.S: I have no idea about MySQL- Perl etc :(

ok so i have a data base with user name and password fields.
im using php/mysql. Now how do encrypt the passwod before they register into my database and then how will it decrypt it when user logs in. Also if they forgrt password i want to be able to send them the pasword by email so the forgottpasword.php will have to know how to decypt- right?
and last where do these codes go into-
these are the files i have register.php- login.php- forgotpassword.php- connect.php- logout.php

or do i have to make new files?
thanks

I downloaded and installed sjsas-9_1_01-mysql-windows.exe from http://java.com As I understand I will be able to access mysql databases. How should I do this? Can I get real examples how to connect to database- make quesries- take_results?

I would like to create my own ezine with php/mysql and need a clean good html generator that is simple clean and cheap. Is there a prepared product for php that I could use to create ezines or do I need to do the whole thing from scratch? Any help and direction of what i need to do would be helpful. I m a plsql programmer- so I know how to write theprocedures to display the html. I just need a clean html generator I can cut and paste from. Also- is there an easier way? Also- I"m looking cheap.

someone please- explaint to my what s MYSQL?

thank you so much.