SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 10:30 AM
| ||||
| ||||
 Connecting to localhost I migrated from SQLite to MySQL and have this portion of code: 50 $resource_1 = mysql_connect('localhost', 'user', 'pass'); 51 if ($resource_1) { echo "Connected!\n"; } 52 mysql_query($resource_1, 'DROP DATABASE IF EXISTS database_1;'); 53 mysql_query($resource_1, 'CREATE DATABASE database_1;'); 54 mysql_query($resource_1, 'CREATE TABLE table_1 ( column_1 integer NOT NULL PRIMARY KEY, column_2 integer );'); 55 mysql_query($resource_1, 'CREATE TABLE table_2 ( column_1 varchar(1024) NOT NULL PRIMARY KEY, column_2 integer );'); 56 mysql_close($resource_1); Can anyone explain me this result: Connected! <br /> <b>Warning</b>: mysql_query(): supplied argument is not a valid MySQL- Link resource in <b>/Users/mikhailkovalev/Sites/remains/remains.php</ b> on line <b>52</b><br /> <br /> <b>Warning</b>: mysql_query(): supplied argument is not a valid MySQL- Link resource in <b>/Users/mikhailkovalev/Sites/remains/remains.php</ b> on line <b>53</b><br /> <br /> <b>Warning</b>: mysql_query(): supplied argument is not a valid MySQL- Link resource in <b>/Users/mikhailkovalev/Sites/remains/remains.php</ b> on line <b>54</b><br /> <br /> <b>Warning</b>: mysql_query(): supplied argument is not a valid MySQL- Link resource in <b>/Users/mikhailkovalev/Sites/remains/remains.php</ b> on line <b>55</b><br />      |
|
02-28-2008, 10:30 AM
| |||
| |||
| Re: Connecting to localhost On 8 Des, 19:59, Mikhail Kovalev <mikhail_kova...@mail.ru> wrote: > I migrated from SQLite to MySQL and have this portion of code: > > 50 $resource_1 = mysql_connect('localhost', 'user', 'pass'); > 51 if ($resource_1) { echo "Connected!\n"; } > 52 mysql_query($resource_1, 'DROP DATABASE IF EXISTS > database_1;'); > 53 mysql_query($resource_1, 'CREATE DATABASE database_1;'); > 54 mysql_query($resource_1, 'CREATE TABLE table_1 ( column_1 > integer NOT NULL PRIMARY KEY, column_2 integer );'); > 55 mysql_query($resource_1, 'CREATE TABLE table_2 ( column_1 > varchar(1024) NOT NULL PRIMARY KEY, column_2 integer );'); > 56 mysql_close($resource_1); > > Can anyone explain me this result: > > Connected! > <br /> > <b>Warning</b>: mysql_query(): supplied argument is not a valid MySQL- > Link resource in <b>/Users/mikhailkovalev/Sites/remains/remains.php</ > b> on line <b>52</b><br /> > <br /> > <b>Warning</b>: mysql_query(): supplied argument is not a valid MySQL- > Link resource in <b>/Users/mikhailkovalev/Sites/remains/remains.php</ > b> on line <b>53</b><br /> > <br /> > <b>Warning</b>: mysql_query(): supplied argument is not a valid MySQL- > Link resource in <b>/Users/mikhailkovalev/Sites/remains/remains.php</ > b> on line <b>54</b><br /> > <br /> > <b>Warning</b>: mysql_query(): supplied argument is not a valid MySQL- > Link resource in <b>/Users/mikhailkovalev/Sites/remains/remains.php</ > b> on line <b>55</b><br /> $resource_1 = mysql_connect('localhost', 'hotreport', 'hotreport'); if ($resource_1) { echo "Connected!\n"; } var_dump($resource_1); Connected! resource(2) of type (mysql link) |
|
02-28-2008, 10:30 AM
| ||||
| ||||
| Re: Connecting to localhost On 8 Des, 20:01, Mikhail Kovalev <mikhail_kova...@mail.ru> wrote: > On 8 Des, 19:59, Mikhail Kovalev <mikhail_kova...@mail.ru> wrote: > > > > > I migrated from SQLite to MySQL and have this portion of code: > > > 50 $resource_1 = mysql_connect('localhost', 'user', 'pass'); > > 51 if ($resource_1) { echo "Connected!\n"; } > > 52 mysql_query($resource_1, 'DROP DATABASE IF EXISTS > > database_1;'); > > 53 mysql_query($resource_1, 'CREATE DATABASE database_1;'); > > 54 mysql_query($resource_1, 'CREATE TABLE table_1 ( column_1 > > integer NOT NULL PRIMARY KEY, column_2 integer );'); > > 55 mysql_query($resource_1, 'CREATE TABLE table_2 ( column_1 > > varchar(1024) NOT NULL PRIMARY KEY, column_2 integer );'); > > 56 mysql_close($resource_1); > > > Can anyone explain me this result: > > > Connected! > > <br /> > > <b>Warning</b>: mysql_query(): supplied argument is not a valid MySQL- > > Link resource in <b>/Users/mikhailkovalev/Sites/remains/remains.php</ > > b> on line <b>52</b><br /> > > <br /> > > <b>Warning</b>: mysql_query(): supplied argument is not a valid MySQL- > > Link resource in <b>/Users/mikhailkovalev/Sites/remains/remains.php</ > > b> on line <b>53</b><br /> > > <br /> > > <b>Warning</b>: mysql_query(): supplied argument is not a valid MySQL- > > Link resource in <b>/Users/mikhailkovalev/Sites/remains/remains.php</ > > b> on line <b>54</b><br /> > > <br /> > > <b>Warning</b>: mysql_query(): supplied argument is not a valid MySQL- > > Link resource in <b>/Users/mikhailkovalev/Sites/remains/remains.php</ > > b> on line <b>55</b><br /> > > $resource_1 = mysql_connect('localhost', 'hotreport', > 'hotreport'); > if ($resource_1) { echo "Connected!\n"; } > var_dump($resource_1); > > Connected! > resource(2) of type (mysql link) I am retarded.... Figured it out. As you were. |
Linear Mode
