dsa89029 2014-10-15 09:01
浏览 56
已采纳

来自外部php文件的CRUD

Is it possible to outsource page.php's CRUD functions to functions.php, which is included in the former?

An example of this would be

functions.php

<?php
function store($tablename,$db,$id,$input,$coltype)
{
  $updateQ = sprintf("UPDATE %s SET %s = %s WHERE id=%s",
                       GetSQLValueString($tablename, "text"),
                       GetSQLValueString($coltype, "text"),
                       GetSQLValueString($input, "text"),
                       GetSQLValueString($id, "int"));
  mysqli_select_db($db, $conn);
  $result = mysqli_query($query, $conn) or die(mysql_error());
  return $result;
}
?>

Finally, functions.php is included in page.php, and the store function is simply called, to keep the display page relatively free of php code.

Would such a thing be possible/feasible to do which includes retrieving data as well? If yes, How would the resultset be returned and how can it be navigated?

My biggest constraint is that I cannot use a framework here, and some of the solutions I found online are to use frameworks like laravel which have boiler plate code ready.

  • 写回答

1条回答 默认 最新

  • doutangguali32556 2014-10-15 09:04
    关注

    include/require basically take the contents of the file being included, and treat it as if those those contents were literally part of the parent file. There's no functional difference between:

    single_script.php:

    <?php
    
    function foo(...) { ...}
    
    foo();
    

    and

    foo.php:

    <?php
    function foo(...) { ...}
    

    main.php:

    <?php
    include('foo.php');
    foo();
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
编辑
预览

报告相同问题?