pwbiggs
Joined: 18 Dec 2007
Posts: 7
Posted: 2007-12-18 21:36
Back to top
Reply with quote
|
I thought I'd try phpMyEdit as I'm hoping it will save me lots of donkey work as I have a MySQL db with a large number of fields.
When I run phpMyEdit.setup for the first time I just get a blank screen. If I look at the source code I get this:
| Code: |
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<title>phpMyEdit Setup</title>
<style type="text/css">
<!--
body { font-family: "Verdana", "Arial", "Sans-Serif"; text-align: left }
h1 { color: #004d9c; font-size: 13pt; font-weight: bold }
h2 { color: #004d9c; font-size: 11pt; font-weight: bold }
h3 { color: #004d9c; font-size: 11pt; }
p { color: #004d9c; font-size: 9pt; }
table { border: 1px solid #004d9c; border-collapse: collapse; border-spacing: 0px; }
td { border: 1px solid; padding: 3px; color: #004d9c; font-size: 9pt; }
hr
{
height: 1px;
background-color: #000000;
color: #000000;
border: solid #000000 0;
padding: 0;
margin: 0;
border-top-width: 1px;
}
-->
</style>
</head>
<body bgcolor="white">
|
which looks very similar to the problem logged by Vto in
http://opensource.platon.sk/forum/projects/viewtopic.php?t=197
that was back in 2003 and I didn't understand the answer anyway.
I'm running Windoze XP (with all the latest updates), PHP 5.2.1, MySQL 5.0.22 and Apache 2.2.4.
My PHPInfoTest works OK, as does my own PHP files which call up fields from my two existing databases.
I'm not a total newbie but I dare say it's something obvious I'm not doing.
I call setup using
http://localhost/localhost/phpMyEdit-5.7.1/phpMyEditSetup.php
don't worry about the localhost/localhost, I've got a directory in my htdocs which I've called localhost which is where I do my testing, and another site called imagefair for my site that will eventually be uploaded.
The path for the setup file is C:\WebDev\Apache\htdocs\LocalHost\phpMyEdit-5.7.1 with the extns, images and language directories below them.
Hope someone can help, or I've a lot of tiresome hand coding to do.
Thanks
|
pwbiggs
Joined: 18 Dec 2007
Posts: 7
Posted: 2007-12-19 00:42
Back to top
Reply with quote
|
Hadn't thought of that. Just unset read-only for phpMyEdit-5.7.1 and sub directories, but it didn't make any difference.
Good idea though as stuff unzipped from the internet can arrive with read-only set.
|
pwbiggs
Joined: 18 Dec 2007
Posts: 7
Posted: 2007-12-19 01:08
Back to top
Reply with quote
|
Progress.
My php.ini has 'error_reporting = E_ALL & ~E_NOTICE' and 'display_errors = On' which I take to mean that errors are displayed.
I took out the '@'s (there's a lot of them!) and got
| Quote: |
| Fatal error: Call to undefined function mysql_pconnect() in C:\WebDev\Apache\htdocs\LocalHost\phpMyEdit-5.7.1\phpMyEditSetup.php on line 165 |
Line 165 is
| Quote: |
| $dbl = mysql_pconnect($hn, $un, $pw); |
I tried changing it to mysqli_pconnect... as all the calls I have used so far are the 'i' variant but it didn't change the error.
Now I have that error message to work with I can do more research, but if you've any ideas that would fix it I'd appreciate it.
Thanks for this progress anyway.
|
pwbiggs
Joined: 18 Dec 2007
Posts: 7
Posted: 2007-12-19 01:45
Back to top
Reply with quote
|
The only persistent in my phpinfo is in the odbc section.
I tried mysql_connect instead of pconnect and got the same error.
How do you mean 'use a different db connection' and how do I apply that large code section and what does it do?
I can't understand how or why the code should want to make a connection at this point before I've even given it a hostname, username or password. Presumably they are some sort of industry wide default used to find the SQL server?
|
pwbiggs
Joined: 18 Dec 2007
Posts: 7
Posted: 2007-12-19 02:17
Back to top
Reply with quote
|
Hmmm, that didn't work either with a username, password and database I know works in my code. I took out all the '@'s again and got the same error message, line 15 this time. Also tried the connect version.
It's gone 1 o'clock in the morning here now so I'll have to leave any more suggestions, assuming hopefully you have some for me, until the morning.
It's obviously going to be something with my setup rather than phpMyEdit being the problem.
If it helps, the database I tried to connect to I can connect to OK using
| Code: |
| mysqli_connect($host,$user,$password,$dbname) |
|
pwbiggs
Joined: 18 Dec 2007
Posts: 7
Posted: 2007-12-19 02:28
Back to top
Reply with quote
|
Additional...
If I rewrite those first few lines like this;
| Code: |
$host = "localhost";
$user = "Phillip";
$password = "helloagain";
$dbname = "inventory";
$table="household_inventory";
$persistent = '';
if($persistent == (bool) ini_get('allow_persistent')){
if(!$opts['dbh'] = mysqli_connect($host,$user,$password,$dbname)){
die(mysql_error());
} |
I get to line 31 before hitting the next error. I'll look into it more tomorrow, but it seems odd that my method worked.
Notice this uses the connect method. If I put in the pconnect method it errors again. Also, I use Zend Development and you know the auto-complete feature of these enviroments, well there isn't an auto complete for pconnect.
|
pwbiggs
Joined: 18 Dec 2007
Posts: 7
Posted: 2007-12-19 16:05
Back to top
Reply with quote
|
Going back to the original program. phpMyEdit's first piece of php code is;
| Code: |
<?php
if (! defined('PHP_EOL')) {
define('PHP_EOL', strtoupper(substr(PHP_OS, 0, 3) == 'WIN') ? "\r\n"
: strtoupper(substr(PHP_OS, 0, 3) == 'MAC') ? "\r" : "\n");
}
echo "LINE 61 <br><pre>"; var_dump($_POST); echo "</pre>";
$hn = $_POST['hn'];
$un = $_POST['un'];
$pw = $_POST['pw'];
if(strlen($_POST['db'])>0) $db = $_POST['db'];
if(strlen($_POST['tb'])>0) $tb = $_POST['tb'];
$id = $_POST['id']; |
The "echo 'Line 61... " bit is mine. My point is that this echo reveals an empty array, which to my way of thinking isn't surprising as I haven't got as far as posting anything yet. Not surprisingly therefore I get the
| Code: |
| Fatal error: Call to undefined function mysql_connect() in C:\WebDev\Apache\htdocs\LocalHost\phpMyEdit-5.7.1\phpMyEditSetup.php on line 165 |
when mysql_connect tries to use the $hn, $un, $pw values which are empty.
Is the start of the code supposed to look like this? It almost seems like I should be calling another program before this one.
|
musagoro
Joined: 10 Jun 2020
Posts: 1
Posted: 2020-06-10 05:47
Back to top
Reply with quote
|
Anyone who wants to work with PHP must have vast knowledge about its coding and tools. Otherwise, he will also see the
superiorpapers.com review
to guide himself to learn coding and tools.
|
ledam40306
Joined: 12 Aug 2020
Posts: 978
Posted: 2020-09-02 09:33
Back to top
Reply with quote
|
Interesting post. I Have Been wondering about this issue. so thanks for posting. Pretty cool post.It 's really very nice and Useful post.Thanks
https://royalcbd.com/wisconsin/
|
alexzender
Joined: 09 Aug 2020
Posts: 650
Posted: 2020-09-22 13:36
Back to top
Reply with quote
|
Your work here on this blog has been top notch from day 1. You've been continously providing amazing articles for us all to read and I just hope that you keep it going on in the future as well. Cheers! home nursing dubai https://firstresponse.ae/home-nursing-services/
|
nushra456789
Joined: 03 Oct 2020
Posts: 15
Posted: 2020-10-03 21:40
Back to top
Reply with quote
|
Regular visits listed here are the easiest method to appreciate your energy, which is why why I am going to the website everyday, searching for new, interesting info. Many, thank you
scan to pay
|
ledam40306
Joined: 12 Aug 2020
Posts: 978
Posted: 2020-10-28 09:38
Back to top
Reply with quote
|
I can see that you are an expert at your field! I am launching a website soon, and your information will be very useful for me.. Thanks for all your help and wishing you all the success in your business.
baangreen
|
alexzender
Joined: 09 Aug 2020
Posts: 650
Posted: 2020-10-29 05:40
Back to top
Reply with quote
|
pgslot new dimension of slot games Open a superior gaming experience of slots. Receive many bonuses, real distribution, real pay, no cheating
line7games
|
ledam40306
Joined: 12 Aug 2020
Posts: 978
Posted: 2020-11-02 10:15
Back to top
Reply with quote
|
Connect with us now to get help! We continue to pursue that same vision in today's complex, uncertain world, working every day to earn our customers’ trust!
Fastest Vehicle Assistance
|
nushra456789
Joined: 03 Oct 2020
Posts: 15
Posted: 2020-11-02 12:15
Back to top
Reply with quote
|
Instantly achieve sharper lines & more defined haircuts.Barber airbrush compressor kits starting at $147. Free worldwide shipping. Learn more.
cordless air compressor
|
|
Post new topic
Reply to topic
Goto page 1, 2, 3 ... 31, 32, 33 Next
|
Login
Registration
Slovak
