pixie
pixie copied to clipboard
Select with special characters
Select query not working with special characters like( &,(), etc) in where clause.
Can you provide examples? What dabatase are you using?
I am using mysql database. example: $regional_data_tbl="abc"; $report_id="1234"; $node_data="Axillary (Level I, II & III) - Left";
$saved_data = $conn->table($regional_data_tbl)->setFetchMode(PDO::FETCH_ASSOC)->where('report_id', ' = ', $report_id)->where('specimen_id', ' = ', $val->id)->where('level_node', ' = ',$node_data)->get();