[PHP] phpmyadmin mysql extensions
did the following... -installed apache -installed php (C:\PHP) with the windows installer -moved my websites to the htdocs folder..so far so good can access pages - downlaoded php my admin to htdocs -downloaded the FULL php version -copied the extensions folder (C:\PHP\ext) -changd the line in php.ini extension_dir = C:\PHP\ext - the extensions in .ini look like this ;extension=php_mbstring.dll ;extension=php_bz2.dll ;extension=php_curl.dll ;extension=php_dba.dll ;extension=php_dbase.dll ;extension=php_exif.dll ;extension=php_fdf.dll ;extension=php_filepro.dll ;extension=php_gd2.dll ;extension=php_gettext.dll ;extension=php_ifx.dll ;extension=php_imap.dll ;extension=php_interbase.dll ;extension=php_ldap.dll ;extension=php_mcrypt.dll ;extension=php_mhash.dll ;extension=php_mime_magic.dll ;extension=php_ming.dll extension=php_mssql.dll extension=php_msql.dll extension=php_mysql.dll ;extension=php_oci8.dll ;extension=php_openssl.dll ;extension=php_oracle.dll ;extension=php_pgsql.dll ;extension=php_shmop.dll ;extension=php_snmp.dll ;extension=php_sockets.dll ;extension=php_sqlite.dll ;extension=php_sybase_ct.dll ;extension=php_tidy.dll ;extension=php_xmlrpc.dll ;extension=php_xsl.dll The .dll file is in C:\PHP\ext\mysql Phpmyadmin cannot load I get the error Cannot load mysql extension. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpmyadmin mysql extensions
Move your dll's to C:\PHP\ext and restart apache... On Thu, 18 Jan 2007 10:20:23 -, Ross [EMAIL PROTECTED] wrote: did the following... -installed apache -installed php (C:\PHP) with the windows installer -moved my websites to the htdocs folder..so far so good can access pages - downlaoded php my admin to htdocs -downloaded the FULL php version -copied the extensions folder (C:\PHP\ext) -changd the line in php.ini extension_dir = C:\PHP\ext - the extensions in .ini look like this ;extension=php_mbstring.dll ;extension=php_bz2.dll ;extension=php_curl.dll ;extension=php_dba.dll ;extension=php_dbase.dll ;extension=php_exif.dll ;extension=php_fdf.dll ;extension=php_filepro.dll ;extension=php_gd2.dll ;extension=php_gettext.dll ;extension=php_ifx.dll ;extension=php_imap.dll ;extension=php_interbase.dll ;extension=php_ldap.dll ;extension=php_mcrypt.dll ;extension=php_mhash.dll ;extension=php_mime_magic.dll ;extension=php_ming.dll extension=php_mssql.dll extension=php_msql.dll extension=php_mysql.dll ;extension=php_oci8.dll ;extension=php_openssl.dll ;extension=php_oracle.dll ;extension=php_pgsql.dll ;extension=php_shmop.dll ;extension=php_snmp.dll ;extension=php_sockets.dll ;extension=php_sqlite.dll ;extension=php_sybase_ct.dll ;extension=php_tidy.dll ;extension=php_xmlrpc.dll ;extension=php_xsl.dll The .dll file is in C:\PHP\ext\mysql Phpmyadmin cannot load I get the error Cannot load mysql extension. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] PhpMyAdmin / MySQL
Hello All, I am using phpMyAdmin to administer my MySQl DB. I am running Mac OS Jaguar. when I try to start up phpMyAdmin I get an error: Welcome to phpMyAdmin 2.4.0 Error MySQL said: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) So I try to start up the MySQL Server manually by typing the following on my command prompt: and here are the results: [psg:/usr/local/mysql] psgarcha% sudo ./bin/mysqld_safe [1] 558 [psg:/usr/local/mysql] psgarcha% Starting mysqld daemon with databases from /usr/local/mysql/data 030616 10:16:32 mysqld ended Please help. Thanks in advance. --Pushpinder -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] phpmyadmin-mysql
Hello, I'm looking for code to display all my mysql databases in a select. On change, I want to display all my tables in a select. Finally, on change, it has to display all record of the table selected: Print Record id YR AU BT 1 1997 Fee, Margery Writing Orality: Interpreting Literature Display in English by Aboriginal Writers in North America, Australia and New Zealand Can someone give me a hand getting started? I would normally use phpmyadmin, but I want to customise something they don't offer.
Re: [PHP] phpmyadmin-mysql
Start with something like the following and add mysql_list_dbs () to query
the system for the available databases.
Hugh
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN
html
head
meta http-equiv=Content-Type content=text/html; charset=utf-8
titleInput Data Page/title
?php include (css.txt); ?
/head
body bgcolor=#1D3E81
h1font color=#33DATABASE TABLES/font/h1
form action=?php print $php_self? method=post
?php
print table cellpadding=7 border=1 bgcolor=#d5d5d5trtd;
print h6Database name:/h6input type=text name=db STYLE=width:140px
/tdtd;
print h6Password:/h6input type=text name=pass STYLE=width:140px;
print /tdtd valign=middle align=centerinput type=submit value=\ go
\;
print input type=hidden name=start value=1;
print /td/tr/table/formbr;
if ($start==1)
{
$link=mysql_connect(localhost,,$pass);
if (! $link) die(couldn't connect mysql);
mysql_select_db($db,$link) or die (couldn't open $db .mysql_error());
$tables=mysql_list_tables($db,$link);
$num=mysql_num_rows($tables)-1;
mysql_close($link);
?
form action=?php print $php_self? method=post
?php
print table cellpadding=7 border=1 bgcolor=#d5d5d5trtd;
print h6Table Name: /h6select type=text name=table
STYLE=width:140pxoption;
for ($i=0;$i=$num;$i++)
{
print option.mysql_tablename($tables,$i);
}
print /select;
print /tdtdinput type=submit value=\ go \;
print input type=hidden name=start value=2;
print input type=hidden name=db value=$db;
print input type=hidden name=pass value=$pass;
print /td/tr/table/formbr;
}
if ($start==2)
{
$link=mysql_connect(localhost,,$pass);
if (! $link) die(couldn't connect mysql);
mysql_select_db($db,$link) or die (couldn't open $db .mysql_error());
$results=mysql_query(select * from $table);
$fields = mysql_list_fields($db, $table, $link);
$columns = mysql_num_fields($fields);
mysql_close($link);
print table width=95% bgcolor=#d5d5d5 border=1 cellspacing=0
cellpadding=0trtd align=centerh3$table/h3;
print table width=100% bgcolor=#d5d5d5 border=1 cellspacing=0
cellpadding=4;
print tr;
for ($i = 0; $i $columns; $i++)
{
print td align=center bgcolor=#6c6c6ch5font
color=white.mysql_field_name($fields, $i)./font/h5/td;
}
print /tr;
print tr;
for ($i = 0; $i $columns; $i++)
{
print td align=center bgcolor=#fbfbfbh5.mysql_field_type($results,
$i)./h5/td;
}
print /tr;
while ($a_row=mysql_fetch_row($results))
{
print tr;
foreach($a_row as $field)
{
if ($field==)
{
$field=nbsp;;
}
print td align=centerh5.$field./h5/td;
}
print /tr;
}
print /table/td/tr/table;
}
?
/body
/html
- Original Message -
From: jtjohnston [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, February 17, 2002 7:34 PM
Subject: [PHP] phpmyadmin-mysql
Hello,
I'm looking for code to display all my mysql databases in a select.
On change, I want to display all my tables in a select.
Finally, on change, it has to display all record of the table selected:
Print Record
id YR AU BT
1 1997 Fee, Margery Writing Orality: Interpreting Literature
Display in English by Aboriginal Writers in North
America, Australia and New Zealand
Can someone give me a hand getting started?
I would normally use phpmyadmin, but I want to customise something they
don't offer.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
