dream07769 2016-03-08 14:22
浏览 294
已采纳

PHP到Postgres - 致命错误:调用未定义的函数pg_connect()

I've just set Postgres up on my Mac (El Capitan) and I am trying to connect to it via PHP... however, when I submit a sample form, I get "Fatal error: Call to undefined function pg_connect()". I've been researching this on Stack (which is how I got this far), but I'm not sure where I need to go from here.

Here's how I've put this together so far...

  • I use homebrew, and I ran brew install php55-pdo-pgsql.

  • I updated my Apache httpd.conf file, replacing LoadModule php5_module libexec/apache2/libphp5.so with LoadModule php5_module /usr/local/opt/php55/libexec/apache2/libphp5.so.

  • I restarted Apache.

I'm not sure if it's helpful here or not, but here's the PHP...

$name = $_POST['name'];
$species = $_POST['species'];

$conn = pg_connect("host=localhost dbname=menagerie user=root password=****");
pg_query($conn, "INSERT INTO pet (name, species) VALUES ('$name', '$species')");

What have I overlooked? Thanks very much.

  • 写回答

1条回答 默认 最新

  • dongnuo6310 2016-03-09 03:04
    关注

    Well, I don't know if this is the best solution, but I updated my PHP to version 5.6 and that took care of it.

    Documentation here - http://coolestguidesontheplanet.com/upgrade-php-on-osx/

    Hope that is helpful.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥500 我要找大模型一体机产品手册和应用案例
  • ¥60 用r语言进行数据分析
  • ¥20 关于游戏c++语言代码问题
  • ¥15 如何制作永久二维码,最好是微信也可以扫开的。(相关搜索:管理系统)
  • ¥15 delphi indy cookie 有效期
  • ¥15 labelme打不开怎么办
  • ¥35 按照图片上的两个任务要求,用keil5写出运行代码,并在proteus上仿真成功,🙏
  • ¥15 免费的电脑视频剪辑类软件如何盈利
  • ¥30 MPI读入tif文件并将文件路径分配给各进程时遇到问题
  • ¥15 pycharm中导入模块出错