Hallo leute, heute habe ich mich gedacht, ich mache so ein youtube tutorial von FlashBuilding nach...
YouTube - Kanal von flashbuilding
Nun denn, die Dateien aus seiner Website rausgekramt und ausgeführt. Sein Test script läuft einwandfrei durch, aber: Wenn ich die datenbanken erstellen lassen will, kommt das:
Code
Success in database file CONNECTION.....
Warning: mysql_query() [function.mysql-query]: Access denied for user 'vu2001'@'localhost' (using password: NO) in /var/www/virtual/winfreak-online.de/htdocs/scripts/create_Table.php on line 36
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /var/www/virtual/winfreak-online.de/htdocs/scripts/create_Table.php on line 36
no TABLE created. You have problems in the system already, backtrack and debug!
So, hier mal die beiden Dateien:
connect_to_mysql.php:
Spoiler anzeigen
PHP
<?php
// Place db host name. Sometimes "localhost" but
// sometimes looks like this: >> ???mysql??.someserver.net
$db_host = "localhost";
// Place the username for the MySQL database here
$db_username = "winfreak";
// Place the password for the MySQL database here
$db_pass = "imnotdumbandshowmypw";
// Place the name for the MySQL database here
$db_name = "main";
// Run the connection here
$myConnecton = mysqli_connect("$db_host", "$db_username", "$db_pass", "$db_name") or die ("could not connect to mysql");
// Now you can use the variable $myConnection to connect in your queries
?>
Alles anzeigen
create_Table.php
Spoiler anzeigen
PHP
<?php
/*
Created By Adam Khoury @ www.flashbuilding.com
-----------------------June 19, 2008-----------------------
*/
// connect to your MySQL database here using the
// script we made in the previous step of this lesson
require_once "/var/www/virtual/winfreak-online.de/htdocs/scripts/connect_to_mysql.php";
// Tell ourselves on screen if we have connected
print "Success in database file CONNECTION.....<br />";
// Create the members main table in your new database
$result="CREATE TABLE myMembers (
id int(11) NOT NULL auto_increment,
firstname varchar(255) NOT NULL,
lastname varchar(255) NOT NULL,
address1 varchar(255) NOT NULL,
address2 varchar(255) NOT NULL,
state varchar(255) NOT NULL,
city varchar(255) NOT NULL,
zip varchar(255) NOT NULL,
phone varchar(255) NOT NULL,
bio_body text NOT NULL,
website varchar(255) NULL,
youtube varchar(255) NULL,
email varchar(255) NOT NULL,
password varchar(255) NOT NULL,
sign_up_date date NOT NULL default '0000-00-00',
last_log_date date NOT NULL default '0000-00-00',
account_type varchar(255) NOT NULL default 'client_type_1',
account_notes varchar(255) NOT NULL,
email_activated enum('0','1') NOT NULL default '0',
PRIMARY KEY (id),
UNIQUE KEY email (email)
) ";
if (mysql_query($result)){
echo "Success in TABLE creation!......
<br /><br /><b>That completes the table setup, now delete the file <br />
named 'create_Table.php' and you are ready to move on. Let us go!</b>";
} else {
echo "no TABLE created. You have problems in the system already, backtrack and debug!";
}
exit();
?>
Alles anzeigen
Ich hab schon alles so ziemlich probiert... es funzt auch ned, wenn ich eingebe
Was kann da der Fehler sein?
Es steht NIRGENDS dieser user drinne